広告掲載
MCP.so
ログイン

Redshift Utils MCP Server

@vinodismyname

リポジトリ

基本情報

カテゴリ

開発者ツール

ライセンス

MIT

トランスポート

stdio

作者

vinodismyname

Redshift Utils MCP Server について

🤖 Enable AI assistants (Claude, Cursor) to monitor, diagnose, and query Amazon Redshift using this MCP server and the AWS Data API.

Redshift Utils MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "redshift-utils-mcp": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "redshift-utils-mcp"
      ]
    }
  }
}

Redshift Utils MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is Redshift Utils MCP Server?

Redshift Utils MCP Server is a Model Context Protocol server that bridges AI assistants (such as those in Claude, Cursor, or custom applications) with Amazon Redshift databases. It provides secure, standardized data access and interaction, allowing users to query data, understand database structure, and perform monitoring/diagnostic operations using natural language or AI-driven prompts. It is intended for developers, data analysts, and teams integrating LLM capabilities with Redshift.

How to use Redshift Utils MCP Server?

Install via pip install redshift-utils-mcp or uv pip install redshift-utils-mcp. Set required environment variables (REDSHIFT_CLUSTER_ID, REDSHIFT_DATABASE, REDSHIFT_SECRET_ARN, AWS_REGION) then run redshift-utils-mcp or uvx redshift-utils-mcp. Configure the server in your MCP client (e.g., Claude Desktop, Claude Code CLI, Cursor IDE) by providing the command and environment variables.

Key features of Redshift Utils MCP Server

  • Secure Redshift connection via AWS Redshift Data API and Secrets Manager
  • Schema discovery (list schemas, tables within schemas)
  • Read-only SELECT query execution with input sanitization
  • Table inspection (metadata, statistics, health, usage)
  • Query performance analysis (execution plan, metrics)
  • Cluster health checks (basic/full diagnostic queries)
  • Lock diagnosis and workload monitoring
  • DDL retrieval (SHOW TABLE output)

Use cases of Redshift Utils MCP Server

  • Query your Redshift warehouse using natural language through an AI assistant
  • Explore database schemas and table structures without writing SQL
  • Diagnose performance issues by retrieving query plans and cluster health
  • Monitor locks, workload patterns, and resource usage via prompts
  • Automate table maintenance checks and DDL extraction

よくある質問

1

What are the prerequisites to use Redshift Utils MCP Server?

Python 3.10+, `uv` or `pip`, an AWS account with Redshift Data API and Secrets Manager permissions, a Redshift cluster, and database credentials stored in AWS Secrets Manager. The Redshift user needs CONNECT and SELECT privileges on target tables and system views.

2

How do I configure Redshift Utils MCP Server?

Set environment variables: `REDSHIFT_CLUSTER_ID`, `REDSHIFT_DATABASE`, `REDSHIFT_SECRET_ARN`, and `AWS_REGION`. Optionally set `AWS_PROFILE`. These can be defined in a shell, `.env` file, or directly in your MCP client configuration.

3

How does Redshift Utils MCP Server authenticate?

It uses Boto3 with the AWS credentials provided via environment variables, AWS profile, or IAM role. The server calls the Redshift Data API and accesses the specified Secrets Manager secret to retrieve database credentials. AWS credentials must have `redshift-data:*` and `secretsmanager:GetSecretValue` permissions.

4

What transport does Redshift Utils MCP Server use?

The server uses the `stdio` transport, as shown in the Cursor IDE connection example. MCP clients connect via standard I/O to the server process.

5

Does Redshift Utils MCP Server support write operations?

No. Query execution is read-only (SELECT queries only). The server uses parameterized queries via the Redshift Data API to mitigate SQL injection risks. Other tools (inspect, diagnose, monitor) are also read-only.

コメント

「開発者ツール」の他のコンテンツ

Foremerge

naw103

Catch intent conflicts before code conflicts. The open-source coordination protocol for coding agents, built above Git.

50

Cronwatch

cronwatchdev

CronWatch records every run of your scheduled jobs in your own database, and speaks up when one is missed, fails, gets stuck, runs slow or costs too much. CronWatch is free and open-source.

31

LocalCan

LocalCan

Gives AI agents public URLs (tunnels) for localhost, live HTTP traffic inspection, snapshot publishing, and access control. Part of LocalCan, the ngrok alternative for Mac, Windows and Linux. Free plan.

82

FARPY

mangomunchr

Verified distributed compute for humans, applications, and agents. Submit Blender, Octane, and video workloads, route them across qualified GPUs, track asynchronous execution, download finished artifacts, and verify FARP

1

SSH MCP Server

hypnosis

SSH MCP server for AI agents: remote commands, file transfer, log search and server audits through OpenSSH.

1
広告掲載