MCP.so
Sign In
A

AlloyDB MCP Server by CData

@CDataSoftware

Repository

About AlloyDB 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 AlloyDB (beta): https://www.cdata.com/download/download.aspx?sku=KYZK-V&type=beta

#alloydb#mcp-server#cdata

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\\alloydb.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 AlloyDB MCP Server by CData?

AlloyDB MCP Server by CData is a read-only Model Context Protocol server that allows LLMs like Claude Desktop to query live data from AlloyDB using natural language, without requiring SQL. It is built on the CData JDBC Driver for AlloyDB and exposes AlloyDB data as SQL models through an MCP interface.

How to use AlloyDB MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for AlloyDB, create a .prp file with your JDBC connection details, then configure the server in your MCP client (e.g., Claude Desktop) by adding an entry to claude_desktop_config.json that points to the Java executable and the JAR file with the .prp file.

Key features of AlloyDB MCP Server by CData

  • Read-only querying of live AlloyDB data from LLMs
  • Natural language queries automatically translated to SQL
  • Exposes tools: get_tables, get_columns, and run_query
  • Uses MCP over stdio transport
  • Requires the CData JDBC Driver for AlloyDB (license needed)
  • Built with Maven and runs on Java

Use cases of AlloyDB MCP Server by CData

  • Ask an LLM “What is the correlation between closed won opportunities and account industry?”
  • Query “How many open tickets do I have in the SUPPORT project?” without writing SQL
  • Retrieve live calendar events by asking “Tell me what calendar events I have today”
  • Explore AlloyDB schemas using natural language via get_tables and get_columns tools

FAQ from AlloyDB MCP Server by CData

Is this server read-only?

Yes, this MCP server is read-only. For full read, write, update, and delete capabilities, CData offers a separate beta MCP Server for AlloyDB.

What dependencies are required to run it?

You need Java, Maven (to build), and the CData JDBC Driver for AlloyDB, which requires a license (a free trial can be used). The server runs on the same machine as the MCP client.

How do I connect to AlloyDB?

Use the CData JDBC Driver’s Connection String utility to generate a JDBC URL (e.g., jdbc:allowdb:InitiateOAuth=GETANDREFRESH;). Place this URL and other settings in a .prp file.

Where does the data stay?

The data remains in your AlloyDB database; the server only queries it live and does not store any data locally.

What transport does the server use?

The server uses stdio transport and therefore can only be used with MCP clients running on the same machine.

Frequently asked questions

Is this server read-only?

Yes, this MCP server is read-only. For full read, write, update, and delete capabilities, CData offers a separate beta MCP Server for AlloyDB.

What dependencies are required to run it?

You need Java, Maven (to build), and the CData JDBC Driver for AlloyDB, which requires a license (a free trial can be used). The server runs on the same machine as the MCP client.

How do I connect to AlloyDB?

Use the CData JDBC Driver’s Connection String utility to generate a JDBC URL (e.g., `jdbc:allowdb:InitiateOAuth=GETANDREFRESH;`). Place this URL and other settings in a `.prp` file.

Where does the data stay?

The data remains in your AlloyDB database; the server only queries it live and does not store any data locally.

What transport does the server use?

The server uses stdio transport and therefore can only be used with MCP clients running on the same machine.

Comments

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

More Other MCP servers

Production-ready MCP integrations for AI applications

Klavis-AI

Klavis AI: MCP integration platforms that let AI agents use tools reliably at any scale

5.8K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

ICSS

chokcoco

不止于 CSS

20.7K

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K