Postgres MCP (Research Project)
A Model Control Protocol (MCP) server implementation for PostgreSQL databases. This project provides a simple HTTP interface to interact with PostgreSQL databases through MCP, allowing you to execute read-only queries and explore database resources.
Features
- MCP-compliant HTTP server
- Read-only SQL query execution
- Database resource listing
- Environment variable support through `.env` files
- Built with Go and Gin web framework
Prerequisites
- Go 1.23.6 or later
- PostgreSQL database
- Git
Installation
Configuration
You can configure the database connection in two ways:
- Using command-line flags:
- Using environment variables: - Create a `.env` file in the project root - Add your database URL: ``` DATABASE_URL=postgres://user:password@localhost:5432/dbname ```
Usage
- Start the server:
The server will start on port 8080 by default.
- Interact with the MCP endpoints:
- List database resources: ``` POST http://localhost:8080/mcp Content-Type: application/json { "type": "function", "name": "resources" } ```
- Execute a read-only query: ``` POST http://localhost:8080/mcp Content-Type: application/json { "type": "function", "name": "query", "arguments": { "query": "SELECT * FROM your_table LIMIT 10" } } ```
License
This project is open source and available under the MIT License.
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.