vinodismyname/redshift-utils-mcp

3.6

Certified

Redshift Utils MCP Server is a Model Context Protocol server designed to integrate LLM capabilities with Amazon Redshift databases.

Tools

Functions exposed to the LLM to take actions

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 statement for a specific table.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

vinodismyname

Claim Ownership

Verify you have write access to the repository

Verified owners:

Vinod D

Version

v0.3.2

Repository

https://github.com/vinodismyname/redshift-utils-mcp

GitHub Stars

License

MIT License

Last publish date

2025-06-29

Last update date

2025-08-06

Server configs

in claude desktop

{
  "mcpServers": {
    "redshift-utils-mcp": {
      "command": "uvx",
      "args": ["redshift-utils-mcp"],
      "env": {
        "REDSHIFT_CLUSTER_ID": "your-cluster-id",
        "REDSHIFT_DATABASE": "your_database_name",
        "REDSHIFT_SECRET_ARN": "arn:aws:secretsmanager:...",
        "AWS_REGION": "us-east-1"
      }
    }
  }
}

in claude code

bash
claude mcp add redshift-utils-mcp \
  -e REDSHIFT_CLUSTER_ID="your-cluster-id" \
  -e REDSHIFT_DATABASE="your_database_name" \
  -e REDSHIFT_SECRET_ARN="arn:aws:secretsmanager:..." \
  -e AWS_REGION="us-east-1" \
  -- uvx redshift-utils-mcp

in cursor

{
  "mcpServers": {
    "redshift-utils-mcp": {
      "command": "uvx",
      "args": ["run", "redshift_utils_mcp"],
      "env": {
        "REDSHIFT_CLUSTER_ID": "your-cluster-id",
        "REDSHIFT_DATABASE": "your_database_name",
        "REDSHIFT_SECRET_ARN": "arn:aws:secretsmanager:...",
        "AWS_REGION": "us-east-1"
      }
    }
  }
}

Top Comments

Related MCP Servers

View all databases servers →

mindsdb

4.6

by mindsdb

MindsDB is an open-source server that enables seamless interaction with large-scale federated data using the Model Context Protocol (MCP).

databases

mysql_mcp_server

4.5

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

databases

mcp-notion-server

4.4

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

databases

mcp-server-neon

4.4

by neondatabase-labs

Neon MCP Server is an open-source tool that enables natural language interaction with Neon Postgres databases.

databases

mcp-alchemy

4.3

by runekaagaard

MCP Alchemy is a model context protocol server that connects Claude Desktop to various databases, enabling advanced database exploration and query execution.

databases

notion-mcp-server

4.3

by makenotion

This project implements an MCP server for the Notion API, allowing integration with LLMs.

databases

mcp-server-duckdb

4.2

by ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools.

databases

mcp-memory-libsql

4.0

by spences10

A high-performance, persistent memory system for the Model Context Protocol (MCP) powered by libSQL, providing vector search capabilities and efficient knowledge storage.

knowledge_and_memory

supabase-mcp

3.9

by coleam00

A Model Context Protocol (MCP) server that provides tools for interacting with a Supabase database. This server enables AI assistants to perform database operations through a standardized interface.

databases

mcp-server

3.9

by keboola

Keboola MCP Server connects AI agents and MCP clients to Keboola, enabling data access and transformations without glue code.

cloud_platforms

doris-mcp-server

3.9

by apache

Doris MCP Server is a backend service built with Python and FastAPI, designed to connect to Apache Doris databases and potentially leverage LLMs for tasks like NL2SQL.

databases

postgresql-mcp-server

3.9

by HenkDz

A Model Context Protocol (MCP) server that provides comprehensive PostgreSQL database management capabilities for AI assistants.

databases

airtable-mcp

3.8

by felores

A Model Context Protocol server for interacting with Airtable's API, enabling programmatic management of Airtable bases, tables, fields, and records.

databases

postgres-mcp

3.8

by crystaldba

Postgres MCP Pro is an open-source Model Context Protocol server designed to enhance database performance and management through advanced tools and features.

databases

azure-mcp

3.8

by Azure

The Azure MCP Server implements the MCP specification to create a seamless connection between AI agents and Azure services.

cloud_platforms

mcp-server-mysql

3.7

by benborla

A Model Context Protocol server for MySQL databases using NodeJS, enabling LLMs to inspect schemas and execute SQL queries.

databases

anyquery

3.7

by julien040

Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications, with support for LLMs and MySQL server functionality.

databases

mcp-proxy

3.7

by TBXark

An MCP proxy server that aggregates and serves multiple MCP resource servers through a single HTTP server.

databases

mcp-server-motherduck

3.7

by motherduckdb

An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs.

databases

openehr-mcp-server

3.7

by deak-ai

An MCP server designed to interface with openEHR REST APIs, specifically the EHRbase implementation.

databases

mcp-google-sheets

3.7

by xing5

mcp-google-sheets is a Python-based MCP server that connects MCP-compatible clients to Google Sheets API for automation and data manipulation.

cloud_platforms

mcp-redis

3.6

by redis

The Redis MCP Server is a natural language interface designed for agentic applications to efficiently manage and search data in Redis.

databases

prometheus-mcp-server

3.6

by pab1it0

A Model Context Protocol (MCP) server for Prometheus, enabling access to Prometheus metrics and queries through standardized MCP interfaces.

databases

mcp-server-splunk

3.6

by jkosik

A Go implementation of the MCP server for Splunk, supporting STDIO and SSE (Server-Sent Events HTTP API) using the github.com/mark3labs/mcp-go SDK.

cloud_platforms

mcp-teradata

3.6

by arturborycki

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through Teradata.

databases

mcp-mongo-server

3.6

by kiliczsh

A Model Context Protocol server that enables LLMs to interact with MongoDB databases, providing capabilities for inspecting collection schemas and executing MongoDB operations through a standardized interface.

databases

mcp-server-weaviate

3.6

by weaviate

Weaviate MCP Server is a protocol server designed to interact with the Weaviate vector database, providing functionalities for inserting and querying data.

databases