SQLite MCP Server

MCP server for SQLite databases — local files or remote Turso/libSQL via URL. 15 tools for query, schema, indexes, and optimization.

Quick Start

Local Database (Claude Desktop / Cursor)

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

Remote Database (Turso/libSQL)

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": ["-y", "@node2flow/sqlite-mcp"],
      "env": {
        "SQLITE_DB_URL": "libsql://your-db-name.turso.io",
        "SQLITE_AUTH_TOKEN": "your-auth-token"
      }
    }
  }
}

HTTP Mode

# Local
SQLITE_DB_PATH=/path/to/database.db npx @node2flow/sqlite-mcp --http

# Remote
SQLITE_DB_URL=libsql://your-db.turso.io SQLITE_AUTH_TOKEN=xxx npx @node2flow/sqlite-mcp --http

MCP endpoint: http://localhost:3000/mcp

Cloudflare Worker (Remote Only)

Available at: https://sqlite-mcp-community.node2flow.net/mcp

POST https://sqlite-mcp-community.node2flow.net/mcp?SQLITE_DB_URL=libsql://your-db.turso.io&SQLITE_AUTH_TOKEN=xxx

CF Workers have no filesystem — only SQLITE_DB_URL is supported.

---

Configuration

Variable	Required	Mode	Description
SQLITE_DB_PATH	No	Local	Path to SQLite file (creates if not exists)
SQLITE_DB_URL	No	Remote	Turso/libSQL URL (e.g. libsql://db.turso.io)
SQLITE_AUTH_TOKEN	No	Remote	Auth token for Turso (required with URL)
SQLITE_TIMEOUT	No	Local	Busy timeout in ms (default: 5000)

Priority: SQLITE_DB_URL > SQLITE_DB_PATH (if both set, URL wins)

---

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

---

Turso Setup

1. Install Turso CLI: curl -sSfL https://get.tur.so/install.sh | bash
2. Sign up: turso auth signup
3. Create database: turso db create my-database
4. Get URL: turso db show my-database --url
5. Get token: turso db tokens create my-database

Free tier: 500 databases, 9GB storage, 25M reads/month.

---

Docker

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

Mount database files or use remote URL:

services:
  sqlite-mcp-community:
    build: .
    ports:
      - "127.0.0.1:3025:3000"
    environment:
      # Local mode:
      - SQLITE_DB_PATH=/data/database.db
      # OR Remote mode:
      # - SQLITE_DB_URL=libsql://your-db.turso.io
      # - SQLITE_AUTH_TOKEN=your-token
    volumes:
      - ./data:/data

---

License

MIT License - see LICENSE

Copyright (c) 2026 Node2Flow

Links

• npm Package
• Turso — Hosted SQLite databases
• libSQL — Open source SQLite fork
• SQLite Documentation
• MCP Protocol
• Node2Flow