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

FAQ from AWS PostgreSQL MCP Server

What type of queries does the server support?

Only read-only queries such as SELECT and SHOW. Write operations are not allowed.

How do I configure the database connection?

Set the environment variables DB_HOST, DB_PORT, DB_NAME, DB_USER, and DB_PASSWORD in the MCP client’s settings file.

What transport protocol does the server use?

The server uses stdio transport.

Where are the database credentials stored?

They are stored in the env object of the MCP client’s configuration file.

Does the server support write operations?

No, it is strictly read-only to prevent data modification.