How do I install the redshift mcp server?

This profile does not contain a verified copy-paste launch configuration. Follow the current project documentation to confirm the runtime, entry point, transport and authentication before registering it in your client.

What credentials does it need?

It reads `RS_HOST`, `RS_PORT`, `RS_USER`, `RS_PASSWORD`, `RS_DATABASE`, `RS_SCHEMA` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Redshift MCP Server

A Model Context Protocol (MCP) server for Amazon Redshift that enables AI assistants to interact with Redshift databases.

Local serverstdioPython

What is the Redshift MCP Server?

A Model Context Protocol (MCP) server for Amazon Redshift that enables AI assistants to interact with Redshift databases.

What you get

Redshift MCP Server is a Python-based implementation of the Model Context Protocol that provides tools and resources for interacting with Amazon Redshift databases. It allows AI assistants to:

Configuration and credentials

Python 3.13 or higher - Amazon Redshift cluster - Redshift credentials (host, port, username, password, database)

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
execute_sql	Executes a SQL query on the Redshift cluster
analyze_table	Analyzes a table to collect statistics information
get_execution_plan	Gets the execution plan with runtime statistics for a SQL query

How to install the Redshift MCP Server

{
  "mcpServers": {
    "redshift": {
      "command": "uv",
      "args": [
        "--directory",
        "src/redshift_mcp_server",
        "run",
        "server.py"
      ],
      "env": {
        "RS_HOST": "your-redshift-cluster.region.redshift.amazonaws.com",
        "RS_PORT": "5439",
        "RS_USER": "your_username",
        "RS_PASSWORD": "YOUR_RS_PASSWORD",
        "RS_DATABASE": "your_database",
        "RS_SCHEMA": "your_schema"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

Python 3.13 or higher - Amazon Redshift cluster - Redshift credentials (host, port, username, password, database)

Variable	Description	Required
RS_HOST	Declared in the maintainer’s client configuration.	Check documentation
RS_PORT	Declared in the maintainer’s client configuration.	Check documentation
RS_USER	Declared in the maintainer’s client configuration.	Check documentation
RS_PASSWORD	Declared in the maintainer’s client configuration.	Check documentation
RS_DATABASE	Declared in the maintainer’s client configuration.	Check documentation
RS_SCHEMA	Declared in the maintainer’s client configuration.	Optional

Example prompts to try

“Use Redshift to execute sql.”
“Use Redshift to analyze table.”
“Use Redshift to get execution plan.”

Frequently asked questions

A Model Context Protocol (MCP) server for Amazon Redshift that enables AI assistants to interact with Redshift databases. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.