mcp_server_template
If you are the rightful owner of mcp_server_template 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 data retrieval without the risk of modifying the database. By leveraging the server, users can gain insights into the structure and contents of their databases, making it an essential tool for data analysis and reporting. The server operates within a READ ONLY transaction, ensuring that all interactions are safe and non-destructive. Additionally, it 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
- JSON schema information for tables
- Safe, non-destructive database interactions
- Integration with various platforms
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.
