Awesome MCPDatabases

call518/MCP-PostgreSQL-Ops

⭐ 161 Python repository created 2025-08-19

MCP-PostgreSQL-Ops is a Model Context Protocol server aimed at database operators rather than application developers: it turns monitoring and maintenance questions into tool calls against a live PostgreSQL instance. All operations are read-only, which the project stresses as making it safe on production and compatible with managed services such as Amazon RDS and Aurora where superuser access is unavailable; a superuser sees every database and system view, but a regular account is enough for basic monitoring. Version detection is automatic and the tool set adapts to what the server supports, spanning PostgreSQL 12 through 18. Capabilities include performance analysis and slow query identification, schema and relationship discovery, table and database bloat detection with maintenance recommendations, real-time connection and lock monitoring, background process and checkpoint analysis, replication status and WAL monitoring, database capacity reporting, and vacuum plus autovacuum effectiveness analysis across several databases at once. Version-specific features are wired in as well: enhanced I/O statistics on PostgreSQL 16 and later, the wait event catalog with descriptions and WAL summarizer monitoring for incremental backups on 17 and later, and asynchronous I/O subsystem monitoring together with per-backend I/O and WAL statistics on 18. Most tools work with no extension installed, while pg_stat_statements and the optional pg_stat_monitor extension unlock deeper query analytics. The project ships as a PyPI package and a Docker image, and the bundled docker-compose stack starts a demo PostgreSQL instance seeded with roughly 83 thousand records, the MCP server, an MCPO proxy exposing a Swagger API, and OpenWebUI so the tools can be exercised from a chat interface. Connection settings come from environment variables in a .env file. Licensed MIT.

https://github.com/call518/MCP-PostgreSQL-Ops

mcpmcp-serverpostgresqldatabasemonitoringdbaobservabilitypython

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.