PostgreSQL
Provides a Model Context Protocol server for read-only access to PostgreSQL databases, enabling LLMs to inspect schemas and execute queries.
About
This Model Context Protocol server for PostgreSQL databases facilitates seamless interaction between Large Language Models (LLMs) and your database. It empowers LLMs with the capability to inspect database schemas, offering detailed JSON schema information for each table, including column names and data types, all automatically discovered from database metadata. Additionally, it allows LLMs to execute read-only SQL queries, ensuring data integrity by operating strictly within read-only transactions. This integration enhances LLMs' ability to understand database structures and efficiently retrieve information.
Key Features
- Include column names and data types in table schema output
- Designed as a Model Context Protocol (MCP) server for LLM integration
- Ensure all queries are executed within a read-only transaction for data safety
- 0 GitHub stars
- Automatically discover and provide JSON schema information for database tables
- Execute read-only SQL queries against connected databases
Use Cases
- Enabling Large Language Models (LLMs) to perform read-only queries on PostgreSQL databases for data retrieval
- Allowing LLMs to understand and inspect PostgreSQL database schemas and structures
- Integrating PostgreSQL database access into LLM-powered applications or environments like Claude Desktop and VS Code
Advertisement