mcp-to-db

Expose any SQLite database as read-only MCP tools for AI assistants.

mcp-to-db is an MCP (Model Context Protocol) server that turns a SQLite database into a set of tools AI assistants can use — list tables, inspect schemas, and run SELECT queries with filtering, ordering, and pagination. Data modification is intentionally blocked.

Quick start

pnpm install
pnpm db:push       # create tables
pnpm seed          # load sample data
pnpm dev           # start server on http://127.0.0.1:3000/mcp

The sample data is an e-commerce database with 3 users, 5 products, 4 orders, and 9 order items — ready for testing.

Related MCP server: DataBook

Tools

The server exposes three read-only tools:

query-table details

{
  "table": "orders",
  "columns": ["id", "status", "total", "created_at"],
  "where": [{ "column": "status", "operator": "=", "value": "paid" }],
  "orderBy": { "column": "created_at", "direction": "desc" },
  "limit": 20,
  "offset": 0
}

All where conditions are ANDed together. Maximum limit is 1000 rows.

Schema

The sample e-commerce schema:

• users — id, email, name, created_at

• products — id, name, description, price (cents), stock, created_at

• orders — id, user_id → users, status (pending/paid/shipped/delivered/cancelled), total (cents), created_at

• order_items — id, order_id → orders, product_id → products, quantity, unit_price (cents)

Usage with MCP clients

Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "ecommerce-db": {
      "command": "pnpm",
      "args": ["--dir", "/path/to/mcp-to-db", "dev"]
    }
  }
}

Any MCP client

Point your client to http://127.0.0.1:3000/mcp.

Scripts

Adapting to your own database

1. Edit src/schema.ts — define your Drizzle ORM tables.

2. Run pnpm db:push to create tables.

3. Optionally update or replace seed.ts.

4. Start the server with pnpm dev.

The tool registration in src/tools.ts and all three tool implementations are schema-agnostic — they adapt to whatever tables you define.

How it works

┌──────────────┐    MCP/HTTP      ┌─────────────────────┐
│  AI Assistant │ ◄─────────────► │  MCP Server (3000)   │
│  (Claude, etc) │    tools        │  list-tables         │
└──────────────┘                  │  describe-table      │
                                  │  query-table         │
                                  └─────────┬───────────┘
                                            │
                                      ┌─────▼─────┐
                                      │  SQLite    │
                                      │  (better-  │
                                      │  sqlite3)  │
                                      └───────────┘

Built with:

• MCP SDK — Model Context Protocol server framework

• Drizzle ORM — Type-safe SQL query builder

• better-sqlite3 — Synchronous SQLite driver

• Zod — Input validation

License

MIT