PostgreSQL
0
Enables Large Language Models to securely interact with PostgreSQL databases through the Model Context Protocol.
About
This Model Context Protocol (MCP) server provides a standardized interface for LLMs to safely access and manage PostgreSQL database interactions. Built with Bun and TypeScript, it offers read-only access to database schemas and table data, alongside powerful tools for executing SQL queries, listing tables, and describing table structures. It also includes prompt templates to assist LLMs with SQL query generation and optimization, all while enforcing robust security measures like parameterized queries and row limits to prevent SQL injection and data overload.
Key Features
- Secure read-only access to PostgreSQL database schemas
- Natural language to SQL query generation assistance for LLMs
- Execute read-only SQL queries (SELECT, EXPLAIN, WITH)
- Dynamic table data retrieval with automatic validation and row limits
- SQL query optimization suggestions for improved performance
- 0 GitHub stars
Use Cases
- Allowing LLMs to understand and query database structures for context-aware responses
- Assisting LLMs in generating and optimizing SQL queries from natural language prompts
- Enabling LLMs to securely retrieve specific table data without direct database access
Sponsored