Amazon Redshift MCP Server

AWS Labs · Data & Analytics Infrastructure

Community

AWS Labs open-source MCP server for Amazon Redshift. Run SQL analytics, inspect schemas, and generate reports from any MCP client.

data warehousesqlawsreporting

Status

Community

Auth

API key

Hosting

Local

Community rating

Not rated yet

Open documentation →

Rate this server

How to connect Amazon Redshift MCP Server

Step 1

Local server — run it on your machine

Amazon Redshift MCP Server runs locally over stdio. You need Node.js (for npx) or Python (for uvx) installed, then add the command below to your client's MCP config file.

Command

uvx awslabs.redshift-mcp-server

Client config snippet

{
  "mcpServers": {
    "redshift-mcp": {
      "command": "uvx",
      "args": [
        "awslabs.redshift-mcp-server"
      ]
    }
  }
}

Step 2

Authenticate with API key

Create a key in the vendor's dashboard and store it as an environment variable in your client config — never paste it into a chat window.

Step 3

Verify, then widen access

Restart your client, confirm the server's tools appear, and run one read-only question first. Keep client-side approval prompts on for any tool that can write, trade or send. Confirm with your firm's compliance policy before connecting systems holding client data.

Read the full connection guide →