广告合作
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.

评论

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

MaxKB

1Panel-dev

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

22.0K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K
广告合作