Postgres

•
178
•

Connects Large Language Models to PostgreSQL databases, enabling controlled querying and analysis.

Postgres is a Model Context Protocol (MCP) server designed to bridge Large Language Models (LLMs) with PostgreSQL databases. It provides a secure and controlled interface for LLMs to query and analyze database content, preventing direct access and ensuring data integrity. By exposing specific tools and resources, it allows LLMs to understand database schemas, execute SQL queries, and retrieve sample data, facilitating intelligent data interaction without compromising security.

主要功能

01Execute SQL queries via a controlled LLM interface
0225 GitHub stars
03Configurable write operations for enhanced security control
04Expose database schema and sample data as LLM resources
05Integration with PostgreSQL via connection string and optional SSL/TLS
06Supports both standard I/O (stdio) and HTTP streamable transports

使用案例

01Providing a controlled environment for LLMs to generate and test SQL queries
02Building natural language interfaces for database interaction
03Enabling AI agents or LLMs to perform data analysis on PostgreSQL data