sqlite

This is a server that allows you to operate SQLite databases via MCP (Model Context Protocol). At startup, you register multiple databases in the form of "alias=path", and when calling tools, you select the database by alias name. It is safe because it does not accept arbitrary file paths at runtime.

Features (Tools)

• list_databases — Displays a list of aliases for registered databases

• list_tables — Displays a list of all table names in the specified database

• describe_table — Retrieves the schema of the specified table (columns/types/foreign keys/indexes)

• read_query — Executes SELECT / WITH / PRAGMA (read-only)

• write_query — Executes INSERT / UPDATE / DELETE / DDL (data changes)

list_tables/describe_table/read_query/write_query accept an optional database argument (alias name). If only one database is registered, it can be omitted (it automatically becomes the default). If two or more are registered, the database argument is required each time.

Related MCP server: MCP SQLite Server

Setup

npm install

Startup

Start by specifying one or more databases in the format alias=path.

node index.js main=/path/to/main.db logs=/path/to/logs.db

When registering only one (in this case, the database argument can be omitted):

node index.js main=/path/to/main.db

Environment Variables

Usage Examples

// 登録済みDB一覧を確認
{ "tool": "list_databases", "arguments": {} }

// "main" DBのテーブル一覧
{ "tool": "list_tables", "arguments": { "database": "main" } }

// "logs" DBに対してクエリ
{ "tool": "read_query", "arguments": { "sql": "SELECT * FROM events", "database": "logs" } }

// DBが1つしか登録されていない場合は database 省略可
{ "tool": "read_query", "arguments": { "sql": "SELECT * FROM users" } }

Registering with an MCP Client

Claude Desktop

Add the following to claude_desktop_config.json (specify paths as absolute paths according to your environment):

{
  "mcpServers": {
    "sqlite": {
      "command": "node",
      "args": [
        "/絶対パス/sqlite-mcp-server/index.js",
        "main=/絶対パス/main.db",
        "logs=/絶対パス/logs.db"
      ]
    }
  }
}

After configuration, restart Claude Desktop and the sqlite server tools will become available.

Claude Code (CLI / VS Code Extension)

Register using the claude command from a terminal in VS Code or a regular terminal.

claude mcp add --transport stdio sqlite -- node /絶対パス/sqlite-mcp-server/index.js main=/絶対パス/main.db logs=/絶対パス/logs.db

• Everything after -- is passed as-is as the server startup command.

• To make it read-only, add --env SQLITE_READONLY=1:

  claude mcp add --transport stdio --env SQLITE_READONLY=1 sqlite -- node /絶対パス/index.js main=/絶対パス/main.db

• The default is local scope (only your current project). Use --scope user to use it across all projects, or --scope project to share it as .mcp.json with your team.

  claude mcp add --transport stdio --scope user sqlite -- node /絶対パス/index.js main=/絶対パス/main.db

Checking and deleting registered entries:

claude mcp list
claude mcp remove sqlite

When you open the Claude Code panel in VS Code (or start a claude session), tools such as list_databases and read_query become available.

Notes

• For write_query, we recommend using ? placeholders as a measure against SQL injection (the params argument).

• Table names are validated to allow only alphanumeric characters and underscores.

• Alias names can only contain alphanumeric characters, underscores, and hyphens.

• Connections to each database are opened on first access and reused thereafter. All are closed when the server terminates.

• No databases other than the aliases registered at startup can be accessed (no arbitrary paths are accepted).

• If connecting to a production database, consider starting with SQLITE_READONLY=1.