SQLite

by Model Context Protocol

v2025.4.25

Repository Docs

Databases & Data

databasesqlitesqlanalysis

Summary

Query, modify, and analyse a local SQLite database file directly from an AI client.

Features

Query and modify a local SQLite database
Schema inspection and table creation
Built-in business-intelligence prompt for analysis

Installation

Set up this MCP server in your favorite AI agent — copy a ready-made configuration below.

Any MCP-compatible agent

Most agents (Claude, Cursor, Windsurf, VS Code, and more) read a standard mcpServers configuration.

Open your agent's MCP configuration file.
Merge the snippet below into it.
Restart the agent — the "SQLite" tools will be available.

{
  "mcpServers": {
    "sqlite-reference": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "~/data.db"
      ]
    }
  }
}

Claude Code

Add the server with a single CLI command.

claude mcp add sqlite-reference -- uvx mcp-server-sqlite --db-path ~/data.db

Claude Desktop

Add the server to claude_desktop_config.json (Settings → Developer → Edit Config).

{
  "mcpServers": {
    "sqlite-reference": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "~/data.db"
      ]
    }
  }
}

Cursor

{
  "command": "uvx",
  "args": [
    "mcp-server-sqlite",
    "--db-path",
    "~/data.db"
  ]
}

Windsurf

{
  "command": "uvx",
  "args": [
    "mcp-server-sqlite",
    "--db-path",
    "~/data.db"
  ]
}

VS Code

{
  "command": "uvx",
  "args": [
    "mcp-server-sqlite",
    "--db-path",
    "~/data.db"
  ]
}

Description

The reference SQLite MCP server gives an assistant full access to a local database file — read, write, and schema operations — with no server process to run.

What it exposes

Read and write queries against the database, including creating tables and inserting rows
Schema inspection — list tables, describe columns, and understand relationships
An analysis prompt that guides the assistant through exploring a dataset and reporting findings, which is a genuinely useful starting point for ad-hoc analysis

Where it fits

SQLite is the natural format for anything small enough to be a file: exported data, local application state, scratch analysis, or a quick store an agent builds for itself. This server makes all of that directly addressable.

Because it allows writes, point it at a copy rather than the live database backing an application — the same advice as for any tool that will happily run DROP TABLE.

Installed with uvx mcp-server-sqlite --db-path path/to/file.db. Part of the MCP reference server collection.

Related MCP Servers

Featured

DBHub

by Bytebase

A universal database MCP server — one integration for PostgreSQL, MySQL, SQL Server, SQLite, and MariaDB.

Databases & Data

databasesqlmulti-database

Featured

MongoDB

by MongoDB

MongoDB's official MCP server — query databases, explore schemas, and manage Atlas clusters from an AI client.

Databases & Data

databasenosqlmongodb

Upstash Redis

by Upstash

Run Redis commands against Upstash's serverless Redis over HTTP, with documentation search built in.

Databases & Data

redisserverlesscache

dbt

by dbt Labs

dbt Labs' official MCP server — explore project metadata, run dbt commands, and query the Semantic Layer.

Databases & Data

datadbtanalytics

Browse all MCP servers →