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.
A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
The PostgreSQL Model Context Protocol (MCP) server is designed to facilitate read-only interactions with PostgreSQL databases. It allows Language Model Machines (LLMs) to access and inspect database schemas, as well as execute read-only SQL queries. This server is particularly useful for applications that require database insights without the risk of data modification. By leveraging the server, users can gain a comprehensive understanding of the database structure, including table schemas, column names, and data types. The server operates within a secure environment, ensuring that all queries are executed in a READ ONLY transaction, thus maintaining the integrity of the database. The server is compatible with various platforms, including Docker and NPX, making it versatile and easy to integrate into existing workflows.
Features
- Read-only SQL query execution
- Automatic schema discovery
- Secure READ ONLY transactions
- Platform compatibility with Docker and NPX
- JSON schema information for tables
Tools
query
Execute read-only SQL queries against the connected database. Input:
sql(string): The SQL query to execute. All queries are executed within a READ ONLY transaction.
