Awesome MCPDatabases

StarRocks/mcp-server-starrocks

⭐ 187 Python added to this list on 2025-05-14 repository created 2025-03-05

The StarRocks MCP Server is the official Model Context Protocol bridge between AI assistants and StarRocks clusters. It connects to a StarRocks frontend service over the MySQL protocol, by default at localhost:9030, and exposes database work as MCP tools so a client needs no additional driver setup. Tools include read_query for SELECT statements and write_query for DDL and DML commands. Database exploration is offered through starrocks:// resources that list databases and tables and return table schemas, while internal metrics and cluster state are reachable under a proc:// resource path. Two aggregate tools give condensed context: table_overview returns column definitions, row counts and sample rows for one table, and db_overview does the same across an entire database. Both overviews are cached in memory to make repeated requests cheaper, and the cache can be bypassed on demand. A query_and_plotly_chart tool executes a query and generates a Plotly chart from the result set. The server targets Python 3.11 or newer and is managed with uv, which resolves dependencies and creates the environment on first run, so the MCP host can launch it with uv run and no manual install step. Transport modes are selected with a mode flag covering stdio, http and streamable-http, with host and port options for the HTTP modes; streamable HTTP is the recommended mode and SSE is documented as deprecated. A test flag verifies connectivity before wiring the server into a client. Connection settings come from environment variables, either individually via STARROCKS_HOST, STARROCKS_PORT, STARROCKS_USER, STARROCKS_PASSWORD and STARROCKS_DB, or as a single STARROCKS_URL connection string; on macOS the password can instead be read from the Keychain. It is aimed at analysts and engineers who want conversational access to StarRocks data.

https://github.com/StarRocks/mcp-server-starrocks

mcpmcp-serverstarrocksdatabasesqlolappythonplotlyanalytics

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.