MCP-SERVER-PG
If you are the rightful owner of MCP-SERVER-PG 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 need for data modification. By leveraging the server, users can ensure that all database interactions are secure and non-intrusive, as all operations are conducted within a READ ONLY transaction. The server automatically discovers and provides schema information for each table, including column names and data types, which can be accessed via a structured JSON format.
Features
- Read-only SQL query execution
- Automatic schema discovery
- JSON schema information for tables
- Secure READ ONLY transactions
- Integration with LLMs for database insights
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.
