Skip to content
Kitbay
MCP server

awslabs.postgres-mcp-server

Runs locallyApache-2.0Updated on Nov 10, 20269,904GitHub starsCan change dataNeeds an API key

A local MCP server from AWS Labs for PostgreSQL databases hosted on Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL.

What it does

A local MCP server from AWS Labs for PostgreSQL databases hosted on Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL. The agent turns plain-language questions into SQL and runs them against a database it connects to during the conversation, either directly over the Postgres wire protocol, with IAM authentication, or through the RDS Data API for Aurora. It can also create a new Aurora PostgreSQL cluster. Write queries are refused unless the server is started with an allow-write flag, and AWS notes that this read-only check is not guaranteed. It needs an AWS profile, and database passwords are read from AWS Secrets Manager.

Capabilities

  • Run SQL generated from a plain-language question on Aurora or RDS PostgreSQL
  • Connect through the RDS Data API, the Postgres protocol or IAM authentication
  • Create an Aurora PostgreSQL cluster
  • Route connections through an RDS Proxy when one exists