📋 Copy MCP Install CLI { } Inspect JSON API Ground-Truth Source ↗

⚡ 1-Click Agent & Developer Install

Zero Auth · Ready for Grok Bot, Claude Code & Cursor

### Server Architecture & Capability Summary **SQLite & Datasette Local Analytics & Schema MCP Server** (`sqlite-mcp`) is a verified **STDIO** Model Context Protocol (MCP) server curated with **@simonw** for Grok Bot, Claude Code, and Cursor. Query local SQLite databases, run full-text FTS5 searches, create analytical views, and synthesize structured data memos directly from your agent workspace. ### 1-Click CLI Installation Run the command below to register `sqlite-mcp` in Claude Code or your MCP client: ```bash claude mcp add sqlite -- npx -y @modelcontextprotocol/server-sqlite --db-path ./data/app.db ``` ### Standard `mcpServers` JSON Configuration (`.cursor/mcp.json` / `claude_desktop_config.json`) ```json { "mcpServers": { "sqlite-mcp": { "command": "db-path", "args": [ "./data/app.db" ], "env": { "SQLITE_DB_PATH": "./data/app.db" } } } } ``` ### Exposed MCP Tools - `read_query` — Deterministic JSON-RPC 2.0 tool exposed by `sqlite-mcp`. - `write_query` — Deterministic JSON-RPC 2.0 tool exposed by `sqlite-mcp`. - `create_table` — Deterministic JSON-RPC 2.0 tool exposed by `sqlite-mcp`. - `list_tables` — Deterministic JSON-RPC 2.0 tool exposed by `sqlite-mcp`. - `describe_table` — Deterministic JSON-RPC 2.0 tool exposed by `sqlite-mcp`. ### Authentication & Environment Variables - **Transport Protocol:** `stdio` - **Auth Mechanism:** `none` - `SQLITE_DB_PATH`: `./data/app.db` - **Documentation / Source:** [https://github.com/modelcontextprotocol/servers](https://github.com/modelcontextprotocol/servers)

Tags: #sqlite-mcp#stdio#engineering#mcp-server#read-query#write-query

View All 16 Items by @simonw →

mcp · ⚡ 80

PostgreSQL Read/Write & Schema Introspection MCP Server

Connect AI agents directly to PostgreSQL databases for live table schema inspection, `EXPLAIN ANALYZE` query benchmarking, and safe read-only or transactio

mcp · ⚡ 79

PostgreSQL Analytics & Read-Replica Inspector MCP (mcp-postgres)

Zero-mutation PostgreSQL read-replica MCP server enforcing `SET TRANSACTION READ ONLY` on every query for safe executive BI, cohort analysis, and schema ex

mcp · ⚡ 92

SQLite Embedded Telemetry & Ledger MCP Server (mcp-sqlite)

Lightweight embedded SQLite MCP interface for local agent memory stores, evaluation benchmarks, and deterministic SQLite ledger auditing.