SQLite Tools MCP Server

A Model Context Protocol (MCP) server for safe, local SQLite database operations. It gives MCP clients explicit read, write, schema, transaction, CSV, backup, and maintenance tools. Its 22 documented tools cover database, table, schema, transaction.

People connecting database tools to Claude, Cursor, VS Code, or another MCP client. The project is written in TypeScript.

VERIFIED ACTIVE

LAST COMMIT 2026-08-24 · ★ 19 · #30 OF 151 MAINTAINED DATABASE · VERIFIED 2026-08-25

MIT · TypeScript servers · how we verify → /methodology

01 · Install SQLite Tools

before you install - you'll need

Set SQLITE_DEFAULT_PATH, SQLITE_ALLOW_ABSOLUTE_PATHS, SQLITE_BUSY_TIMEOUT before connecting. SQLITE_BACKUP_PATH is optional or environment-specific per the README.

Claude Code

claude mcp add spences10-mcp-sqlite-tools -- npx -y mcp-sqlite-tools

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "spences10-mcp-sqlite-tools": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite-tools"
      ]
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions

license MIT - declared in the repository

npm package mcp-sqlite-tools - unscoped; check the name against the project README before installing

registry namespace io.github.spences10 is GitHub-verified and matches the repo owner

03 · What SQLite Tools can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

What you can build

With this server connected, an agent can open an existing database, close one database connection, find database files in a directory, and read file and SQLite metadata.

Capability map

Tools grouped from the project's README - what SQLite Tools lets an agent do.

Database

6 tools - e.g. Open an existing database; Close one database connection; Read file and SQLite metadata

open_database · close_database · database_info · backup_database · create_database · vacuum_database

Table

3 tools - e.g. Read columns and constraints; Create a table from validated columns; Drop a table and its data

describe_table · create_table · drop_table

run & execute

3 tools - e.g. Run one SQLite read-only statement; Run INSERT, UPDATE, or DELETE; Run one schema statement

execute_read_query · execute_write_query · execute_schema_query

read & search

2 tools - e.g. Find database files in a directory; List tables and views

list_databases · list_tables

Export

2 tools - e.g. Export a table or read-only query; Export schema as SQL or JSON

export_csv · export_schema

Import

2 tools - e.g. Import a headered CSV file; Apply SQL or JSON schema objects

import_csv · import_schema

Bulk

1 tool - e.g. Insert records in batches

bulk_insert

Begin

1 tool - e.g. Begin a transaction or nested savepoint

begin_transaction

Latest releases

v0.1.0 · 2026-08-16

Highlights · Replaced better-sqlite3 with Node's built-in node:sqlite driver. · Removed the native addon install step and reduced the clean production dependency footprint from 31.3 MB to 3.6 MB. · Preserved read-only…

04 · Who maintains SQLite Tools

mcp-sqlite-tools is maintained by spences10. We track 3 MCP servers from spences10 - 3 actively maintained, 382 combined GitHub stars, oldest repo from Mar 2025. Full record: all servers from spences10.

05 · Facts

repository: github.com/spences10/mcp-sqlite-tools
category: database - ranked #30 of 151 actively-maintained database servers as of 2026-08-25.
release cadence: 1 release in the last 90 days (latest 2026-08-16)
registry: io.github.spences10/mcp-sqlite-tools (active, first published 2025-09-10)
packages: npm:mcp-sqlite-tools

06 · SQLite Tools FAQ

Is SQLite Tools still maintained?

Yes - as of 2026-08-25, its last commit was 2026-08-24 and it shipped 1 release in the last 90 days. We re-verify nightly.

What can SQLite Tools do?

With this server connected, an agent can open an existing database, close one database connection, find database files in a directory, and read file and SQLite metadata.

How do I install SQLite Tools?

Run `npx -y mcp-sqlite-tools`. The README documents 4 environment variables (SQLITE_DEFAULT_PATH, SQLITE_ALLOW_ABSOLUTE_PATHS, SQLITE_BUSY_TIMEOUT…) to set first. Set SQLITE_DEFAULT_PATH, SQLITE_ALLOW_ABSOLUTE_PATHS, SQLITE_BUSY_TIMEOUT before connecting. SQLITE_BACKUP_PATH is optional or environment-specific per the README. You can also paste the ready-made client config above.

Does SQLite Tools run locally?

Yes - it's a stdio server: it runs on your machine (via npx) with your user's permissions. Your data stays local unless the server itself calls external APIs.

07 · Alternatives to SQLite Tools

Alternatives to SQLite Tools

Maintained database servers if SQLite Tools isn't the fit.

Pairs well with

Servers that cover what SQLite Tools doesn't - only shown when the pairing reason fits the companion.

More database MCP servers · Turso Cloud · Sqlsure · StackQL MCP Server · DB MCP Server · Polar Health Data (self-hosted)

More TypeScript MCP servers · Interactive Leetcode MCP · Brainstorm MCP · Saga MCP · Timebook · see all