How do I use Redshift MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Redshift MCP Server show all tables in the sales schema" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

Redshift MCP server

This repository contains the code for the Redshift MCP server. This MCP server allows you to connect to Redshift cluster and execute SQL queries.

Has been tested up to 100+ rows of output. For larger output, your mileage may vary depending upon the total size of the output.

Setup

Note down the path where this directory is located. You will need it to configure the MCP client. For now, it is assumed to be <path_to_redshift_mcp>.

In your MCP configuration file, add the following configuration. If your MCP client supports envFile, you can also add that with these variables and the server would read them from there.

{
    "command": "uv",
    "args": [
        "--directory",
        "<path_to_redshift_mcp>",
        "run",
        "server.py"
    ],
    "env": {
        "REDSHIFT_DB": "<db-name>",
        "REDSHIFT_USER": "<redshift_user>",
        "REDSHIFT_PASSWORD": "<redshift_password>",
        "REDSHIFT_HOST": "<redshift-host-uri>",
        "REDSHIFT_PORT": "5439"
    }
}

In case you don't have uv installed, you can install it by following uv installation guide.

Usage

Prefer using a read-only user for connecting to the Redshift cluster. Validations are performed to ensure that the user is not able to execute DDL statements but it is still a good practice to use a read-only user.