広告掲載
MCP.so
ログイン

MCP Server for Amazon Redshift

@snahmod

リポジトリ

基本情報

カテゴリ

クラウドとインフラ

ライセンス

MIT

トランスポート

stdio

作者

snahmod

MCP Server for Amazon Redshift について

概要はまだありません

MCP Server for Amazon Redshift の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

MCP Server for Amazon Redshift のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MCP Server for Amazon Redshift?

The MCP Server for Amazon Redshift is a Model Context Protocol (MCP) server that provides a standardized interface for AI models to interact with Amazon Redshift databases. It enables listing tables, retrieving schema information, and executing read-only SQL queries.

How to use MCP Server for Amazon Redshift?

Install Node.js 18+, clone the repository, run npm install and npm run build, then configure environment variables for Redshift connection and transport type. Run with npm start for production or npm run dev for development. The server exposes three tools: list_tables, get_tables_schema, and query.

Key features of MCP Server for Amazon Redshift

  • List tables, views, and materialized views across multiple schemas
  • Get detailed schema information for multiple tables in a single request
  • Execute read-only SQL queries against Redshift
  • Support for stdio and SSE (Server-Sent Events) transport
  • Type-safe implementation in TypeScript

Use cases of MCP Server for Amazon Redshift

  • AI‑powered data exploration without direct SQL access
  • Schema discovery for analytics and reporting tools
  • Read-only query execution for LLM‑driven data analysis
  • Integrating Redshift data into MCP‑compatible assistants

よくある質問

1

What prerequisites are needed to run the server?

Node.js 18 or higher, access to a Redshift database, and properly configured environment variables for host, port, database, user, password, and schemas.

2

How are queries secured against accidental writes?

All queries are executed in read-only transactions, preventing any data modification.

3

What transports does the server support?

It supports both stdio (default) and SSE (Server-Sent Events). Set `TRANSPORT_TYPE` to `sse` and optionally configure a port.

4

Are there any known limitations?

The server is based on the PostgreSQL MCP server and may inherit its limitations. CORS is enabled for SSE transport and should be configured for production.

5

Where does the configuration data live?

Configuration is stored in a `.env` file in the root directory, which must contain Redshift connection details and server settings.

コメント

「クラウドとインフラ」の他のコンテンツ

Webshare

Webshare

The official Webshare MCP server. Manage your proxies, usage, plans and billing from Claude, Cursor or any MCP client. Sign in with OAuth, no API key.

Backblaze B2 MCP server

backblaze-labs

MCP server for Backblaze B2 Cloud Storage: a focused, safe 40-tool surface (17 native B2 SDK, 19 S3 data-plane, 4 analytics) for any MCP-compatible AI client, currently incubating in Backblaze-Labs

2

MCP Gateway

mcp-ecosystem

🧩 MCP Gateway - A lightweight gateway service that instantly transforms existing MCP Servers and APIs into MCP servers with zero code changes. Features Docker deployment and management UI, requiring no infrastructure modifications.

2.2K

Kilo IoT Platform

Kilo IoT

Your AI can finally reach the physical world. Kilo is an AI-first IoT platform for commercial and industrial operations, and this connector hands a live deployment to the AI client you already use. Not an export. Not a

monadomain-mcp

themonagroup

Buy .vn and 371 international domains in VND inside Claude Code, Codex or Cursor. Search and reserve as a guest, pay by VietQR, sign in with MONA Pass once to claim; the agent then points DNS and SSL at your app. Alias o

広告掲載