Enables AI assistants to interact with Amazon Redshift databases, providing capabilities to list schemas and tables, retrieve table DDL scripts, get table statistics, execute SQL queries, analyze tables, and get execution plans.
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
Configuration
The server requires the following environment variables to connect to your Redshift cluster:
You can set these environment variables directly or use a .env
file.
Usage
Starting the server
Integrating with AI assistants
To use this server with an AI assistant that supports MCP, add the following configuration to your MCP settings:
Features
Resources
The server provides the following resources:
rs:///schemas
- Lists all schemas in the databasers:///{schema}/tables
- Lists all tables in a specific schemars:///{schema}/{table}/ddl
- Gets the DDL script for a specific tablers:///{schema}/{table}/statistic
- Gets statistics for a specific table
Tools
The server provides the following tools:
execute_sql
- Executes a SQL query on the Redshift clusteranalyze_table
- Analyzes a table to collect statistics informationget_execution_plan
- Gets the execution plan with runtime statistics for a SQL query
Examples
Listing schemas
Listing tables in a schema
Getting table DDL
Executing SQL
Analyzing a table
Getting execution plan
Development
Project structure
Dependencies
mcp[cli]>=1.5.0
- Model Context Protocol SDKpython-dotenv>=1.1.0
- For loading environment variables from .env filesredshift-connector>=2.1.5
- Python connector for Amazon Redshift
This server cannot be installed
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
A Model Context Protocol server that enables AI assistants to interact with Amazon Redshift databases, allowing for schema exploration, query execution, and statistics collection.
Related MCP Servers
- -securityFlicense-qualityA comprehensive Model Context Protocol server implementation that enables AI assistants to interact with file systems, databases, GitHub repositories, web resources, and system tools while maintaining security and control.Last updated -161TypeScript
- -securityFlicense-qualityA Model Context Protocol server that enables AI assistants to securely interact with Apache IoTDB databases through a controlled interface for listing tables, reading data, and executing SQL queries.Last updated -Python
MongoDB MCP Serverofficial
AsecurityAlicenseAqualityA Model Context Protocol server that enables AI assistants to interact with MongoDB Atlas resources through natural language, supporting database operations and Atlas management functions.Last updated -208,801436TypeScriptApache 2.0- AsecurityAlicenseAqualityA Model Context Protocol server that provides read-only MySQL database queries for AI assistants, allowing them to execute queries, explore database structures, and investigate data directly from AI-powered tools.Last updated -35767TypeScriptMIT License