Redshift MCP Server

@Moonlight-CL

リポジトリ

基本情報

カテゴリ

その他

ライセンス

Apache-2.0

トランスポート

stdio

作者

Moonlight-CL

Redshift MCP Server について

概要はまだありません

Redshift MCP Server の設定

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

{
  "mcpServers": {
    "redshift-mcp-server-moonlight-cl": {
      "command": "uv",
      "args": [
        "sync"
      ]
    }
  }
}

Redshift MCP Server のツール

Executes a SQL query on the Redshift cluster

Analyzes a table to collect statistics information

Gets the execution plan with runtime statistics for a SQL query

概要

What is Redshift MCP Server?

A Python-based Model Context Protocol (MCP) server that enables AI assistants to interact with Amazon Redshift databases. It provides tools and resources for listing schemas and tables, retrieving table DDL, getting table statistics, executing SQL queries, analyzing tables, and obtaining execution plans.

How to use Redshift MCP Server?

Install Python 3.13 or higher and have a running Redshift cluster with credentials. Clone the repository, install dependencies with uv sync, and set environment variables (RS_HOST, RS_PORT, RS_USER, RS_PASSWORD, RS_DATABASE, and optionally RS_SCHEMA). Start the server with uv run --with mcp python-dotenv redshift-connector mcp and mcp run src/redshift_mcp_server/server.py. Integrate with an MCP-compatible AI assistant by adding the provided JSON configuration to your MCP settings file.

Key features of Redshift MCP Server

Lists all schemas and tables in the database
Retrieves DDL scripts for any table
Provides table statistics (row count, size, etc.)
Executes arbitrary SQL queries on the cluster
Analyzes tables to collect fresh statistics
Returns execution plans with runtime statistics

Use cases of Redshift MCP Server

Exploring database schemas and table structures via an AI assistant
Inspecting table definitions and DDL for migration or documentation
Running ad‑hoc SQL queries without connecting directly to Redshift
Collecting table statistics to optimize query performance
Debugging slow queries by reviewing execution plans

よくある質問

What are the runtime requirements?

Python 3.13 or higher is required. The server also needs network access to an Amazon Redshift cluster and valid database credentials.

How do I connect to my Redshift cluster?

Set the environment variables `RS_HOST`, `RS_PORT`, `RS_USER`, `RS_PASSWORD`, `RS_DATABASE`, and optionally `RS_SCHEMA`. These can be set directly or in a `.env` file.

What dependencies does the server use?

It depends on the MCP CLI package (`mcp[cli]>=1.5.0`), `python-dotenv>=1.1.0` for environment variable loading, and `redshift-connector>=2.1.5` for Redshift connectivity.

What data does the server access?

All data lives in the connected Amazon Redshift database. The server does not store any data locally; it only queries and returns results from the cluster.

What authentication method does it use?

Authentication is handled via username and password passed as environment variables (`RS_USER` and `RS_PASSWORD`). No other authentication mechanisms are documented.

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

ICSS

chokcoco

不止于 CSS

20.7K

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3