Usage Examples

Name: Usage Examples
Author: sahil1115

@sahil1115

Repository

About Usage Examples

Model Context Protocol for cassandra database

Basic information

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

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 Cassandra MCP Server?

Cassandra MCP Server integrates the Apache Cassandra database with Claude Desktop, enabling database operations through natural language interactions. It is built as a Model Context Protocol (MCP) server.

How to use Cassandra MCP Server?

Run the server via npx: npx @sahil1115/mcp-cassandra-server. Set required environment variables (CASSANDRA_PASSWORD, CASSANDRA_CONTACT_POINTS, CASSANDRA_LOCAL_DC; optionally CASSANDRA_KEYSPACE and CASSANDRA_USERNAME defaulting to "cassandra"). Add the server to Claude Desktop configuration as a stdio tool with the same environment variables.

Key features of Cassandra MCP Server

Natural language interface for Cassandra database operations.
Six built‑in tools: execute_query, create_table, insert_data, update_data, delete_data, and list_tables.
Supports all CQL query types (SELECT, INSERT, UPDATE, DELETE) with parameterized queries to prevent injection.
Auto‑converts JavaScript types to Cassandra data types during insertion.
Primary key configuration for composite and clustering keys in table creation.
Deletes single or multiple records in one operation based on conditions.

Use cases of Cassandra MCP Server

Query data using natural language (e.g., "Show all users from the users table").
Create new tables by describing the schema and primary keys in plain English.
Insert, update, or delete records through conversational requests.
Perform complex analytical tasks such as aggregations, filtering by time range, and ranking.

FAQ from Cassandra MCP Server

What environment variables are required to run Cassandra MCP Server?

You must set CASSANDRA_PASSWORD, CASSANDRA_CONTACT_POINTS, and CASSANDRA_LOCAL_DC. CASSANDRA_KEYSPACE is optional; CASSANDRA_USERNAME defaults to "cassandra".

Does the server support parameterized queries to prevent injection?

Yes. The tools execute_query, insert_data, update_data, and delete_data use parameterized queries for safe execution.

How do I add the server to Claude Desktop?

Add a tool entry in the claude-desktop.config.json with the command npx @sahil1115/mcp-cassandra-server, the required environment variables, and "stdio": true.