Postgres
Createdpyljain
Provides read-only access to PostgreSQL databases for LLMs, enabling schema inspection and query execution.
About
This Model Context Protocol (MCP) server grants Large Language Models (LLMs) the ability to interact with PostgreSQL databases in a safe, read-only manner. It allows LLMs to inspect database schemas, understand data structures, and execute SQL queries without the risk of data modification. The server exposes table schemas as JSON resources and offers a 'query' tool to execute read-only SQL commands within a transaction that prevents data alteration.
Key Features
- Exposes database schema information as JSON resources
- Enables read-only SQL query execution
- 0 GitHub stars
- Supports Docker and NPX deployment
- Automatically discovers table schemas from database metadata
- Utilizes READ ONLY transactions for query execution
Use Cases
- Allowing LLMs to answer questions based on data in a PostgreSQL database
- Enabling LLMs to understand the structure of a PostgreSQL database
- Building LLM-powered applications that require access to data stored in PostgreSQL
