Apache Cassandra MCP Server by CData

Name: Apache Cassandra MCP Server by CData
Author: CDataSoftware

@CDataSoftware

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

#apache-cassandra #mcp-server #cdata

Basic information

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\\apache-cassandra.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 Apache Cassandra MCP Server by CData?

Apache Cassandra MCP Server by CData is a read-only Model Context Protocol (MCP) server that lets LLMs like Claude Desktop query live Apache Cassandra data using natural language. It wraps the CData JDBC Driver for Apache Cassandra and exposes Cassandra tables as relational SQL models without requiring direct SQL knowledge.

How to use Apache Cassandra MCP Server by CData?

Clone the repo, build with mvn clean install, install and license the CData JDBC Driver for Apache Cassandra, create a .prp file with driver and connection settings, then configure Claude Desktop’s claude_desktop_config.json to point to the built JAR and the .prp file. The server runs via stdio and is controlled by the AI client.

Key features of Apache Cassandra MCP Server by CData

Read-only access to Apache Cassandra data via MCP
Built on the CData JDBC Driver for Apache Cassandra
Exposes table metadata (get_tables, get_columns)
Allows executing SQL SELECT queries (run_query)
Configured via a simple property (.prp) file
Works with LLM clients like Claude Desktop

Use cases of Apache Cassandra MCP Server by CData

Ask natural language questions about your Cassandra data
Retrieve live table schemas without manual exploration
Run ad‑hoc SQL queries against Cassandra through an LLM
Integrate Cassandra analytics into AI‑powered chat interfaces
Provide read‑only data access for AI assistants

FAQ from Apache Cassandra MCP Server by CData

What does this server do compared to the full CData MCP Server?

This server provides read‑only queries using the CData JDBC Driver for Apache Cassandra. For full CRUD and action capabilities, CData offers a free beta MCP Server for Apache Cassandra.

What dependencies are required?

Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Apache Cassandra (downloaded and installed separately). The driver must be licensed with a trial or full key.

How does data flow and where does it reside?

Data remains in Apache Cassandra; the server sends SQL queries through the JDBC driver and returns results to the LLM client. No local data is stored by the server.

What transport does the server use?

The server uses stdio transport, so it can only run with clients on the same machine, such as Claude Desktop.

Are there authentication or authorization considerations?

The .prp file includes the JDBC connection string which may contain credentials (e.g., OAuth tokens). The driver supports OAuth, and the connection utility handles browser‑based authentication for OAuth‑protected data sources.