Enables LLMs to inspect PostgreSQL database schemas and execute read-only queries.
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
01Automatically discovers schema from database metadata
02Executes read-only SQL queries
03Integrates with Claude Desktop app
04Provides JSON schema information for tables
05Operates within a READ ONLY transaction
Use Cases
01Allowing LLMs to understand and interact with PostgreSQL databases
02Enabling read-only data analysis using LLMs
03Providing schema context to LLMs for improved query generation
