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.

其他分类下的更多 MCP 服务器

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code