redshift-mcp-server
1
Redshift MCP Server is a Python-based server that allows AI assistants to interact with Amazon Redshift databases using the Model Context Protocol. It provides resources and tools to manage schemas, execute SQL queries, and analyze database tables.
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 that provides tools and resources for interacting with Amazon Redshift databases. It allows AI assistants to list schemas and tables, retrieve table DDL scripts, get table statistics, execute SQL queries, analyze tables, and obtain execution plans.
Installation
Prerequisites
- Python 3.13 or higher
- Amazon Redshift cluster
- Redshift credentials (host, port, username, password, database)
Configuration
Requires environment variables or a .env file for connection settings.
Features
- Resources for listing schemas and tables, retrieving DDL scripts, and getting table statistics.
- Tools for executing SQL, analyzing tables, and getting execution plans.