MCP Server for Amazon Redshift

@snahmod

代码仓库

基本信息

分类

云与基础设施

许可证

MIT

传输方式

stdio

作者

snahmod

关于 MCP Server for Amazon Redshift

暂无概览

MCP Server for Amazon Redshift 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MCP Server for Amazon Redshift 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MCP Server for Amazon Redshift?

The MCP Server for Amazon Redshift is a Model Context Protocol (MCP) server that provides a standardized interface for AI models to interact with Amazon Redshift databases. It enables listing tables, retrieving schema information, and executing read-only SQL queries.

How to use MCP Server for Amazon Redshift?

Install Node.js 18+, clone the repository, run npm install and npm run build, then configure environment variables for Redshift connection and transport type. Run with npm start for production or npm run dev for development. The server exposes three tools: list_tables, get_tables_schema, and query.

Key features of MCP Server for Amazon Redshift

List tables, views, and materialized views across multiple schemas
Get detailed schema information for multiple tables in a single request
Execute read-only SQL queries against Redshift
Support for stdio and SSE (Server-Sent Events) transport
Type-safe implementation in TypeScript

Use cases of MCP Server for Amazon Redshift

AI‑powered data exploration without direct SQL access
Schema discovery for analytics and reporting tools
Read-only query execution for LLM‑driven data analysis
Integrating Redshift data into MCP‑compatible assistants

常见问题

What prerequisites are needed to run the server?

Node.js 18 or higher, access to a Redshift database, and properly configured environment variables for host, port, database, user, password, and schemas.

How are queries secured against accidental writes?

All queries are executed in read-only transactions, preventing any data modification.

What transports does the server support?

It supports both stdio (default) and SSE (Server-Sent Events). Set `TRANSPORT_TYPE` to `sse` and optionally configure a port.

Are there any known limitations?

The server is based on the PostgreSQL MCP server and may inherit its limitations. CORS is enabled for SSE transport and should be configured for production.

Where does the configuration data live?

Configuration is stored in a `.env` file in the root directory, which must contain Redshift connection details and server settings.

云与基础设施分类下的更多 MCP 服务器

OutageDeck

outagedeck

Official OutageDeck MCP server for vendor-published cloud and SaaS status, incident timelines, and observed uptime history.

container-use

aluzzardi

Development environments for coding agents. Enable multiple agents to work safely and independently with your preferred stack.

3.9K

🐳 docker-mcp

QuantGeekDev

A docker MCP Server (modelcontextprotocol)

490

YesTechie — UniFi Network & Security Integrator

YesTechie

YesTechie builds enterprise UniFi networks, cameras, access control, cabling and Wi-Fi for businesses nationwide from its California HQ. Agents can read real project case studies and practical configuration guides, price

SimpleBackups

SimpleBackups is automated backup management for databases, servers, cloud storage and SaaS apps. It covers Supabase, Neon, PlanetScale, PostgreSQL, MySQL, MongoDB, and apps like Notion, GitHub and Linear. This connector