MCP Directory

How to add MCP SQLite Server to Claude Desktop

Comprehensive SQLite database interaction over MCP: CRUD, introspection, and custom SQL queries. Paste the config into ~/Library/Application Support/Claude/claude_desktop_config.json and restart Claude Desktop.

Last updated June 14, 2026 · 110★ · stdio · no auth

Claude Desktop config for MCP SQLite Server

npx -y mcp-sqlite <path-to-your-sqlite-database.db>
{
  "mcpServers": {
    "mcp-sqlite-server": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite",
        "<path-to-your-sqlite-database.db>"
      ]
    }
  }
}

Setup steps

  1. 1Open Claude Desktop → Settings → Developer → Edit Config (this opens ~/Library/Application Support/Claude/claude_desktop_config.json).
  2. 2Paste the MCP SQLite Server config below under the top-level "mcpServers" key.
  3. 3Fill in any placeholder secrets (API keys, paths) in the snippet.
  4. 4Save the file, then fully quit and reopen Claude Desktop.
  5. 5Open a chat and confirm MCP SQLite Server's tools appear under the 🔌 tools menu.

Before you start

  • Node.js (npx) available on the host
  • A path to an existing SQLite database file

What MCP SQLite Server can do in Claude Desktop

db_info

Get detailed information about the connected database.

list_tables

List all tables in the database.

get_table_schema

Get detailed information about a table's schema. Parameters: tableName (string).

create_record

Insert a new record into a table. Parameters: table (string), data (object of key-value pairs).

read_records

Query records from a table with optional filtering. Parameters: table (string), conditions (object, optional), limit (number, optional), offset (number, optional).

update_records

Update records in a table that match specified conditions. Parameters: table (string), data (object), conditions (object).

delete_records

Delete records from a table that match specified conditions. Parameters: table (string), conditions (object).

query

Execute a custom SQL query against the connected SQLite database. Parameters: sql (string), values (array, optional) of parameter values.

Security

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 + Claude Desktop FAQ

Where is the Claude Desktop config file?

Claude Desktop reads MCP servers from ~/Library/Application Support/Claude/claude_desktop_config.json. Paste the MCP SQLite Server config there under the "mcpServers" key and restart the client.

Is MCP SQLite Server safe to use with Claude Desktop?

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.

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.

View repo Full MCP SQLite Server page