postgres-mcp-server
Verified Safeby swethasalunke-tech
Overview
Provides an AWS Model Context Protocol (MCP) server for secure, controlled interaction with PostgreSQL databases via the RDS Data API, supporting SQL query execution and schema retrieval.
Installation
python -m awslabs.postgres_mcp_server.server --resource_arn <RDS_CLUSTER_ARN> --secret_arn <SECRET_MANAGER_ARN> --database <DB_NAME> --region <AWS_REGION> --readonly TrueSecurity Notes
The server includes robust, explicit checks to prevent SQL injection and detect mutating SQL queries, especially when configured for read-only access. It leverages AWS IAM roles and Secrets Manager via boto3 for secure credential management, avoiding hardcoded secrets. Parameterized queries are utilized where appropriate.
Similar Servers
prometheus-mcp-server
A Model Context Protocol (MCP) server that enables AI assistants to query and analyze Prometheus metrics for monitoring and insights.
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
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.
postgres-mcp
A PostgreSQL database management and optimization expert system, offering interactive workflows for query analysis, index tuning, health monitoring, backup strategies, and advanced functionalities like vector search and geospatial data management. It helps users understand and improve their PostgreSQL database performance and health.