Package Exports

@node2flow/sqlite-mcp
@node2flow/sqlite-mcp/dist/index.js

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (@node2flow/sqlite-mcp) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

SQLite MCP Server

MCP server for SQLite databases — query, manage schema, indexes, and optimize through 15 tools.

Quick Start

Claude Desktop / Cursor

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

HTTP Mode

SQLITE_DB_PATH=/path/to/database.db npx @node2flow/sqlite-mcp --http
# MCP endpoint: http://localhost:3000/mcp

Configuration

Variable	Required	Description
`SQLITE_DB_PATH`	Yes	Path to SQLite database file (creates if not exists)
`SQLITE_TIMEOUT`	No	Database busy timeout in milliseconds (default: 5000)

Tools (15)

Query & Execute (3)

Tool	Description
`sqlite_query`	Execute SELECT query, return rows as JSON
`sqlite_execute`	Execute write statement (INSERT/UPDATE/DELETE/CREATE)
`sqlite_run_script`	Execute multiple statements in transaction

Schema Inspection (4)

Tool	Description
`sqlite_list_tables`	List all tables with row counts
`sqlite_describe_table`	Get columns, types, constraints
`sqlite_list_indexes`	List indexes for a table
`sqlite_list_foreign_keys`	List foreign key constraints

Schema Management (3)

Tool	Description
`sqlite_create_table`	Create new table with column definitions
`sqlite_alter_table`	Add column, rename column, rename table
`sqlite_drop_table`	Drop a table

Index Management (2)

Tool	Description
`sqlite_create_index`	Create index on columns
`sqlite_drop_index`	Drop an index

Database Management (3)

Tool	Description
`sqlite_get_info`	Database metadata (size, tables, journal mode)
`sqlite_vacuum`	Optimize and compact database
`sqlite_integrity_check`	Check database health

Docker

docker compose up -d
# Endpoint: http://localhost:3025/mcp

Mount your database files via volumes:

services:
  sqlite-mcp-community:
    build: .
    ports:
      - "127.0.0.1:3025:3000"
    environment:
      - SQLITE_DB_PATH=/data/database.db
    volumes:
      - ./data:/data

License

MIT License - see LICENSE

@node2flow/sqlite-mcp