apache-cassandra-mcp-server-by-cdata

apache-cassandra-mcp-server-by-cdata

0
databases

CData's MCP Server for Apache Cassandra is a specialized server designed for integrating Apache Cassandra with Live Language Models (LLMs), enabling natural language queries on live data. It provides a read-only interface through a simple setup and utilizes the CData JDBC Driver.

CData's MCP Server for Apache Cassandra

A read-only Model Context Protocol (MCP) Server that allows Live Language Models (LLMs) like Claude Desktop to query live data from Apache Cassandra via the CData JDBC Driver for Apache Cassandra. The server wraps the driver and makes data available through a simple MCP interface.

Purpose

  • Allow LLMs to query live data from Apache Cassandra.
  • Expose Apache Cassandra as a relational SQL model.

Setup Guide

  • Clone repository and build the server with Maven.
  • Install and license the CData JDBC Driver.
  • Configure a connection to the data source.
  • Create a .prp file for JDBC connection.

Usage with Claude Desktop

  • Create and configure a config file for Claude Desktop to integrate MCP server.

Running the Server

  • Run the server using a specified command to make it available to clients on the same machine.

Usage Details

  • The AI client can use built-in tools to handle data tasks like reading and updating. Simply ask questions to retrieve information.

Tools & Descriptions

  • {servername}_get_tables: List all available tables.
  • {servername}_get_columns: List columns for a specified table.
  • {servername}_run_query: Execute SQL SELECT queries.

Troubleshooting

  • Suggestions for visibility and connectivity issues.
  • Contact options for further support.