広告掲載
MCP.so
ログイン

Redshift Administrative MCP Server & Web UI

@vinodismyname

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

vinodismyname

Redshift Administrative MCP Server & Web UI について

A Python-based MCP server for administrative actions on Amazon Redshift

Redshift Administrative MCP Server & Web UI の設定

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

{
  "mcpServers": {
    "redshift-admin-mcp-server": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "-e",
        "."
      ]
    }
  }
}

Redshift Administrative MCP Server & Web UI のツール

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

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

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

概要

What is Redshift Administrative MCP Server & Web UI?

This project provides a Model Context Protocol (MCP) server and a Flask web UI for Amazon Redshift administration. The MCP server lets AI agents, coding assistants, and automated tools execute administrative SQL scripts and custom queries on Redshift, using credentials fetched from AWS Secrets Manager. The web UI offers a browser-based interface for connecting and running scripts. Both components are aimed at database administrators and developers who manage Redshift clusters.

How to use Redshift Administrative MCP Server & Web UI?

Install the package with uv pip install -e .. For the MCP server, run uvx redshift-admin-mcp-server with required arguments like --host, --database, --secret-arn, and --aws-region. For the Flask Web UI, set environment variables (FLASK_APP, SECRET_KEY) and run flask run. Connect the MCP server to clients such as Claude Desktop, Cline, Cursor, or a custom Python client via stdio transport.

Key features of Redshift Administrative MCP Server & Web UI

  • Connects to Redshift using AWS Secrets Manager credentials.
  • Exposes MCP tools for admin scripts and custom SQL queries.
  • Outputs results in JSON, CSV, or formatted table.
  • Provides schema discovery for MCP clients.
  • Includes a Flask web UI for browsing and executing scripts.

Use cases of Redshift Administrative MCP Server & Web UI

  • AI agents monitoring and troubleshooting Redshift lock waits or performance.
  • Developers running admin scripts (e.g., lock_wait) from an IDE or terminal.
  • Database administrators scheduling automated health checks via MCP clients.
  • Teams using a web dashboard to explore and execute maintenance queries.

よくある質問

1

How does the MCP server authenticate to Redshift?

It uses AWS Secrets Manager. You must provide a Secret ARN that contains `username` and `password`, along with the Redshift host, database, and AWS region. Credentials can be supplied via command-line arguments or environment variables.

2

What are the runtime requirements?

Python 3.10 or higher and the `uv` package manager. An AWS account with permissions to connect to Redshift and access Secrets Manager is also required.

3

Where is the data stored?

All data resides in the Amazon Redshift cluster you connect to. The MCP server and web UI do not store any data locally; they only run queries and display results.

4

Can I connect interactively without startup parameters?

Yes. If required parameters (`host`, `database`, `secret_arn`) are omitted, the MCP server starts without a connection. You can then use the `connect_redshift` tool interactively via an MCP client.

5

What transport does the MCP server use?

It communicates over stdio transport, which is compatible with all major MCP clients (Claude Desktop, Cline, Cursor, etc.).

コメント

「その他」の他のコンテンツ

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

広告掲載