Awesome MCPDatabases

hannesrudolph/sqlite-explorer-fastmcp-mcp-server

⭐ 107 Python added to this list on 2025-05-06 repository created 2024-12-15

SQLite Explorer MCP Server is a Python Model Context Protocol server, built on the FastMCP framework, that lets a language model explore and query a SQLite database without being able to modify it. It exposes three tools. read_query executes a SELECT statement against the database and returns rows as dictionaries; before running, the statement passes through validation and sanitisation so that only read operations are accepted, values can be bound as parameters rather than interpolated into SQL text, and a row limit caps how much data a single call can pull back. list_tables returns the names of all tables in the database. describe_table returns detailed schema information for one table, including column names and types, NULL constraints, default values and primary key information, which gives the model enough structure to write correct queries on its own. The safety posture is the point of the project: access is read-only by construction, queries are validated, parameter binding avoids injection through model-generated values, results are size-bounded, and progress output is suppressed so responses stay clean JSON. Configuration is a single environment variable, SQLITE_DB_PATH, holding the full path to the database file to explore, which also means one server process is scoped to one database. Requirements are Python 3.6 or later and the fastmcp package. The README documents two installation paths: installing into Claude Desktop with the fastmcp install command, passing the server script, a display name and the database path; and adding a JSON entry to the Cline VSCode plugin MCP settings that runs the script through uv with fastmcp and uvicorn. The repository also ships an mcp-documentation.txt file describing the MCP server implementation and FastMCP usage, kept as context for further development. It suits anyone who wants an assistant to answer questions over an existing SQLite file safely.

https://github.com/hannesrudolph/sqlite-explorer-fastmcp-mcp-server

mcp-serverpythonsqlitefastmcpdatabaseread-only

Also in Databases

dolthub/dolt

Dolt is a SQL database with Git-like version control capabilities, enabling users to manage, version, and collaborate on data and schemas as easily as code in Git repositories.

t8y2/dbx

DBX is a lightweight, cross-platform database client supporting over 70 databases, featuring a built-in AI assistant, MCP Server, and available as desktop, Docker, or CLI.

Canner/WrenAI

Open-source generative BI engine that exposes governed text-to-SQL, a semantic layer and dashboard generation to AI agents through an MCP server and CLI across more than twenty data sources.

googleapis/mcp-toolbox

MCP Toolbox for Databases is an open-source Model Context Protocol (MCP) server that connects AI agents, IDEs, and applications directly to enterprise databases, offering both pre-built and custom ...

makenotion/notion-mcp-server

The Notion MCP Server is an official MCP server implementation that enables secure, programmatic interaction with Notion content through MCP commands, optimized for AI agents and supporting multiple deployment options.

bytebase/dbhub

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface, enabling MCP clients to connect to and explore multiple database systems including MySQL, PostgreSQL, Oracle, SQL Server, MariaDB, and SQLite.

crystaldba/postgres-mcp

Postgres MCP Pro is an open-source Model Context Protocol server for PostgreSQL that provides advanced database health monitoring, index tuning, query plan analysis, and safe SQL execution to support AI agents and developers throughout the application lifecycle.

supabase-community/supabase-mcp

Supabase MCP Server connects Supabase projects to AI assistants using the Model Context Protocol, enabling LLMs to manage and query Supabase resources.