Official description7 sourcesMCP servers8d ago

ofershap/mcp-server-sqlite

SQLite operations: query data

View on GitHub ↗Direct link · no redirect page

Config template (adjust for your client)

claude mcp add mcp-server-sqlite -- npx -y mcp-server-sqlite

A pasteable skeleton generated from the repository name. Check the project README for the exact package and arguments.

Star count: 4 ★ · ofershap/mcp-server-sqlite · read from the GitHub search API · (checked 2026-10-16 20:00:20)
Source: collected from the punkpeye/awesome-mcp-servers list · type: MCP server
Harvest history: first seen 2026-10-09 · last seen 2026-10-16 · seen 32× · listed by 7 sources
Score: score 703 · 4 ★ · 7 sources · mcp

FAQ (answers come from our records)

How do I install it?

We did not find an install command for this repository (our install coverage is only about 4%). Check its README or releases page.

Who is it for?

We filed it under these tags: MCP 服务. The tags come from the entry itself, not a taxonomy we imposed.

Who maintains it?

repository ofershap/mcp-server-sqlite；first catalogued 2026-10-09；last seen 2026-10-16。There is no official certification or quality rating here — we record sources and dates only.

Third-party quality signals

mcp-server-sqlite

以下摘录自该仓库的 README（片段） · 在 GitHub 读完整 README →

Query SQLite databases, inspect schemas, and explain queries from your AI assistant. Read-only by default for safety.
> 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
| 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:
Claude Desktop
Add to claude_desktop_config.json (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json):
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.