What is the Redshift MCP Server?

The Redshift MCP Server is a Python-based implementation of the Model Context Protocol (MCP) that enables AI assistants to interact with Amazon Redshift databases.

What is MCP (Model Context Protocol)?

MCP is an open protocol that standardizes how applications provide context to LLMs. It acts as a bridge, allowing AI models to access and interact with external data sources and tools.

What are the prerequisites for installing the Redshift MCP Server?

You need Python 3.13 or higher, an Amazon Redshift cluster, and Redshift credentials (host, port, username, password, database).

How do I install the Redshift MCP Server?

Clone the repository from GitHub, navigate to the directory, and run uv sync to install dependencies.

How do I configure the Redshift MCP Server?

You need to set environment variables for your Redshift cluster, including host, port, user, password, and database. You can set these directly or use a .env file.

How do I start the Redshift MCP Server?

Run uv run --with mcp python-dotenv redshift-connector mcp followed by mcp run src/redshift_mcp_server/server.py.

What resources does the Redshift MCP Server provide?

The server provides resources for listing schemas (rs:///schemas), listing tables in a schema (rs:///{schema}/tables), getting table DDL (rs:///{schema}/{table}/ddl), and getting table statistics (rs:///{schema}/{table}/statistic).

What tools does the Redshift MCP Server provide?

The server provides tools for executing SQL queries (execute_sql), analyzing tables (analyze_table), and getting execution plans (get_execution_plan).

How do I use the Redshift MCP Server to list schemas?

Use access_mcp_resource("redshift-mcp-server", "rs:///schemas").

How do I execute a SQL query using the Redshift MCP Server?

Use use_mcp_tool("redshift-mcp-server", "execute_sql", {"sql": "SELECT * FROM public.users LIMIT 10"}).

How does the Redshift MCP Server integrate with UBOS?

The Redshift MCP Server integrates seamlessly with UBOS, a full-stack AI Agent Development Platform, enabling you to build AI Agents that can access and analyze your Redshift data.

Where can I find the Redshift MCP Server project structure?

The project structure is organized as follows:

redshift-mcp-server/ ├── src/ │ └── redshift_mcp_server/ │ ├── init.py │ └── server.py ├── pyproject.toml └── README.md