广告合作
MCP.so
登录

Redshift MCP Server

@tuanknguyen

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

tuanknguyen

关于 Redshift MCP Server

暂无概览

#redshift#mcp-server#database-interaction

Redshift MCP Server 配置

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

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

Redshift MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 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

常见问题

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.

评论

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

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

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

ICSS

chokcoco

不止于 CSS

20.7K

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.

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K
广告合作