postgres-mcp
If you are the rightful owner of postgres-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Postgres MCP is a Model Context Protocol (MCP) implementation for PostgreSQL databases, providing a standardized interface for AI agents to interact with PostgreSQL databases through well-defined commands.
Postgres MCP is designed to facilitate seamless interaction between AI agents and PostgreSQL databases by implementing the Model Context Protocol (MCP). It offers a standardized interface that allows for efficient management of database connections and operations. The protocol supports a wide range of database operations, including executing queries, inserting, updating, and deleting records, as well as creating and dropping tables and indexes. Additionally, it includes a built-in SQL parser for validating statements and ensuring that only allowed operations are performed. Postgres MCP is built using Rust and requires PostgreSQL 12 or later, along with several Rust crates for its operation. It supports both standard input/output and Server-Sent Events (SSE) modes for communication.
Features
- Connection Management: Register and unregister database connections, support for multiple concurrent connections, and connection pooling for efficient resource management.
- Database Operations: Execute SELECT queries, insert, update, delete records, create/drop tables and indexes, describe table structures, and list tables in a schema.
- SQL Validation: Built-in SQL parser for validating statements with support for PostgreSQL-specific syntax and safety checks.
