MCP SQLite Server for Claude

Overview

The MCP SQLite Server is a lightweight MCP server that connects Claude to any local SQLite database file. Specify the path to your .db file as a command-line argument — no API keys, no credentials, no configuration needed. It provides full CRUD operations plus raw SQL execution. ISC licensed with 110+ stars.

Key capabilities

• Database info — get database path, size, and metadata.
• Table listing — list all tables in the connected database.
• Schema inspection — get column definitions and types for any table.
• CRUD operations — create, read, update, and delete records.
• Raw SQL — execute arbitrary SQL queries including DDL statements.

Tools

How it compares

MCP SQLite is the simplest path to reading and writing a local SQLite database from Claude — no credentials, no server, just a .db file path.

Installation

Claude Code

claude mcp add sqlite -- npx -y mcp-sqlite /path/to/database.db

Replace /path/to/database.db with the actual path to your SQLite file.

Claude Desktop

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

Requirements

• A local .db SQLite database file.
• Node.js (for npx).
• An MCP client (Claude Code or Claude Desktop).

Security

• The query tool allows full SQL — point at a copy or test database before using on production data.
• No external connections are made — all operations are local.
• No credentials or API keys required.

Source Verification Notes

Verified on 2026-06-18:

• Repository jparkerweb/mcp-sqlite (ISC) on npm as mcp-sqlite documents the npx -y mcp-sqlite /path/to/database.db install command, all eight tools (db_info, list_tables, get_table_schema, create_record, read_records, update_records, delete_records, query), and the zero-credential local-only architecture.
• Claude Code MCP documentation at code.claude.com/docs/en/mcp describes the stdio connector pattern used above.