MCP Server LogoMCP Server
MCPsカテゴリディレクトリ投稿する
投稿する
MCPsカテゴリディレクトリ投稿する
投稿する

MCPサーバー

MCPサーバーのリスト、Awesome MCPサーバーとClaude MCP統合を含む。AIの能力を強化するためのMCPサーバーを検索して発見します。

お問い合わせ

[email protected]

MCPサーバーについて

プライバシーポリシー利用規約

リソース

モデルコンテキストプロトコルMCPスターターガイドClaude MCPサーバー

コミュニティ

GitHub

© 2025 mcpserver.cc © 2025 MCPサーバー. 全著作権所有.

プライバシーポリシー利用規約
  1. Home
  2. /Categories
  3. /Data & Storage
  4. /Redshift Js Mcp Server
Redshift Js Mcp Server

Redshift Js Mcp Server

作成者 paschmaria•19 days ago
サイトを訪問する

Data & Storage
redshiftmcp-servertypescript

Redshift MCP Server (TypeScript)

This is a Model Context Protocol (MCP) server for Amazon Redshift implemented in TypeScript. It follows Anthropic’s implementation pattern and provides Cursor IDE and other MCP-compatible clients with rich contextual information about your Redshift data warehouse. This server enables LLMs to inspect database schemas and execute read-only queries.

Integration with MCP Clients

Project-Specific Configuration

Create a .cursor/mcp.json file in your project directory:

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

Global Configuration

For using across all projects, create ~/.cursor/mcp.json in your home directory with the same configuration.

Client-Specific Setup

Cursor IDE

  1. The server will be automatically detected if configured in mcp.json
  2. Tools will appear under “Available Tools” in MCP settings
  3. Agent will automatically use the tools when relevant

Other MCP Clients

Configure the server using stdio transport:

{
  "servers": [
    {
      "name": "redshift-mcp",
      "transport": {
        "kind": "stdio",
        "command": ["node", "path/to/dist/index.js"]
      }
    }
  ]
}

Prerequisites

  • Node.js 16 or higher
  • TypeScript
  • Access to an Amazon Redshift cluster
  • Basic knowledge of Redshift and SQL
  • Cursor IDE installed

Installation

  1. Clone this repository or copy the files to your local system
  2. Install the dependencies:
npm install
  1. Build the TypeScript code:
npm run build

Usage

The server requires a Redshift connection URL via the DATABASE_URL environment variable:

export DATABASE_URL="redshift://username:password@hostname:port/database?ssl=true"
npm start

Or you can run directly:

DATABASE_URL="redshift://username:password@hostname:port/database?ssl=true" node dist/index.js

For development, you can use:

DATABASE_URL="redshift://username:password@hostname:port/database?ssl=true" npm run dev

Connection URL Format

redshift://username:password@hostname:port/database?ssl=true
  • username: Your Redshift username
  • password: Your Redshift password
  • hostname: Your Redshift cluster endpoint
  • port: Usually 5439 for Redshift
  • database: The name of your database
  • ssl: Set to “true” for secure connection (recommended)

Additional connection parameters:

  • ssl=true: Required for secure connections (recommended)
  • timeout=10: Connection timeout in seconds
  • keepalives=1: Enable TCP keepalive
  • keepalives_idle=130: TCP keepalive idle time

Project Structure

  • src/index.ts: Main TypeScript implementation
  • dist/: Compiled JavaScript output
  • package.json: Project dependencies and scripts
  • tsconfig.json: TypeScript configuration

Components

Tools Available in Cursor

  • query

    • Execute read-only SQL queries against the connected Redshift database
    • Example: “Write a query to show all tables in the public schema”
  • describe_table

    • Get detailed information about a specific table
    • Example: “Show me the structure of the users table”
  • find_column

    • Find tables containing columns with specific name patterns
    • Example: “Find all tables that have a column containing ‘email’”

Resources Available to Cursor

The server provides schema information that Cursor can use:

  • Schema Listings (redshift://<host>/schema/<schema_name>)

    • Lists all tables within a specific schema
    • Automatically discovered from database metadata
  • Table Schemas (redshift://<host>/<schema>/<table>/schema)

    • JSON schema information for each table
    • Includes column names, data types, and Redshift-specific attributes (distribution and sort keys)
  • Sample Data (redshift://<host>/<schema>/<table>/sample)

    • Sample rows from each table (limited to 5)
    • Sensitive data is automatically redacted
  • Statistics (redshift://<host>/<schema>/<table>/statistics)

    • Table statistics including size, row count, and creation time
    • Distribution and compression information

Security Considerations

This server:

  • Uses read-only transactions for queries to prevent modifications
  • Sanitizes inputs to prevent SQL injection
  • Does not expose raw password information in resource URIs
  • Automatically redacts sensitive data in sample results (email, phone)
  • Should be used in a secure environment since it has access to your database

Example Cursor Interactions

Here are some example questions you can ask Cursor once connected:

  1. “Show me all tables in the public schema”
  2. “What’s the structure of the customers table?”
  3. “Find all tables that contain customer information”
  4. “Write a query to count orders by status”
  5. “Show me sample data from the products table”

Extending the Server

You can extend this server by:

  1. Adding new resource types in the ListResourcesRequestSchema and ReadResourceRequestSchema handlers
  2. Adding new tools in the ListToolsRequestSchema and CallToolRequestSchema handlers
  3. Enhancing security features or adding authentication

Development

For development, you can use the npm run dev command, which uses ts-node to run the TypeScript code directly without pre-compilation.

License

MIT

前提条件

  • •サーバーのドメインに精通している
  • •関連技術の基本的な理解
  • •Data & Storageの知識

おすすめのサーバー

Gmail Mcp

Gmail Mcp

Mcp Pubmed Server

Mcp Pubmed Server

PubMed MCP Server for accessing research papers

Mcp 3d Printer Server

Mcp 3d Printer Server

Connects MCP to major 3D printer APIs (Orca, Bambu, OctoPrint, Klipper, Duet, Repetier, Prusa, Creality). Control prints, monitor status, and perform advanced STL operations like scaling, rotation, sectional editing, and base extension. Includes slicing and visualization.

もっと見る → →

詳細

作成日

June 12, 2025

最終更新日

June 12, 2025

カテゴリー

Data & Storage

作成者

paschmaria

シェアする

もっと見る

Nmap Mcp Server

Nmap Mcp Server

A Model Context Protocol (MCP) server that enables AI assistants to perform network scanning operations using NMAP

Ragdocs

Ragdocs

MCP server for RAG-based document search and management

Mcpnotes

Mcpnotes

A simple note-taking MCP server for recording and managing notes with AI models.

Twitch Mcp Server

Twitch Mcp Server

A Model Context Protocol (MCP) server that provides tools for interacting with the Twitch API using the Helix API.