AWS PostgreSQL MCP Server

Example Use Cases

• 1

  Run read-only SQL queries against an AWS-hosted PostgreSQL database from within MCP clients like Cline or Windsurf.

• 2

  Retrieve schema information or table data (SELECT/SHOW) to inform responses, reports, or decision-making without granting write privileges.

• 3

  A simple stdio-based MCP bridge to an RDS Postgres instance configurable via environment variables for easy local or deployment integration.

Description

This Model Context Protocol (MCP) server exposes a read-only 'query' tool that allows MCP clients (e.g., Cline/Windsurf) to run SELECT/SHOW queries against an AWS-hosted PostgreSQL database. Configuration is done via environment variables (DB_HOST, DB_PORT, DB_NAME, DB_USER, DB_PASSWORD) and the server communicates over stdio. It is designed to safely limit access to read-only operations, making it suitable for agents that need to inspect or report on database contents without permitting modifications. The project includes usage examples and instructions for wiring the server into MCP client settings.