{"repo":"ericzakariasson/pg-mcp-server","free":true,"listed":false,"github":"https://github.com/ericzakariasson/pg-mcp-server","clone":"git clone https://github.com/ericzakariasson/pg-mcp-server.git","description":"MCP Server for Postgres","language":"TypeScript","stars":181,"topics":[],"license":"MIT","category":"mcp-servers","readme_excerpt":"Postgres MCP Server A Model Context Protocol server for PostgreSQL databases. Enables LLMs to query and analyze PostgreSQL databases through a controlled interface. https://github.com/user-attachments/assets/6571c20c-91c9-4a6e-8332-13b587b79fbf Installation Add to your MCP client settings: Configuration - DATABASE URL - PostgreSQL connection string (required) - DANGEROUSLY ALLOW WRITE OPS - Enable writes (default: false ) - DEBUG - Enable debug logging (default: false ) - PG SSL ROOT CERT - Optional path to a TLS CA bundle (e.g., AWS RDS global bundle) Usage Transports - Default transport is stdio . Switch to HTTP with the --transport flag. - HTTP mode serves the MCP Streamable HTTP endpoint at /mcp on PORT (default 3000 ). - Clients that support Streamable HTTP should connect to http://localhost:3000/mcp . Start commands: Tools - query - Execute SQL queries Resources - postgres://tables - List all tables - postgres://table/{schema}/{table} - Get table schema and sample data Example Prompts Here's an example prompt to test if your MCP server is working: Data Analysis & Notebooks For data analysis and exploration, I've added a Cursor rule for using the MCP server together with notebooks in .cursor/rules/notebooks.mdc : Quick Start with Docker Sample tables included: users , products , orders , order items Development Use local build in MCP client settings: Releases This repo auto-creates a GitHub Release when you push a tag that matches the version in package.json : 1. Update ","default_branch":null,"files":null,"tree":[],"storefront":"/r/ericzakariasson","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ericzakariasson/pg-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."}