SQLite Explorer

Provides read-only access to SQLite databases via MCP with query validation and safe exploration.

python

GitHub Stars

python

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "mcp-mirror-hannesrudolph_sqlite-explorer-fastmcp-mcp-server": {
      "command": "uv",
      "args": [
        "run",
        "--with",
        "fastmcp",
        "fastmcp",
        "run",
        "/path/to/repo/sqlite_explorer.py"
      ],
      "env": {
        "SQLITE_DB_PATH": "YOUR_DATABASE_PATH"
      }
    }
  }
}

You can explore SQLite databases safely with read-only access using the SQLite Explorer MCP Server. Built on the FastMCP framework, it lets you ask questions about your data through well-defined tools while enforcing safety and query validation.

How to use

You interact with the server through an MCP client. Use the provided tools to examine and query your SQLite database without modifying it. The available tools let you run SELECT queries with safety checks, list tables, and inspect table schemas. All results are delivered as structured dictionaries, making it easy to integrate into your workflows.

How to install

Prerequisites you need before installing this MCP server:

Python 3.6+
An accessible SQLite database file for exploration

Install project dependencies from the project’s requirements file using Python’s package manager.

pip install -r requirements.txt

Option 1: Install for Claude Desktop

Install the MCP server using the FastMCP workflow. This option integrates with Claude Desktop for MCP-based exploration.

fastmcp install sqlite_explorer.py --name "SQLite Explorer" -e SQLITE_DB_PATH=/path/to/db

Option 2: Install for Cline VSCode Plugin

Configure the Cline VSCode plugin to run the MCP server locally. Add the following settings to the plugin configuration to start the server with FastMCP.

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

Safety features

The MCP server provides read-only access to SQLite databases and enforces strong safety measures. It validates and sanitizes queries, binds parameters to prevent injection, enforces row limits, and suppresses verbose progress output to ensure clean JSON responses.

Environment variables

Set the path to your SQLite database so the server can explore it safely.

Available tools

read_query

Execute a SELECT query on the database with built-in safety validations. Includes query validation, parameter binding, 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.

Built by

VeilStrat

AI signals for GTM teams