Redshift MCP Server
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
- License
- Apache-2.0
Explore
- 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
- Python 3.13 or higher
- Amazon Redshift cluster
- Redshift credentials (host, port, username, password, database)
uv sync
access_mcp_resource("redshift-mcp-server", "rs:///public/users/ddl")
use_mcp_tool("redshift-mcp-server", "get_execution_plan", {"sql": "SELECT * FROM public.users WHERE user_id = 123"})
execute_sql
Executes a SQL query on the Redshift cluster
analyze_table
Analyzes a table to collect statistics information
get_execution_plan
Gets the execution plan with runtime statistics for a SQL query
The server provides the following tools:
- execute_sql - Executes a SQL query on the Redshift cluster
- analyze_table - Analyzes a table to collect statistics information
- get_execution_plan - Gets the execution plan with runtime statistics for a SQL query
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"
]
}
}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.
