Postgres

소개

This Model Context Protocol (MCP) server enables LLM-powered agents and various MCP clients to interact with PostgreSQL databases. It provides a set of controlled tools for database inspection, reading data, and safely performing write operations confined to a specified schema. The server supports both standard I/O and streamable HTTP transports, including optional Bearer authentication for secure network access. It integrates seamlessly with popular MCP clients like OpenWebUI and can be deployed as a systemd service or accessed remotely via network configurations like Tailscale, offering a robust and secure way to programmatically manage PostgreSQL databases.

주요 기능

• 0 GitHub stars
• Supports both standard I/O (stdio) and streamable HTTP transports for flexible integration.
• Enforces write safety by confining operations to a dedicated 'mcp' schema and rejecting multi-statement queries.
• Exposes key PostgreSQL database operations (describe, read, write, health check) via MCP.
• Offers optional Bearer authentication for secure HTTP access.
• Provides a command-line interface for direct tool invocation and testing.

사용 사례

• Automate database inspection, data retrieval, and controlled writing operations programmatically.
• Integrate LLM-powered agents and chat clients with PostgreSQL databases for intelligent data interaction.
• Securely expose PostgreSQL functionality to remote clients over HTTP, including authentication and network configuration via services like Tailscale.