Postgres
0
Provides a Model Context Protocol server for securely querying PostgreSQL databases with robust tools for data retrieval and schema inspection.
概要
The Postgres server is a Model Context Protocol (MCP) implementation designed to provide a secure and efficient interface for interacting with PostgreSQL databases. It offers a suite of tools for executing safe SELECT queries, inspecting database schemas, and listing tables. Unlike some alternative MCP PostgreSQL servers, this Python-based solution emphasizes security with built-in SQL injection protection and includes connection pooling for improved performance and resource management, making it a reliable choice for integrating PostgreSQL data into MCP-compatible clients like Cursor IDE.
主な機能
- Execute SELECT queries with SQL injection protection
- Built-in connection pooling via asyncpg
- Retrieve detailed table schema information and constraints
- Secure environment-based configuration for database credentials
- 0 GitHub stars
- List all accessible database tables
ユースケース
- Securely querying and retrieving data from PostgreSQL instances
- Integrating PostgreSQL databases with Model Context Protocol clients
- Programmatically inspecting PostgreSQL database schemas and table structures