Postgres
Createdvinsidious
Enables LLMs to inspect PostgreSQL database schemas and execute read-only queries.
About
This Model Context Protocol (MCP) server provides read-only access to PostgreSQL databases, enabling Large Language Models (LLMs) to inspect database schemas and execute read-only queries. It offers tools for executing SQL queries within READ ONLY transactions and resources that automatically discover and provide schema information for each table, including column names and data types.
Key Features
- Automatically discovers schema from database metadata
- Executes read-only SQL queries
- Integrates with Claude Desktop app
- Provides JSON schema information for tables
- Operates within a READ ONLY transaction
Use Cases
- Allowing LLMs to understand and interact with PostgreSQL databases
- Enabling read-only data analysis using LLMs
- Providing schema context to LLMs for improved query generation