Postgres
Provides HTTP and Stdio transports for interacting with PostgreSQL databases through the Model Context Protocol.
About
This tool functions as a Model Context Protocol (MCP) server, offering versatile interaction with PostgreSQL databases. It supports both HTTP and Stdio transports, enabling developers to query databases, list tables, and retrieve schema information through a standardized protocol. Designed for flexibility, it includes features like stateful sessions for HTTP, Docker support for easy deployment, and robust error handling for production readiness, making it a reliable solution for integrating PostgreSQL data into various applications and environments.
Key Features
- Dual HTTP and Stdio Transport Support
- Exposes PostgreSQL database resources (tables, schema)
- Executes read-only SQL queries
- Supports stateful HTTP sessions
- Docker and Podman deployment ready
- 2 GitHub stars
Use Cases
- Interfacing PostgreSQL databases with AI assistants and tools via MCP
- Providing a standardized API for read-only PostgreSQL database access
- Debugging and inspecting Model Context Protocol server interactions