Server data from the Official MCP Registry
SQLite MCP — query databases, inspect schemas, explain queries, export data.
SQLite MCP — query databases, inspect schemas, explain queries, export data.
Valid MCP server (2 strong, 4 medium validity signals). No known CVEs in dependencies. Package registry verified. Imported from the Official MCP Registry. Trust signals: trusted author (14/15 approved).
8 files analyzed · 1 issue found
Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.
This plugin requests these system permissions. Most are normal for its category.
Add this to your MCP configuration file:
{
"mcpServers": {
"io-github-ofershap-sqlite": {
"args": [
"-y",
"mcp-sqlite-server"
],
"command": "npx"
}
}
}From the project's GitHub README.
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
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.
| 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. |
Add to .cursor/mcp.json:
{
"mcpServers": {
"sqlite": {
"command": "npx",
"args": ["mcp-sqlite-server"]
}
}
}
Add to claude_desktop_config.json (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json):
{
"mcpServers": {
"sqlite": {
"command": "npx",
"args": ["mcp-sqlite-server"]
}
}
}
Configure the MCP server in your VS Code settings to run npx mcp-sqlite-server.
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.
npm install
npm run typecheck
npm run build
npm test
npm run format
npm run lint
More MCP servers and developer tools on my portfolio.
README built with README Builder
MIT © 2026 Ofer Shapira
Be the first to review this server!
by Toleno · Developer Tools
Toleno Network MCP Server — Manage your Toleno mining account with Claude AI using natural language.
by mcp-marketplace · Developer Tools
Create, build, and publish Python MCP servers to PyPI — conversationally.
by Microsoft · Content & Media
Convert files (PDF, Word, Excel, images, audio) to Markdown for LLM consumption
by mcp-marketplace · Developer Tools
Scaffold, build, and publish TypeScript MCP servers to npm — conversationally
by mcp-marketplace · Finance
Free stock data and market news for any MCP-compatible AI assistant.
by Taylorwilsdon · Productivity
Control Gmail, Calendar, Docs, Sheets, Drive, and more from your AI