{"repo":"ahmedmustahid/postgres-mcp-server","free":true,"listed":false,"github":"https://github.com/ahmedmustahid/postgres-mcp-server","clone":"git clone https://github.com/ahmedmustahid/postgres-mcp-server.git","description":"MCP (Model Context Protocol) Server for postgres Database","language":"TypeScript","stars":31,"topics":[],"license":null,"category":"mcp-servers","readme_excerpt":"MCP PostgreSQL Server (Stateful and Dual Transport) A Model Context Protocol (MCP) server that provides both HTTP and Stdio transports for interacting with PostgreSQL databases. This server exposes database resources and tools through both transport methods, allowing for flexible integration in different environments. Features - Dual Transport Support : Both HTTP (StreamableHTTPServerTransport) and Stdio (StdioServerTransport) - Database Resources : List tables and retrieve schema information - Query Tool : Execute read-only SQL queries - Stateful Sessions : HTTP transport supports session management - Docker Support : Containerized deployments for both transports - Production Ready : Graceful shutdown, error handling, and logging Quick Start Environment Setup The database credentials must be passed as: 1. Either environment variables 2. Or in the working directory (directory where npx command will be run): create a .env file (the package uses dotenv package) Run using npx 1. Download node.js and npm from here 2. Run the package. By default, it will run streamable http on port 3000: 3. For stdio transport: Environment Setup Copy environment template Edit your database credentials Podman(or Docker) Usage 1. Install podman from here 2. Install uv from here 3. Install podman compose package: uv add podman-compose (or uv sync to sync packages in pyproject.toml ) Test using Claude Desktop First, install node.js and npm, build the project following the above instructions. Edit your","default_branch":null,"files":null,"tree":[],"storefront":"/r/ahmedmustahid","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ahmedmustahid/postgres-mcp-server/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}