MCP SQLite Server
Comprehensive SQLite database interaction over MCP: CRUD, introspection, and custom SQL queries.
Add to your client
Copy the config for your MCP client and paste it into its config file.
npx -y mcp-sqlite <path-to-your-sqlite-database.db>Paste into ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"mcp-sqlite-server": {
"command": "npx",
"args": [
"-y",
"mcp-sqlite",
"<path-to-your-sqlite-database.db>"
]
}
}
}Step-by-step guides: Add to Claude Desktop · Add to Cursor · Add to Windsurf
Before you start
- Node.js (npx) available on the host
- A path to an existing SQLite database file
About MCP SQLite Server
A Model Context Protocol server that provides comprehensive SQLite database interaction capabilities, including complete CRUD operations, database exploration and introspection, and execution of custom SQL queries. The database path is provided as a command argument and the server communicates over stdio.
Tools & capabilities (8)
db_infoGet detailed information about the connected database.
list_tablesList all tables in the database.
get_table_schemaGet detailed information about a table's schema. Parameters: tableName (string).
create_recordInsert a new record into a table. Parameters: table (string), data (object of key-value pairs).
read_recordsQuery records from a table with optional filtering. Parameters: table (string), conditions (object, optional), limit (number, optional), offset (number, optional).
update_recordsUpdate records in a table that match specified conditions. Parameters: table (string), data (object), conditions (object).
delete_recordsDelete records from a table that match specified conditions. Parameters: table (string), conditions (object).
queryExecute a custom SQL query against the connected SQLite database. Parameters: sql (string), values (array, optional) of parameter values.
What this server can do
MCP SQLite Server provides tools for these capabilities — tap one to see every MCP server that does the same:
When to use it
- Letting an AI assistant explore and query a local SQLite database
- Performing CRUD operations on application data through natural language
- Inspecting table schemas and database structure during development
- Running custom parameterized SQL queries from an AI client
Security notes
The server connects to whatever SQLite database file is passed as an argument and exposes full read/write access, including a `query` tool that executes arbitrary SQL. Point it only at databases you are willing to expose to the AI client.
MCP SQLite Server FAQ
How do I tell the server which database to use?
Pass the path to your SQLite database file as an argument, e.g. `npx -y mcp-sqlite <path-to-your-sqlite-database.db>`. The database path is required.
Which clients are supported?
Any MCP client that supports stdio servers. The README provides configuration examples for Cursor (mcpServers block) and VSCode (servers block).
Can it run arbitrary SQL?
Yes. The `query` tool executes custom SQL against the connected database and supports parameterized values via an optional `values` array.
Alternatives to MCP SQLite Server
Compare all alternatives →
Google's official MCP server with prebuilt BigQuery tools, querying datasets via Application Default Credentials.
Read/write Postgres access plus index tuning, EXPLAIN plans, and database health analysis for AI agents.
Official Supabase server: manage tables, run SQL, branches, configs and edge functions from your AI client.
Compare MCP SQLite Server with: