MCP.so
登录

Amazon Redshift MCP Server By Cdata

@CDataSoftware

基本信息

分类

云与基础设施

许可证

MIT license

传输方式

stdio

作者

CDataSoftware

关于 Amazon Redshift MCP Server By Cdata

This read-only MCP Server allows you to connect to Amazon Redshift data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at

#amazon-redshift#mcp-server#cdata

Amazon Redshift MCP Server By Cdata 配置

暂无标准配置

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

代码仓库

Amazon Redshift MCP Server By Cdata 工具

工具列表暂未提供

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

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

概览

What is amazon-redshift-mcp-server-by-cdata?

Amazon-redshift-mcp-server-by-cdata is a read-only MCP (Model Context Protocol) server built by CData that allows LLMs like Claude Desktop to query live data from Amazon Redshift using natural language. It wraps the CData JDBC Driver for Amazon Redshift and exposes the data as relational SQL models through a simple MCP interface, requiring no manual SQL from the user.

How to use amazon-redshift-mcp-server-by-cdata?

Clone the repository, build with mvn clean install, download and install the CData JDBC Driver for Amazon Redshift, license it, create a connection string using the driver’s utility, then configure a .prp file with connection properties. Finally, add the server to your Claude Desktop config (claude_desktop_config.json) using the built JAR and the .prp file, then restart Claude Desktop.

Key features of amazon-redshift-mcp-server-by-cdata

  • Read-only access to Amazon Redshift data via MCP
  • Works with LLMs like Claude Desktop for natural language queries
  • Exposes tools: {server}_get_tables, {server}_get_columns, {server}_run_query
  • Uses CData JDBC Driver for connectivity
  • Supports all tables or explicitly declared tables
  • Communicates via stdio transport (same machine only)

Use cases of amazon-redshift-mcp-server-by-cdata

  • Letting a business analyst ask “What is the correlation between closed won opportunities and account industry?” without writing SQL
  • Enabling an AI assistant to answer “How many open tickets do I have in the SUPPORT project?” from Redshift data
  • Providing real-time Redshift querying to LLM-based chat interfaces for ad‑hoc data exploration

常见问题

1

What is the difference between this read-only MCP server and the full CData MCP Server for Amazon Redshift?

This server is read-only; it only supports SQL SELECT queries. For full read, write, update, delete, and action capabilities, CData offers a separate free beta MCP Server for Amazon Redshift with a simplified setup.

2

What are the runtime requirements?

You need Java (to run the JAR), Maven (to build from source), and the CData JDBC Driver for Amazon Redshift (downloaded and licensed separately). The driver must be installed and its JAR path provided in the `.prp` file.

3

Where does the data live?

Data stays in your Amazon Redshift instance. The MCP server connects to it via the JDBC driver using a connection string; no data is copied or stored locally by the server itself.

4

What transport does the server use?

The server uses `stdio` as its transport layer, meaning it can only be used with clients running on the same machine as the server (e.g., Claude Desktop locally).

5

How is authentication handled?

Authentication is configured in the JDBC connection string (e.g., `InitiateOAuth=GETANDREFRESH` for OAuth). You use the driver’s Connection String utility to test and copy the final connection string into the `.prp` file.

评论

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