广告合作
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 服务器

ICSS

chokcoco

不止于 CSS

20.7K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

Glasswarp

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.

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

广告合作