SQLite MCP

Official SQLite server — query, analyze, and modify local SQLite databases through natural language with full SQL support.

TRUSTED · Official

Database

// Add to your client

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": ["mcp-server-sqlite", "--db-path", "/path/to/your.db"]
    }
  }
}

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": ["mcp-server-sqlite", "--db-path", "/path/to/your.db"]
    }
  }
}

claude mcp add sqlite -- uvx mcp-server-sqlite --db-path /path/to/your.db

Paste into your client's MCP configuration file.

// Try it now

"Open the SQLite database file at ./data.db and describe what's inside"

! SQLite locks the file while writing — other processes can't write simultaneously
! The file path the server uses must be readable by the process running the MCP server
! No type enforcement by default — columns can hold mixed types unless STRICT mode is on

Setup

Easy Setup

API key or simple config

Token usage

Light usage

// When to use

You have a .db or .sqlite file and want to explore its contents
You're debugging a local app that stores data in SQLite (Electron apps, mobile backups)
You need a zero-setup database for AI to manipulate during a task
You're learning SQL and want a local sandbox

// When NOT to use

You're working with multi-user production databases (use Postgres or MySQL)
You need high write concurrency — SQLite is single-writer
You need network access — SQLite is file-based only

// Usage Scenarios

Database File Exploration

Open a random .sqlite file and get a natural-language overview of what it contains.

Example prompt

"Open the file data.db and tell me what tables are in it and what they seem to store"

Local App Debugging

Inspect the SQLite database an Electron or mobile app uses to store state.

Example prompt

"Show me the last 20 entries in the messages table from this app.db file"

Quick Data Analysis

Run SELECT queries over a data export saved as SQLite.

Example prompt

"Calculate the average transaction amount per month from the transactions table"

// About

Plain English

Imagine pointing your AI at a SQLite file and asking: 'What's in this database?' or 'Find all rows where amount is over 100' — and it reads the file directly. This server lets your AI open and query SQLite database files through conversation — great for exploring exported data, legacy systems, or local app databases.

The official SQLite MCP server gives AI assistants direct access to local SQLite databases. Execute queries, inspect schemas, insert and update records, and perform data analysis — all through natural language that gets translated to proper SQL.

Ideal for local data exploration, prototype databases, and development workflows.

GitHub 42.0kUpdated Feb 10, 2025MIT

View on GitHub @modelcontextprotocol/server-sqlite