Enhanced Postgres
CreatedGarethCott
Enables LLMs to read, write, and manage schemas in PostgreSQL databases.
About
This enhanced PostgreSQL server, based on the Model Context Protocol, empowers Large Language Models with comprehensive database interaction capabilities. It provides not only read access for inspecting schemas and querying data, but also write access for modifying data and managing database schemas, including creating tables, functions, triggers, and indexes. This server uses transactions with commit/rollback handling for all data modification operations and parameterized queries to prevent SQL injection.
Key Features
- Executes read-only SQL queries in read-only transactions.
- Supports schema management operations: create/alter tables, functions, triggers, and indexes.
- Executes SQL statements for data modification with commit/rollback.
- Provides JSON schema information for tables.
- Uses parameterized queries to prevent SQL injection.
Use Cases
- Allowing LLMs to dynamically create and manage database schemas based on user input.
- Integrating LLMs with existing PostgreSQL databases for real-time data analysis and reporting.
- Enabling LLMs to perform data cleaning and transformation tasks directly in the database.