SQLite Explorer MCP Server

Safe, read-only SQLite database exploration and querying for LLMs, built on FastMCP.

Unverified

stdio (local)

No auth

Stale

Python

View repo 105

Add to your client

Copy the config for your MCP client and paste it into its config file.

Install / run

pip install -r requirements.txt

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "sqlite-explorer-mcp-server": {
      "command": "uv",
      "args": [
        "run",
        "--with",
        "fastmcp",
        "--with",
        "uvicorn",
        "fastmcp",
        "run",
        "/path/to/repo/sqlite_explorer.py"
      ],
      "env": {
        "SQLITE_DB_PATH": "/path/to/your/database.db"
      }
    }
  }
}

Step-by-step guides: Add to Claude Desktop · Add to Cursor · Add to Windsurf

Before you start

Python 3.6+
A SQLite database file (path set via the SQLITE_DB_PATH environment variable)
fastmcp (installed via requirements.txt)

About SQLite Explorer MCP Server

SQLite Explorer is a FastMCP-based MCP server that gives LLMs safe, read-only access to a SQLite database. It supports running validated SELECT queries with parameter binding and row limits, listing tables, and inspecting table schemas. The database file is chosen via the SQLITE_DB_PATH environment variable, and it can be installed for Claude Desktop (via fastmcp install) or the Cline VSCode plugin.

Tools & capabilities (3)

read_query

Execute a SELECT query on the database with built-in safety validations: query validation and sanitization, parameter binding support, row limit enforcement, and results formatted as dictionaries.

list_tables

List all available tables in the database with their names.

describe_table

Get detailed schema information for a specific table, including column names and types, NULL constraints, default values, and primary key information.

What this server can do

SQLite Explorer MCP Server provides tools for these capabilities — tap one to see every MCP server that does the same:

Execute SQL Inspect database schema

When to use it

Letting an LLM safely explore and query a SQLite database without write access
Inspecting database structure by listing tables and describing their schemas
Running parameterized read-only SELECT queries with enforced row limits

Security notes

Read-only access to SQLite databases. Queries are validated and sanitized, parameter binding is used for safe execution, and a row limit is enforced. The target database file is specified via the SQLITE_DB_PATH environment variable.

SQLite Explorer MCP Server FAQ

Can this server modify my database?

No. The server provides read-only access. It only runs validated SELECT queries; queries are validated and sanitized, parameter binding is used, and a row limit is enforced.

How do I tell the server which database to use?

Set the SQLITE_DB_PATH environment variable to the full path of the SQLite database file you want to explore.

Which clients are documented for installation?

The README documents installing for Claude Desktop using `fastmcp install sqlite_explorer.py --name "SQLite Explorer" -e SQLITE_DB_PATH=/path/to/db`, and for the Cline VSCode plugin via its MCP settings JSON.

#sqlite #database #read-only #fastmcp #python #sql

Alternatives to SQLite Explorer MCP Server

Compare all alternatives →

MCP Toolbox for Databases (BigQuery)

Databases

16k

Google's official MCP server with prebuilt BigQuery tools, querying datasets via Application Default Credentials.

Verified

stdio (local)

OAuth

10 tools

Updated 15 days agoRepo

Postgres MCP Pro

Databases

2.9k

Read/write Postgres access plus index tuning, EXPLAIN plans, and database health analysis for AI agents.

Verified

stdio (local)

API key

Python

9 tools

Updated 3 months agoRepo

Supabase MCP Server

Databases

2.7k

Official Supabase server: manage tables, run SQL, branches, configs and edge functions from your AI client.

Verified

HTTP (remote)

OAuth

TypeScript

12 tools

Updated 1 month agoRepo

Compare SQLite Explorer MCP Server with:

vs MCP Toolbox for Databases (BigQuery)vs Postgres MCP Pro vs Supabase MCP Server vs Neon MCP Server