广告合作
MCP.so
登录

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.

常见问题

1

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.

2

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.

评论

其他 分类下的更多 MCP 服务器

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

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

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

广告合作