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
Highlight AIList database resources. This action is invoked by sending a POST request to the MCP endpoint with the type set to 'function' and the name set to 'resources'.
Execute a read-only SQL query on the database. This action requires the query parameter to be specified in the arguments. It is invoked by sending a POST request to the MCP endpoint with the type set to 'function', the name set to 'query', and the query string in the arguments.
