Skip to content
Kitbay
MCP serverOfficial

awslabs.redshift-mcp-server

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

An MCP server from AWS Labs for Amazon Redshift provisioned clusters and Serverless workgroups.

What it does

An MCP server from AWS Labs for Amazon Redshift provisioned clusters and Serverless workgroups. It discovers clusters and workgroups, browses databases, schemas, tables and columns, runs SQL, including concurrent queries across several clusters, and reviews a cluster's health and configuration with a recommendation for each finding. It is read-only by default and rejects writes; setting ACCESS_MODE=read-write allows changes, asks for confirmation before each statement that could alter data, and supports named transactions that can be committed or rolled back. The README stresses that the database user's privileges are the real limit. It runs locally and uses the AWS profile or environment credentials.

Capabilities

  • Discover Redshift clusters and Serverless workgroups
  • Browse databases, schemas, tables and columns
  • Run SQL queries, read-only by default
  • Group statements in named transactions
  • Review cluster health and configuration