Awesome MCPDatabases

crystaldba/postgres-mcp

⭐ 3295 Python added to this list on 2025-05-06 repository created 2025-03-24

Postgres MCP Pro is an open-source Model Context Protocol (MCP) server designed specifically for PostgreSQL databases. It provides a comprehensive suite of features aimed at supporting AI agents and developers throughout the entire application lifecycle, from initial development and testing to deployment and production maintenance. The server offers configurable read/write access modes, allowing users to control the level of database interaction, which is particularly useful for differentiating between development and production environments. Key features of Postgres MCP Pro include advanced database health monitoring, which analyzes index health, connection utilization, buffer cache status, vacuum health, sequence limits, and replication lag. This helps maintain optimal database performance and reliability. The server also includes powerful index tuning capabilities, leveraging industrial-strength algorithms to explore thousands of potential indexes and identify the best configurations for specific workloads. Additionally, Postgres MCP Pro provides detailed query plan analysis through EXPLAIN plans, enabling users to validate and optimize query performance. It supports schema intelligence for context-aware SQL generation, which enhances the accuracy and efficiency of database queries. Safe SQL execution is another critical feature, with configurable access control and support for read-only modes and safe SQL parsing, ensuring secure operations in both development and production settings. The server supports multiple transport protocols, including Standard Input/Output (stdio) and Server-Sent Events (SSE), offering flexibility for integration in various environments. Installation options include Docker and Python, catering to different user preferences and system configurations. The project also provides detailed configuration instructions for integrating with popular AI assistant clients like Claude Desktop, Cursor, Windsurf, and Goose. Overall, Postgres MCP Pro is a robust and intelligent MCP server that enhances PostgreSQL database management and performance optimization, making it a valuable tool for developers and AI agents working with PostgreSQL databases.

https://github.com/crystaldba/postgres-mcp

access-controlai-agentsai-assistant-integrationapplication-lifecycleclaude-desktopcursordatabase-healthdockerexplain-plansgooseindex-tuningmcp-servermodel-context-protocolperformance-analysisperformance-optimizationpostgres-mcp-propostgresqlpythonquery-plansread/write-accessrestricted-modesafe-sql-executionschema-intelligenceserver-sent-eventsstandard-input/outputunrestricted-modewindsurf

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.

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.

benborla/mcp-server-mysql

mcp-server-mysql is a Model Context Protocol server that provides secure, read-only access to MySQL databases, enabling large language models to inspect schemas and execute SQL queries efficiently.