MCP.so
Sign In
G

Greenplum MCP Server by CData

@CDataSoftware

Repository

About Greenplum MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Greenplum (beta): https://www.cdata.com/download/download.aspx?sku=SGZK-V&type=beta

#greenplum#mcp-server#data-access

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\greenplum.prp"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Greenplum MCP Server by CData?

A read-only MCP server that allows LLMs (like Claude Desktop) to query live Greenplum data using natural language. It wraps the CData JDBC Driver for Greenplum, exposing Greenplum as relational SQL models through a simple MCP interface — no manual SQL required.

How to use Greenplum MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver, create a .prp file with your JDBC connection details, then configure your MCP client (e.g., Claude Desktop) to point to the built JAR and .prp file. The server runs via java -jar CDataMCP-jar-with-dependencies.jar <path-to>.prp.

Key features of Greenplum MCP Server by CData

  • Read-only access to Greenplum data via natural language queries.
  • Built on the CData JDBC Driver for Greenplum.
  • Exposes tables and columns as MCP tools.
  • Supports SQL SELECT queries through the run_query tool.
  • Uses stdio transport, runs on the same machine as the client.

Use cases of Greenplum MCP Server by CData

  • Let an AI assistant answer questions about Greenplum data (e.g., “How many open tickets do I have?”).
  • Enable non-technical users to explore Greenplum data without writing SQL.
  • Integrate live Greenplum data into AI workflows like reporting or dashboards.

FAQ from Greenplum MCP Server by CData

What is the difference between this server and the CData MCP Server for Greenplum (beta)?

This server is read-only. The beta version supports full read, write, update, delete, and action capabilities with a simplified setup.

What are the runtime requirements?

You need Java, Maven, and the CData JDBC Driver for Greenplum installed and licensed.

Where does the data live?

The server queries live Greenplum data directly; it does not store or cache data.

What transport does the server use?

It uses stdio transport, so it can only be used with clients running on the same machine.

How do I handle authentication?

The JDBC driver may require OAuth authentication (e.g., for OAuth-based sources). Use the connection string utility to authenticate and test the connection. A trial or license key is needed to use the driver.

Frequently asked questions

What is the difference between this server and the CData MCP Server for Greenplum (beta)?

This server is read-only. The beta version supports full read, write, update, delete, and action capabilities with a simplified setup.

What are the runtime requirements?

You need Java, Maven, and the CData JDBC Driver for Greenplum installed and licensed.

Where does the data live?

The server queries live Greenplum data directly; it does not store or cache data.

What transport does the server use?

It uses `stdio` transport, so it can only be used with clients running on the same machine.

How do I handle authentication?

The JDBC driver may require OAuth authentication (e.g., for OAuth-based sources). Use the connection string utility to authenticate and test the connection. A trial or license key is needed to use the driver.

Comments

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

More Other MCP servers

AutoBrowser MCP

autobrowser-ai

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser

6.8K

Inbox Zero AI MCP

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

MCP Registry

modelcontextprotocol

A community driven registry service for Model Context Protocol (MCP) servers.

7.0K

MCP Go 🚀

mark3labs

A Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.

8.9K