About Mcp Server Sqlite
An MCP server for developers inspecting SQLite databases through an AI assistant. It provides queries, schema details, and query-plan explanations, and is read-only by default with optional write access.
Key features
- 01Execute SQL queries
- 02Inspect database and table schemas
- 03Review columns and constraints
- 04Explain query plans
- 05List database files in a directory
Use cases
- 01Check tables and columns in a database
- 02Run queries and review results
- 03Inspect query plans to optimize SQL
MCP support
The server exposes SQLite query and inspection tools to compatible MCP clients and can be started with npx mcp-sqlite-server. It is read-only by default, with write access available by configuration.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
Tools
5Saved tool list · updated 3w ago
| Parameter | Type | Required | Description |
|---|---|---|---|
| db | string | Yes | Path to the .db or .sqlite file |
| sql | string | Yes | SQL query to execute |
| readonly | boolean | No | If true, only SELECT/PRAGMA/EXPLAIN allowed |
Details
From the project READMEmcp-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
.dbfiles, 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
| Tool | What it does |
|---|---|
query | Execute SQL (SELECT, PRAGMA, EXPLAIN, WITH). Returns results as a table. |
schema | Get full schema: all tables with columns, types, and row counts. |
table_info | Detailed info for a single table: columns, constraints, row count. |
explain | Run EXPLAIN QUERY PLAN to optimize queries. |
list_databases | List .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
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.