⚡ Pulse Score 92/100
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.
⚡ 1-Click Agent & Developer Install
Zero Auth · Ready for Grok Bot, Claude Code & Cursorclaude mcp add mcp-sqlite -- npx -y @modelcontextprotocol/server-sqlite --db-path ./ledger.db
Copy-Paste System Prompt / Routine Blueprint:
Connect to the SQLite Embedded Telemetry & Ledger MCP Server (mcp-sqlite) (mcp-sqlite) MCP server using `claude mcp add mcp-sqlite -- npx -y @modelcontextprotocol/server-sqlite --db-path ./ledger.db`. First run a read-only discovery check invoking `execute_select` to verify connectivity and credentials, then summarize the structured response and ask before executing any state-modifying tool calls.
Synthesized Engineering Blueprint & Setup Guide
### Server Architecture & Capability Summary
**SQLite Embedded Telemetry & Ledger MCP Server (mcp-sqlite)** (`mcp-sqlite`) is a verified **STDIO** Model Context Protocol (MCP) server curated with **@simonw** for Grok Bot, Claude Code, and Cursor.
Lightweight embedded SQLite MCP interface for local agent memory stores, evaluation benchmarks, and deterministic SQLite ledger auditing.
### 1-Click CLI Installation
Run the command below to register `mcp-sqlite` in Claude Code or your MCP client:
```bash
claude mcp add mcp-sqlite -- npx -y @modelcontextprotocol/server-sqlite --db-path ./ledger.db
```
### Standard `mcpServers` JSON Configuration (`.cursor/mcp.json` / `claude_desktop_config.json`)
```json
{
"mcpServers": {
"mcp-sqlite": {
"command": "db-path",
"args": [
"./ledger.db"
],
"env": {
"SQLITE_DB_PATH": "./ledger.db"
}
}
}
}
```
### Exposed MCP Tools
- `execute_select` — Deterministic JSON-RPC 2.0 tool exposed by `mcp-sqlite`.
- `inspect_pragma_stats` — Deterministic JSON-RPC 2.0 tool exposed by `mcp-sqlite`.
- `export_query_json` — Deterministic JSON-RPC 2.0 tool exposed by `mcp-sqlite`.
### Authentication & Environment Variables
- **Transport Protocol:** `stdio`
- **Auth Mechanism:** `none`
- `SQLITE_DB_PATH`: `./ledger.db`
- **Documentation / Source:** [https://github.com/modelcontextprotocol/servers](https://github.com/modelcontextprotocol/servers)
Tags: #mcp-sqlite#stdio#engineering#mcp-server#execute-select#inspect-pragma-stats
✓ CERTIFIED X BUILDER PORTFOLIO
More Capabilities Curated from @simonw
Related Verified Capabilities
Explore Engineering & DevOps → MCP Server ★ Featured Partner ✓ Claimed
⚡ 98
MCP Server ★ Featured Partner ✓ Claimed
⚡ 97
TranscriptAPI — Instant YouTube & Video Transcripts MCP Server
MCP Server ★ Featured Partner ✓ Claimed
⚡ 96
StayingAPI — Real-Time Hotel & Short-Term Stay Availability MCP
MCP Server ★ Featured Partner ✓ Claimed
⚡ 95
AdWhispr MCP — Autonomous Google, Meta & TikTok Ads Intelligence
Grok Template ✓ Claimed
⚡ 97
Dr. Eggbot — Meta-Agent Architect & Bot Builder
MCP Server ✓ Claimed
⚡ 89