hannesrudolph/sqlite-explorer-fastmcp-mcp-server

Overview

An MCP server that provides safe, read-only access to SQLite databases through the Model Context Protocol. It is built with the FastMCP framework and includes built-in safety features and query validation for LLMs.

Best for

Best for
Developers who need to give LLMs safe, read-only access to SQLite databases

Use cases

• Allow LLMs to explore and query SQLite databases without write access
• Validate SQL queries before execution to prevent unsafe operations
• Enable database investigation in read-only mode for AI agents

How to use

Install

pip install -r requirements.txt

Tools exposed

• read_query
• list_tables
• describe_table

Tested with

Claude Desktop, Cline VSCode Plugin

Example client config

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

Notes

An MCP server that provides safe, read-only access to SQLite databases through the Model Context Protocol. It is built with the FastMCP framework and includes built-in safety features and query validation for LLMs.

105 stars on GitHub. Last updated 2025-07-18.

Use cases

• Allow LLMs to explore and query SQLite databases without write access
• Validate SQL queries before execution to prevent unsafe operations
• Enable database investigation in read-only mode for AI agents

Pros

• Read-only design prevents accidental data modification or corruption
• Built-in query validation reduces the risk of malformed or dangerous queries
• Leverages the FastMCP framework for efficient MCP compliance

Cons

• Only supports SQLite, limiting use to databases of that type
• Read-only access cannot be used for write or update operations
• Limited community adoption with 105 stars

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.