SQLite MCP Server

Query SQLite databases, inspect schemas, and explain queries from your AI assistant. Read-only by default for safety. Its 5 documented tools cluster into read & search, schema, table, explain. It runs locally over stdio via the published package.

People connecting database tools to Claude, Cursor, VS Code, or another MCP client. The project is written in TypeScript.

VERIFIED ACTIVE

LAST COMMIT 2026-03-10 · ★ 3 · #99 OF 151 MAINTAINED DATABASE · VERIFIED 2026-08-25

MIT · TypeScript servers · how we verify → /methodology

01 · Install SQLite

Claude Code

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

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "ofershap-mcp-server-sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite-server"
      ]
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions

license MIT - declared in the repository

npm package mcp-sqlite-server - unscoped; check the name against the project README before installing

registry namespace io.github.ofershap is GitHub-verified and matches the repo owner

03 · What SQLite can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

What you can build

With this server connected, an agent can get full schema: all tables with columns, types, and row counts, and list .db, .sqlite, .sqlite3 files in a directory.

Capability map

Tools grouped from the project's README - what SQLite lets an agent do.

read & search

2 tools - e.g. Execute SQL (SELECT, PRAGMA, EXPLAIN, WITH). Returns results as a table.; List .db, .sqlite, .sqlite3 files in a directory.

query · list_databases

Schema

1 tool - e.g. Get full schema: all tables with columns, types, and row counts.

schema

Table

1 tool - e.g. Detailed info for a single table: columns, constraints, row count.

table_info

Explain

1 tool - e.g. Run EXPLAIN QUERY PLAN to optimize queries.

explain

04 · Who maintains SQLite

sqlite is maintained by ofershap. We track 15 MCP servers from ofershap - 15 actively maintained, 92 combined GitHub stars, oldest repo from Feb 2026. Full record: all servers from ofershap.

05 · Facts

repository: github.com/ofershap/mcp-server-sqlite
category: database - ranked #99 of 151 actively-maintained database servers as of 2026-08-25.
registry: io.github.ofershap/sqlite (active, first published 2026-03-10)
packages: npm:mcp-sqlite-server

06 · SQLite FAQ

Is SQLite still maintained?

Yes - as of 2026-08-25, its last commit was 2026-03-10. We re-verify nightly.

What can SQLite do?

With this server connected, an agent can get full schema: all tables with columns, types, and row counts, and list .db, .sqlite, .sqlite3 files in a directory.

How do I install SQLite?

Run `npx -y mcp-sqlite-server`. You can also paste the ready-made client config above.

Does SQLite run locally?

Yes - it's a stdio server: it runs on your machine (via npx) with your user's permissions. Your data stays local unless the server itself calls external APIs.

07 · Alternatives to SQLite

Alternatives to SQLite

Maintained database servers if SQLite isn't the fit.

Pairs well with

Servers that cover what SQLite doesn't - only shown when the pairing reason fits the companion.

More database MCP servers · GLEIF MCP Server · Ouestcharlie Woof · Hit Keep · Arangodb Async · Postgres MCP

More TypeScript MCP servers · Microsoft 365 Admin · Clio MCP · Mycase MCP · Singapore MCP by Olano · Composer · see all