R

Redshift Utils

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

63 views
0 installs
Updated Sep 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.

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.