Redshift MCP Server (TypeScript)

@paschmaria

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

paschmaria

Redshift MCP Server について

概要はまだありません

Redshift MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "redshift-js-mcp-server": {
      "command": "node",
      "args": [
        "dist/index.js"
      ],
      "env": {
        "DATABASE_URL": "redshift://username:password@hostname:port/database?ssl=true"
      }
    }
  }
}

Redshift MCP Server のツール

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

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

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

概要

What is Redshift MCP Server (TypeScript)?

It is a Model Context Protocol (MCP) server for Amazon Redshift, implemented in TypeScript. It enables LLMs to inspect database schemas and execute read-only queries on a Redshift data warehouse.

How to use Redshift MCP Server (TypeScript)?

Install Node.js 16+, clone the repository, run npm install and npm run build. Set the DATABASE_URL environment variable (e.g., redshift://username:password@hostname:port/database?ssl=true). Start with npm start or node dist/index.js. For Cursor IDE, configure via .cursor/mcp.json; for other MCP clients, use stdio transport configuration.

Key features of Redshift MCP Server (TypeScript)

Execute read-only SQL queries via the query tool.
Describe table structure with describe_table.
Find tables by column name patterns with find_column.
Provide schema listings, table schemas, sample data, and statistics.
Automatic redaction of sensitive data (email, phone) in samples.
Input sanitization and read-only transactions for security.

Use cases of Redshift MCP Server (TypeScript)

Ask LLMs to list all tables in a given schema.
Retrieve the structure of a specific table (e.g., customers).
Find tables containing columns matching a name pattern (e.g., 'email').
Request sample data from tables for quick inspection.
Write queries to count orders by status or perform aggregations.

よくある質問

How does the server ensure security?

It uses read-only transactions, sanitizes inputs to prevent SQL injection, does not expose raw passwords in resource URIs, and automatically redacts sensitive data (email, phone) in sample results.

What are the prerequisites to run this server?

Node.js 16 or higher, TypeScript, access to an Amazon Redshift cluster, basic SQL knowledge, and for Cursor integration, Cursor IDE installed.

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

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.