This MCP server, developed by ipfans, provides a standardized interface for interacting with PostgreSQL databases. Built with Go and leveraging the Gin web framework, it offers tools for executing read-only SQL queries and exploring database resources. The implementation focuses on simplicity and ease of use, allowing configuration through command-line flags or environment variables. By connecting AI models with PostgreSQL data, this server enables sophisticated querying scenarios, enhancing the ability to analyze and extract information from relational databases. It's particularly useful for applications and AI assistants that require secure, read-only access to PostgreSQL data through a familiar MCP interface.
No reviews yet. Be the first to review!
Sign in to join the conversation
List database resources by sending a POST request to the MCP endpoint with type set to 'function' and name set to 'resources'.
Execute a read-only SQL query by sending a POST request to the MCP endpoint with type set to 'function', name set to 'query', and providing the SQL query in the arguments.
