Happy slice of mcp pizzaMCP.pizza
Fire in da houseTop Tip:Paying $100+ per month for Perplexity, MidJourney, Runway, ChatGPT and other tools is crazy - get all your AI tools in one site starting at $15 per month with Galaxy AI Fire in da houseCheck it out free

pg-mcp

MCP.Pizza Chef: stuzero

pg-mcp is a lightweight MCP server that exposes PostgreSQL database content as structured, real-time context to LLMs. It enables models to query and interact with PostgreSQL data seamlessly, supporting advanced AI workflows that require database integration. This server facilitates secure, scoped access to database information, making it ideal for developers building AI agents and copilots that need live data from PostgreSQL environments.

Use This MCP server To

Expose PostgreSQL database tables as structured context for LLMs Enable real-time querying of PostgreSQL data by AI models Integrate PostgreSQL data into AI-enhanced workflows and agents Provide scoped, secure access to database content for LLMs Support multi-step reasoning with live database information Facilitate AI-driven data analysis directly from PostgreSQL Automate report generation using PostgreSQL data and LLMs

README

pg-mcp FAQ

How do I deploy pg-mcp server?
You can deploy pg-mcp by cloning its repository from GitHub and following the setup instructions provided in the documentation site at https://stuzero.github.io/pg-mcp/.
What databases does pg-mcp support?
pg-mcp is specifically designed to work with PostgreSQL databases, exposing their data as structured context to LLMs.
Is pg-mcp secure for production use?
Yes, pg-mcp supports scoped and secure access to PostgreSQL data, ensuring safe interaction between LLMs and your database.
Can pg-mcp handle real-time data updates?
Yes, pg-mcp can expose live PostgreSQL data, enabling real-time querying and interaction by AI models.
Does pg-mcp support integration with multiple LLM providers?
Yes, pg-mcp is provider-agnostic and works with models like OpenAI, Claude, and Gemini.
How does pg-mcp improve AI workflows?
By providing structured, real-time database context, pg-mcp enables AI models to perform multi-step reasoning and data-driven decision making.
Where can I find the source code for pg-mcp server and client?
The pg-mcp server source code is at https://github.com/stuzero/pg-mcp-server and the client at https://github.com/stuzero/pg-mcp-client.
Can I customize pg-mcp for my specific PostgreSQL schema?
Yes, pg-mcp is designed to be flexible and can be configured to expose custom schemas and tables as needed.