PostgreSQL
0
Enables large language models to inspect PostgreSQL database schemas and execute read-only queries.
About
This Model Context Protocol server facilitates seamless interaction between Large Language Models (LLMs) and PostgreSQL databases. It grants LLMs the ability to explore database structures by providing comprehensive schema information for each table, including column names and data types, automatically discovered from database metadata. Additionally, it offers a secure `query` tool that allows LLMs to execute read-only SQL queries, ensuring data integrity by running all operations within a read-only transaction. This tool streamlines the process for LLMs to understand and extract information from relational databases.
Key Features
- Enables LLMs to inspect database schemas
- Executes read-only SQL queries securely within a transaction
- 0 GitHub stars
- Provides read-only access to PostgreSQL databases for LLMs
- Automatically discovers table schema information including column names and data types
- Offers integration with Claude Desktop and VS Code environments
Use Cases
- Empowering AI agents to retrieve specific data using read-only SQL queries
- Allowing LLMs to autonomously explore and understand database structures
- Integrating database access directly into AI development workflows in environments like VS Code
Sponsored