Redshift Utils
Provides Amazon Redshift database administration tools for cluster health monitoring, query performa...
Log in to your AWS Management Console
Visit https://console.aws.amazon.com and log in with an account that has sufficient permissions.Obtain your Redshift Cluster Identifier
- Go to the Redshift service section: https://console.aws.amazon.com/redshift/
- Locate your target cluster and copy its identifier (
Cluster identifier).
Obtain your Redshift Database Name
- In the Redshift console, click on your cluster.
- In the cluster details, note the
Database namefield.
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.
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.
(Optional) Determine your AWS Profile Name
- If using an AWS profile (not default credentials), locate it in your
~/.aws/credentialsfile (e.g.,[my-redshift-profile]).
- If using an AWS profile (not default credentials), locate it in your
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
Choose Connection Type for
Authentication Required
Please sign in to use FastMCP hosted connections
Configure Environment Variables for
Please provide values for the following environment variables:
started!
The MCP server should open in . If it doesn't open automatically, please check that you have the application installed.
Copy and run this command in your terminal:
Make sure Gemini CLI is installed:
Visit Gemini CLI documentation for installation instructions.
Make sure Claude Code is installed:
Visit Claude Code documentation for installation instructions.
Installation Steps:
Configuration
Installation Failed
More for Database
View All →Supabase MCP Server
Connect Supabase projects directly with AI assistants using the Model Context Protocol (MCP). This server standardizes communication between Large Language Models and Supabase, enabling AI to manage tables, query data, and interact with project features like edge functions, storage, and branching. Customize access with read-only or project-scoped modes and select specific tool groups to fit your needs. Integrated tools cover account management, documentation search, database operations, debugging, and more, empowering AI to assist with development, monitoring, and deployment tasks in your Supabase environment efficiently and securely.
ClickHouse
Unlock powerful analytics with the ClickHouse MCP Server—seamlessly run, explore, and manage SQL queries across ClickHouse clusters or with chDB’s embedded OLAP engine. This server offers easy database and table listing, safe query execution, and flexible access to data from files, URLs, or databases. Built-in health checks ensure reliability, while support for both ClickHouse and chDB enables robust data workflows for any project.
Postgres MCP Pro
Boost your Postgres database performance with Postgres MCP Pro, an AI-driven MCP server offering advanced index tuning, detailed explain plans, and comprehensive health checks. It combines proven optimization algorithms with schema intelligence for safe, context-aware SQL execution. Whether analyzing slow queries or recommending optimal indexes, Postgres MCP Pro empowers developers to improve efficiency and maintain database integrity. Designed for both development and production, it supports flexible transport options and robust access controls, making database management smarter, safer, and easier. Experience deterministic performance insights alongside AI assistance to keep your Postgres running at its best.
More for Analytics and Data
View All →Excel
Unlock powerful Excel automation with this MCP server that reads and writes Excel files effortlessly. It supports text, formulas, sheet creation, and works with XLSX, XLSM, XLTX, and XLTM formats. Windows users benefit from live editing and screen capture features. The server offers tools to describe sheets, read cell ranges with pagination, write values or formulas, create tables, and copy sheets. Configurable paging limits help manage large data efficiently. Designed for seamless Excel data manipulation, it enhances workflow automation and integration with other systems through the Model Context Protocol.
Meta Ads
Unlock AI-driven insights and control for your Meta ad campaigns across Facebook and Instagram. Meta Ads MCP enables large language models to analyze performance, visualize creatives, and provide strategic recommendations through a unified interface. Manage campaigns, ad sets, and ads with actionable feedback on budget allocation, targeting, and creative improvements. Compatible with any MCP client and supports comprehensive campaign management on all Meta platforms. Leverage automated monitoring, creative optimization, and detailed performance metrics to maximize your advertising impact effortlessly.
Gemini CLI
Integrates with Google's Gemini CLI to leverage massive token windows for analyzing large files and codebases, providing general queries, sandbox-mode code execution for safe testing, and structured response handling with behavioral flags for context control.
MCP Server Chart
Generate 25+ diverse chart types effortlessly with MCP Server Chart powered by AntV. This TypeScript-based server supports area, bar, line, pie, radar, Sankey, word cloud, and many other charts, including geographic visualizations specific to China. It enables clear and interactive display of data trends, distributions, relationships, and hierarchies. Flexible tool filtering and record management features enhance customization and monitoring. Perfect for visualizing complex datasets, MCP Server Chart integrates smoothly with various MCP tools and environments, providing developers with a powerful, easy-to-use chart generation solution to communicate data visually and effectively.