mcp-registry/sqlite-explorer-fastmcp-mcp-server

    ==================
      
       /// MCP ///
      /// SQL ///
        
    ==================
        
    [server:online]
    [protocol:ready]

sqlite-explorer-fastmcp-mcp-server

by hannesrudolph

An MCP server that provides safe, read-only access to SQLite databases through Model Context Protocol (MCP).

79
20
Open Source
GitHub

01

read_query

Execute a SELECT query on the database with validation and sanitization, supports parameter binding, enforces row limits, and returns results as dictionaries.

02

list_tables

List all available tables in the database by name.

03

describe_table

Retrieve detailed schema information for a specified table, including columns, data types, NULL constraints, default values, and primary key details.

Installation

1. Prerequisites
• Python 3.9+
• SQLite ≥ 3.35
2. Clone the repository
git clone https://github.com/hannesrudolph/sqlite-explorer-fastmcp-mcp-server.git cd sqlite-explorer-fastmcp-mcp-server
3. Create and activate a virtual environment (recommended)
python -m venv .venv source .venv/bin/activate # Windows: .venv\Scripts\activate
4. Install Python dependencies
pip install -r requirements.txt
5. Point the server to one or more SQLite databases
• Copy your database(s) into the data/ folder OR
• Export an absolute path via environment variable:
export MCP_SQLITE_DB_PATH=/absolute/path/your.db
6. (Optional) Configure port or host
export MCP_HOST=0.0.0.0 export MCP_PORT=8000
7. Launch the MCP server
python -m fastmcp_server # or: uvicorn mcp_server.app:app --host $MCP_HOST --port $MCP_PORT
8. Verify it is running
curl http://localhost:8000/health The server now exposes its MCP tool endpoints on /v1/tools.

Documentation

License: No license file detected (proprietary / unspecified)
Updated 7/30/2025
sqlite-explorer-fastmcp-mcp-server - MCP Server Registry - Augment Code