Claude Desktop
Desktop · Freemium · Proprietary
Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.
WindowsMacOS
Redshift Utils MCP
vinodismyname/redshift-utils-mcp
This project implements a Model Context Protocol (MCP) server designed specifically to interact with Amazon Redshift databases.
Install
pip install redshift-utils-mcpEnvironment variables
REDSHIFT_CLUSTER_IDREDSHIFT_DATABASEREDSHIFT_SECRET_ARNAWS_REGION- Author
- @vinodismyname
- Category
- Database, Developer Tools
- License
- MIT
- Updated
- Oct 6, 2026
About Redshift Utils MCP
It bridges the gap between Large Language Models (LLMs) or AI assistants (like those in Claude, Cursor, or custom applications) and your Redshift data warehouse, enabling secure, standardized data access and interaction. This allows users to query data, understand database structure, and monitoring/diagnostic operations using natural language or AI-driven prompts.
Features
Secure Redshift Connection (via Data API): Connects to your Amazon Redshift cluster using the AWS Redshift Data API via Boto3, leveraging AWS Secrets Manager for credentials managed securely via…
Schema Discovery: Exposes MCP resources for listing schemas and tables within a specified schema.
Metadata & Statistics: Provides a tool (handle_inspect_table) to gather detailed table metadata, statistics (like size, row counts, skew, stats staleness), and maintenance status.
Read-Only Query Execution: Offers a secure MCP tool (handle_execute_ad_hoc_query) to execute arbitrary SELECT queries against the Redshift database, enabling data retrieval based on LLM requests.
Query Performance Analysis: Includes a tool (handle_diagnose_query_performance) to retrieve and analyze the execution plan, metrics, and historical data for a specific query ID.
Table Inspection: Provides a tool (handle_inspect_table) to perform a comprehensive inspection of a table, including design, storage, health, and usage.
Cluster Health Check: Offers a tool (handle_check_cluster_health) to perform a basic or full health assessment of the cluster using various diagnostic queries.
Lock Diagnosis: Provides a tool (handle_diagnose_locks) to identify and report on current lock contention and blocking sessions.
Workload Monitoring: Includes a tool (handle_monitor_workload) to analyze cluster workload patterns over a time window, covering WLM, top queries, and resource usage.
DDL Retrieval: Offers a tool (handle_get_table_definition) to retrieve the SHOW TABLE output (DDL) for a specified table.
Tools (7)
handle_check_cluster_health
Performs a health assessment of the Redshift cluster using a set of diagnostic SQL scripts.
handle_diagnose_locks
Identifies active lock contention and blocking sessions in the cluster.
handle_diagnose_query_performance
Analyzes a specific query's execution performance, including plan, metrics, and historical data.
handle_execute_ad_hoc_query
Executes an arbitrary SQL query provided by the user via Redshift Data API.
handle_get_table_definition
Retrieves the DDL (Data Definition Language) statement (SHOW TABLE) for a specific table.
handle_inspect_table
Retrieves detailed information about a specific Redshift table, covering design, storage, health, and usage.
handle_monitor_workload
Analyzes cluster workload patterns over a specified time window using various diagnostic scripts.
Details on this page are taken from the project's README. Open README
Supported clients
Clients mentioned in this server's README:
Related MCP servers
Supabase MCP
supabase-community/supabase-mcp
The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.
Genai Toolbox
googleapis/genai-toolbox
MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.
Supabase MCP Server
alexander-zuev/supabase-mcp-server
Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.
Awesome MCP List
MobinX/awesome-mcp-list
This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.
PostgreSQL Model Context Protocol (PG MCP) Server
stuzero/pg-mcp-server
PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.
dbhub
bytebase/dbhub
[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.