Redshift MCP Server
Description
# Redshift MCP Server A Model Context Protocol (MCP) server for Amazon Redshift that enables AI assistants to interact with Redshift databases. ## Introduction Redshift MCP Server is a Python-based implementation of the [Model Context…
About
# Redshift MCP Server A Model Context Protocol (MCP) server for Amazon Redshift that enables AI assistants to interact with Redshift databases. ## Introduction Redshift MCP Server is a Python-based implementation of the [Model Context Protocol](https://github.com/modelcontextprotocol/mcp) that provides tools and…
Details
- Author
- Moonlight-CL
- GitHub stars
- 2
- Downloads
- 187
- Categories
- Database, Other
Jump to
- 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
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Redshift MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
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.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"redshift mcp server": {
"redshift-mcp-server-moonlight-cl": {
"command": "uv",
"args": [
"sync"
]
}
}
}
}McpServers
{
"redshift-mcp-server-moonlight-cl": {
"command": "uv",
"args": [
"sync"
]
}
}Redshift MCP Server
A Model Context Protocol (MCP) server for Amazon Redshift that enables AI assistants to interact with Redshift databases.
Introduction
Redshift MCP Server is a Python-based implementation of the Model Context Protocol that provides tools and resources for interacting with Amazon Redshift databases. It allows AI assistants to:
- List schemas and tables in a Redshift database
- Retrieve table DDL (Data Definition Language) scripts
- Get table statistics
- Execute SQL queries
- Analyze tables to collect statistics information
- Get execution plans for SQL queries
Installation
Prerequisites
- Python 3.13 or higher
- Amazon Redshift cluster
- Redshift credentials (host, port, username, password, database)
Install from source
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
