Redshift MCP Server

Name: Redshift MCP Server
Author: tuanknguyen

@tuanknguyen

代码仓库

关于 Redshift MCP Server

暂无概览

#redshift #mcp-server #database-interaction

基本信息

分类

其他

运行时

python

传输方式

stdio

发布者

tuanknguyen

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

FAQ from Redshift MCP Server

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.

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.

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.

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.

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.

其他分类下的更多 MCP 服务器

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K