mcp-server-postgres
If you are the rightful owner of mcp-server-postgres 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, enabling 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 database structures and retrieve data securely. The server operates within a READ ONLY transaction, ensuring that all interactions are non-destructive. It also provides schema information for each table, including column names and data types, which are automatically discovered from the database metadata.
Features
- Read-only SQL query execution
- Automatic schema discovery
- Secure data access
- Integration with LLMs
- 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.
