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.
This is a Model Context Protocol (MCP) server that provides an interface to interact with PostgreSQL databases.
The PostgreSQL MCP Server is designed to facilitate seamless interaction with PostgreSQL databases through a standardized API. It allows users to execute SQL queries, perform various database operations such as INSERT, UPDATE, DELETE, and manage transactions efficiently. The server also provides tools to retrieve database schema information and ensures secure parameter handling to prevent SQL injection attacks. With its robust features, the PostgreSQL MCP Server is an ideal solution for developers looking to integrate PostgreSQL database operations into their applications with ease and security.
Features
- Execute SQL queries with parameterized inputs
- Perform database operations (INSERT, UPDATE, DELETE)
- Execute transactions with multiple statements
- Retrieve database schema information
- Secure parameter handling to prevent SQL injection
Tools
execute_tool
Executes a single SQL statement.
query_tool
Executes a SELECT query and returns the results.
transaction_tool
Executes multiple statements in a transaction.
schema_tool
Retrieves schema information for a table.