twn39/pgsql-mcp-server
A powerful tool server based on the Model Context Protocol (MCP), enabling interaction with PostgreSQL databases via MCP calls.
uvx pgsql-mcp-server --dsn "postgresql://user:password@localhost:5432/db"This project is built on the FastMCP framework and leverages the SQLAlchemy and asyncpg libraries to deliver high-performance asynchronous database operations, ensuring efficiency and responsiveness when handling database requests.
Asynchronous & Efficient: Fully asynchronous implementation based on asyncio, utilizing asyncpg for a high-performance asynchronous PostgreSQL driver.
Transactional Safety: DDL, DML, and DCL operations are executed within transactions with error handling and rollback mechanisms.
Easy Deployment: Start the server with a simple command line interface.
get_columns
Get detailed column information for a specific table.
get_indexes
Get index details for a specific table.
get_foreign_keys
Get foreign key constraints for a specific table.
run_dql_query
Execute Data Query Language (DQL) statements like SELECT, SHOW, EXPLAIN.
run_dml_query
Execute Data Manipulation Language (DML) statements like INSERT, UPDATE, DELETE.
run_ddl_query
Execute Data Definition Language (DDL) statements like CREATE, ALTER, DROP.
run_dcl_query
Execute Data Control Language (DCL) statements like GRANT, REVOKE.
Details on this page are taken from the project's README. Open README
supabase-community/supabase-mcp
The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.
googleapis/genai-toolbox
MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.
alexander-zuev/supabase-mcp-server
Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.
MobinX/awesome-mcp-list
This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.
stuzero/pg-mcp-server
PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.
bytebase/dbhub
[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.