English Français العربية

io.github.ofershap/sqlite

Official registry Data and databases

SQLite MCP — query databases, inspect schemas, explain queries, export data.

Source code Documentation

Install

Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).

NPM package mcp-sqlite-server
Claude Code 
claude mcp add sqlite -- npx -y mcp-sqlite-server@1.0.1
JSON configuration (Claude Desktop, Cursor, VS Code) 
{
    "mcpServers": {
        "sqlite": {
            "command": "npx",
            "args": [
                "-y",
                "mcp-sqlite-server@1.0.1"
            ]
        }
    }
}

Documentation

From the project's README on GitHub, refreshed weekly. Links open on GitHub.

Contents
  1. mcp-server-sqlite
  2. Why
  3. Tools
  4. Quick Start
  5. Example prompts
  6. Safety
  7. Development
  8. See also
  9. Author
  10. License

mcp-server-sqlite

Query SQLite databases, inspect schemas, and explain queries from your AI assistant. Read-only by default for safety.

npx mcp-sqlite-server

Works with Claude Desktop, Cursor, VS Code Copilot, and any MCP client. Reads local .db files, no auth needed.

Demo built with remotion-readme-kit

Why

SQLite is everywhere. It's the default database for mobile apps, Electron apps, local-first tools, and increasingly for server-side projects too (Turso, Cloudflare D1, Bun's built-in SQLite). The official MCP reference includes a basic SQLite server, but it's Python-only. If you're working in a TypeScript/Node.js environment and want to ask your assistant "what tables are in this database?" or "run this query and show me the results," this server handles that. It opens the database read-only by default so you can explore safely, and you can opt into write mode when you need it.

Tools

ToolWhat it does
queryExecute SQL (SELECT, PRAGMA, EXPLAIN, WITH). Returns results as a table.
schemaGet full schema: all tables with columns, types, and row counts.
table_infoDetailed info for a single table: columns, constraints, row count.
explainRun EXPLAIN QUERY PLAN to optimize queries.
list_databasesList .db, .sqlite, .sqlite3 files in a directory.

Quick Start

Cursor

Add to .cursor/mcp.json:

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": ["mcp-sqlite-server"]
    }
  }
}
Claude Desktop

Add to claude_desktop_config.json (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json):

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": ["mcp-sqlite-server"]
    }
  }
}
VS Code

Configure the MCP server in your VS Code settings to run npx mcp-sqlite-server.

Example prompts

  • "Show me the schema of my database at ./data.db"
  • "Query the users table: SELECT \* FROM users LIMIT 10"
  • "Explain the query plan for this complex join"
  • "What tables are in this database?"
  • "Find all .db files in the current directory"

Safety

Read-only by default. The query tool accepts only SELECT, PRAGMA, EXPLAIN, and WITH in readonly mode. Set readonly=false in the tool args to enable INSERT, UPDATE, DELETE, etc.

Development

npm install
npm run typecheck
npm run build
npm test
npm run format
npm run lint

See also

More MCP servers and developer tools on my portfolio.

Author

README built with README Builder

License

MIT © 2026 Ofer Shapira

Frequently asked questions

What is io.github.ofershap/sqlite?

SQLite MCP — query databases, inspect schemas, explain queries, export data.

How do I install io.github.ofershap/sqlite?

It runs on your machine. In Claude Code: claude mcp add sqlite -- npx -y mcp-sqlite-server@1.0.1. For other clients, paste the JSON configuration from this page into their MCP settings.

Does io.github.ofershap/sqlite need an API key?

Its registry entry lists no required key or secret. Some features may still need an account with the service it connects to.

Is io.github.ofershap/sqlite open source?

Yes. Its code is on GitHub under the MIT license.

Who maintains io.github.ofershap/sqlite?

It is published by ofershap. AI.tn lists it but does not maintain or endorse it.

From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.