AWS PostgreSQL MCP Server

What is AWS PostgreSQL MCP Server?

It is a Model Context Protocol (MCP) server that provides read-only SQL query access to an AWS PostgreSQL database via the query tool. Designed for use with MCP-compatible clients such as Cline or Windsurf.

How to use AWS PostgreSQL MCP Server?

Clone the repository, run pnpm install and pnpm run build, then add the server to your MCP client’s settings file with your database credentials in the env object. Once configured, invoke the query tool with a SQL statement to retrieve data.

Key features of AWS PostgreSQL MCP Server

• Read-only SQL query tool (SELECT, SHOW, etc.)
• Easy configuration via environment variables
• Seamless integration with MCP clients (Cline, Windsurf)
• Uses stdio transport
• Enforces read-only operations to prevent data modification

Use cases of AWS PostgreSQL MCP Server

• Querying database schema and metadata
• Running ad-hoc reports without write access
• Integrating with AI assistants for database exploration
• Providing safe, read-only access to PostgreSQL on AWS