Advertise
MCP.so
Sign In

Redshift MCP Server

@tuanknguyen

Repository

Basic information

Category

Other

Transports

stdio

Author

tuanknguyen

About Redshift MCP Server

No overview available yet

#redshift#mcp-server#database-interaction

Redshift MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "redshift-mcp-server": {
      "command": "uv",
      "args": [
        "venv"
      ]
    }
  }
}

Redshift MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Redshift MCP Server?

A Model Context Protocol (MCP) server for interacting with Amazon Redshift databases. It enables developers to run SQL queries, explain query execution plans, list schemas and tables, and test database connectivity through MCP-compatible clients like Amazon Q or Claude.

How to use Redshift MCP Server?

Install Python 3.10+ and uv, then add the server to your MCP config file (e.g., .amazonq/mcp.json) using the stdio transport type, the uvx command, and the server package name redshift-mcp-server. Supply your Redshift credentials via environment variables (REDSHIFT_HOST, REDSHIFT_PORT, REDSHIFT_DATABASE, REDSHIFT_USER, REDSHIFT_PASSWORD). Optionally set FASTMCP_LOG_LEVEL. For development, run mcp dev redshift-mcp-server.

Key features of Redshift MCP Server

  • Run SQL queries on Redshift
  • Explain SQL query execution plans
  • List tables and views in a schema
  • List all schemas in the database
  • Test Redshift database connectivity

Use cases of Redshift MCP Server

  • Explore database structure before writing complex queries
  • Optimize slow queries by reviewing execution plans
  • Automate database administrative tasks via MCP-enabled AI assistants
  • Quickly validate Redshift connection credentials and settings

Frequently asked questions

1

What are the runtime dependencies for Redshift MCP Server?

Python 3.10 or newer and the `uv` package manager are required. The server uses `fastmcp` as its underlying framework.

2

How do I authenticate to Redshift?

Provide your Redshift host, port, database name, username, and password as environment variables (`REDSHIFT_HOST`, `REDSHIFT_PORT`, etc.). Never commit these credentials to version control.

3

What transport protocol does Redshift MCP Server use?

It communicates over standard input/output (`stdio`) with the MCP client, using the `uvx` command to run the server.

4

Does the server check the database connection on startup?

Yes, the server automatically tests the Redshift connection when starting. If the test fails, the server will not start and will raise an error. You can also run a standalone test with `python test_connection.py`.

5

Can I run Redshift MCP Server in development mode?

Yes, use `mcp dev redshift-mcp-server` to launch the server with the MCP Inspector for interactive testing and debugging.

Comments

More Other MCP servers

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Advertise