MCP-PostgreSQL-Ops
Verified Safeby call518
Overview
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
Installation
uvx --python 3.12 mcp-postgresql-ops --type stdioEnvironment Variables
- POSTGRES_HOST
- POSTGRES_PORT
- POSTGRES_USER
- POSTGRES_PASSWORD
- POSTGRES_DB
- REMOTE_AUTH_ENABLE
- REMOTE_SECRET_KEY
Security Notes
The server is explicitly designed for read-only operations, significantly reducing the attack surface. It utilizes environment variables for database credentials, avoiding hardcoded secrets in the code. SQL queries are generally parameterized or carefully constructed to mitigate injection risks, with input validation applied to parameters like 'limit'. Authentication for 'streamable-http' mode is optional but strongly recommended, and the code issues warnings if disabled. A comprehensive SECURITY.md policy is in place.
Similar Servers
mcp-server-neon
The Neon MCP Server allows users to interact with and manage their Neon Postgres databases using natural language commands, acting as a bridge between AI agents/LLMs and the Neon API and database operations.
enhanced-postgres-mcp-server
This server acts as a Model Context Protocol interface for PostgreSQL, enabling LLMs to query data, modify records, and manage database schema objects with read and write capabilities.
dx-mcp-server
Empowers AI applications to interact with and query a user-provided Postgres database via the Model Context Protocol (MCP).
postgresql-mcp
Enabling AI agents to programmatically interact with PostgreSQL databases through a rich set of specialized tools and a sandboxed code execution environment.