広告掲載
MCP.so
ログイン

Redshift MCP Server (TypeScript)

@paschmaria

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

paschmaria

Redshift MCP Server について

概要はまだありません

#redshift#mcp#typescript#database#server

Redshift MCP Server の設定

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

{
  "mcpServers": {
    "redshift-mcp-server-paschmaria": {
      "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 in Cursor IDE and other MCP-compatible clients to inspect database schemas and execute read-only queries.

How to use Redshift MCP Server (TypeScript)?

Configure the server in a .cursor/mcp.json file (project‑specific or global) with a DATABASE_URL environment variable following the redshift://username:password@hostname:port/database?ssl=true format. Install dependencies with npm install, build with npm run build, and run via npm start or directly with node dist/index.js. For development use npm run dev.

Key features of Redshift MCP Server (TypeScript)

  • Execute read‑only SQL queries with the query tool.
  • Get detailed table structure with the describe_table tool.
  • Find tables containing columns matching a name pattern using find_column.
  • Automatically discover and list schemas, tables, and columns.
  • Provide sample rows (up to 5) with automatic sensitive‑data redaction.
  • Use read‑only transactions and input sanitisation for security.

Use cases of Redshift MCP Server (TypeScript)

  • Inspect database schemas and table structures through natural language.
  • Run ad‑hoc read‑only queries (e.g., count orders by status).
  • Search for columns across all tables (e.g., find columns containing “email”).
  • Retrieve sample data from tables without exposing sensitive information.
  • Obtain table statistics like size, row count, and creation time.

よくある質問

1

What are the prerequisites?

Node.js 16 or higher, TypeScript, access to an Amazon Redshift cluster, and Cursor IDE installed.

2

How do I connect to my Redshift database?

Set the `DATABASE_URL` environment variable to a Redshift‑formatted connection string: `redshift://username:password@hostname:port/database?ssl=true`.

3

Is the server read‑only?

Yes. The server uses read‑only transactions for queries to prevent modifications and sanitises inputs to avoid SQL injection.

4

Where does the data live?

All data stays in your own Amazon Redshift cluster. The server connects directly to it and does not store or expose data outside your environment.

5

What transport and authentication does it use?

The server uses stdio transport. Authentication is handled via the Redshift connection URL (username/password). No additional MCP‑level authentication is required.

コメント

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

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

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

MaxKB

1Panel-dev

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

22.0K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K
広告掲載