広告掲載
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.

コメント

「その他」の他のコンテンツ

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

MaxKB

1Panel-dev

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

22.0K
N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K
広告掲載