TL;DR

SQLite is a Databases MCP server that lets Claude Code, Cursor, Windsurf and any MCP-compatible AI agent local SQLite database access and management. Install in 1 minute with mcpizy install sqlite.

SQLite

Install verified 5 tools

Databases

Last updated September 23, 2026 · By MCPizy team

Local SQLite database access and management

Official homepage

Install SQLite

Via MCPizy CLI (recommended):

mcpizy install sqlite

Or run directly:

uvx mcp-server-sqlite --db-path ~/test.db

Tools exposed

5 tools available

read_query

Execute a SELECT query and return rows

Inputs

querystringrequired

write_query

Execute an INSERT/UPDATE/DELETE statement

Inputs

querystringrequired

create_table

Create a new table

Inputs

querystringrequired

list_tables

List all tables in the database

describe_table

Show the schema of a table

Inputs

table_namestringrequired

Configuration

Works identically across clients. Only the config file path differs.

Claude Code~/.claude.json

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "/path/to/database.db"
      ]
    }
  }
}

Cursor.cursor/mcp.json

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "/path/to/database.db"
      ]
    }
  }
}

Windsurf~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "/path/to/database.db"
      ]
    }
  }
}

Authentication setup

1
Point the server at a local .db file — no credentials needed
Get it

What you can do with SQLite MCP

Paste any of these prompts into Claude Code, Cursor or another MCP-compatible client.

“Show me the schema of the `users` table”

Uses: describe_table

“Count rows in every table in my database”

Uses: list_tables, read_query

“Insert a new user named 'Alice' with email [email protected]”

Uses: write_query

“Create a `sessions` table with columns id, user_id, expires_at”

Uses: create_table

Why SQLite MCP matters

SQLite MCP is the easiest database MCP to set up — point it at a `.db` file path and you're done. No connection strings, no credentials, no network. That makes it the natural choice for three workflows: prototyping a feature against a local schema, analysing a CSV/Parquet you've loaded into a local SQLite, and exposing a portable read-only dataset to an AI agent (think analytics datasets shipped as `.db` files).

What you actually do with it: `read_query` for SELECTs, `write_query` for INSERTs/UPDATEs, `create_table` and `list_tables` for schema work. Five tools, perfectly scoped. The MCP runs in the same process as your client (stdio transport), so latency is sub-millisecond — agent loops feel instant compared to a network DB.

The honest trade-offs: SQLite is single-writer (one writer at a time, readers concurrent), so this is not a server-grade DB. If your agent is doing parallel `write_query` from multiple subagents, you'll see lock contention. The other gotcha is that SQLite's type system is weak (declared types are advisory) — if the agent expects strict typing, you need `STRICT` table mode or explicit casts.

Where it beats Postgres MCP: portability (single file you can ship anywhere), simplicity (no auth, no network), and zero cold-start. Where Postgres wins: any production workload, any concurrent-write workflow, any need for advanced indexing or row-level security.

Common pitfalls

The MCP server expects an absolute path to the `.db` file — relative paths fail silently or open a brand-new empty database in the working directory of the client. If your queries return zero rows on a populated DB, check the resolved path with `ls -lh` before debugging the SQL.

Concurrent writes from multiple agent subagents will hit `database is locked` errors. SQLite serialises writers; for parallel work, either use a single agent or switch to Postgres MCP.

`write_query` does not auto-commit transactions in some SQLite MCP forks — verify by querying back after writing. If you see "table updated, count = 0", the transaction may have rolled back silently.

The schema introspection tools (`list_tables`, `describe_table`) read SQLite's `sqlite_schema` directly. Views appear in the table list but write operations against views fail unless you've set up `INSTEAD OF` triggers — the agent won't know that without explicit instructions.

How SQLite MCP compares

Honest pros/cons against the closest databases MCP servers.

Server	Strengths	Trade-offs
Postgres MCP	Production-grade, concurrent writers, rich indexing	Needs running server + connection string, no portability
DuckDB MCP	Columnar, blazing-fast analytics on Parquet/CSV, drop-in for SQLite	Newer, fewer client integrations, OLAP not OLTP
Supabase MCP	Full backend platform on top of Postgres	Massive overkill for single-file local analytics

Works with

Claude Code

Claude Desktop

Cursor

Windsurf

VS Code + Copilot

Any MCP Client

More Databases MCPs

⚡

DynamoDB

AWS DynamoDB NoSQL database operations

🪳

CockroachDB

Distributed SQL database for cloud apps

🌊

Neon

Interact with Neon serverless Postgres platform. Create databases, run migrations, and manage branches.

🐬

MariaDB

MariaDB relational database server

Alternatives to SQLite

If SQLite doesn't fit your stack, these Databases MCP servers solve similar problems.

🔵

Neo4j

Graph database queries

🔍

Elasticsearch

Full-text search and analytics engine

🎯

Qdrant

Vector similarity search engine

Frequently asked questions

What is the SQLite MCP server?

SQLite is listed as an Databases Model Context Protocol server whose documented purpose is to let an MCP-compatible agent local SQLite database access and management. Client support, permissions and authentication remain specific to the upstream project.

How do I install SQLite MCP with Claude Code?

The fastest way is the MCPizy CLI: run `mcpizy install sqlite` and MCPizy will add the server to your `.claude.json` automatically. You can also install it manually by adding an entry under `mcpServers` in `.claude.json` with the command `uvx mcp-server-sqlite --db-path ~/test.db` and restarting Claude Code.

Does MCPizy charge to view or install SQLite MCP?

No. Reading this profile and copying its install guidance is free. Upstream software, API, account or usage costs are separate, and licence coverage should be checked from the linked source when available.

Does SQLite MCP work with Cursor and Windsurf?

The MCP standard is supported by those clients, but a specific server can still have client-specific setup or transport limits. Use the configuration shown on this page when present and verify the upstream instructions before installation.

What can I do with SQLite MCP?

Its documented purpose is to let an MCP-compatible agent local SQLite database access and management. The exact tools, permissions and write capabilities depend on the server version and configuration shown by the upstream project.

Compare before you commit

Put this server beside an alternative, or return to the full evidence directory.

Compare MCP servers Back to directory