R

Redshift Utils

Provides Amazon Redshift database administration tools for cluster health monitoring, query performa...

402 views
1 installs
Updated Nov 21, 2025
Not audited
Provides Amazon Redshift database administration tools for cluster health monitoring, query performance analysis, workload management, and diagnostic operations through AWS Data API integration with over 40 curated SQL scripts for production database maintenance.
  1. Log in to your AWS Management Console
    Visit https://console.aws.amazon.com and log in with an account that has sufficient permissions.

  2. Obtain your Redshift Cluster Identifier

  3. Obtain your Redshift Database Name

    • In the Redshift console, click on your cluster.
    • In the cluster details, note the Database name field.
  4. Create or Use an Existing Secret in AWS Secrets Manager

    • Go to AWS Secrets Manager: https://console.aws.amazon.com/secretsmanager/
    • Click "Store a new secret".
      • Select "Other type of secret", then input your database username and password.
      • Optionally, add key/value pairs for host and port if needed.
    • Click "Next" and give your secret a name. Remember this name.
    • Complete the wizard. At the end, you'll see an ARN (e.g., arn:aws:secretsmanager:us-east-1:123456789012:secret:your-redshift-secret-XXXXXX).
    • Copy the Secret ARN.
  5. Obtain your AWS Region

    • This is shown in the AWS console (top right, e.g., “us-east-1”).
    • If unsure, check the region where your cluster and secret reside.
  6. (Optional) Determine your AWS Profile Name

    • If using an AWS profile (not default credentials), locate it in your ~/.aws/credentials file (e.g., [my-redshift-profile]).
  7. Fill in the FastMCP connection interface

    • Click the "Install Now" button for the Redshift Utils MCP Server.
    • When prompted to enter environment variables, fill in these values:
      • REDSHIFT_CLUSTER_ID — the cluster identifier from Step 2.
      • REDSHIFT_DATABASE — the database name from Step 3.
      • REDSHIFT_SECRET_ARN — the Secrets Manager ARN from Step 4.
      • AWS_REGION — the region from Step 5 (e.g., us-east-1).
      • (Optional) AWS_PROFILE — your AWS profile name from Step 6.

Note: The IAM user/role whose credentials are active must have permissions for the Redshift Data API (redshift-data:*) and secretsmanager:GetSecretValue for the specified secret.

How to Install Redshift Utils

Install Redshift Utils MCP server with one click through FastMCP. Choose your preferred AI development tool below:

Claude Desktop

Click "Claude Desktop" in Quick Start

Cursor IDE

Click "Cursor IDE" in Quick Start

VS Code

Click "VS Code" in Quick Start

Alternatives to Redshift Utils

Looking for similar MCP servers? Browse other servers in the same categories on FastMCP, or check out the similar servers listed above.

Quick Start

View on GitHub

More for Database

View All →

More for Analytics and Data

View All →

Report Issue

Thank you! Your issue report has been submitted successfully.

Stay ahead of the MCP ecosystem

Get the top new MCP servers, trending tools, and dev tips delivered weekly. Free, no spam, unsubscribe anytime.

Join 2,847 developers. We send one email per week.