Usage Examples

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.

Which transport protocol does Cassandra MCP Server use?

It uses stdio transport, as shown in the Claude Desktop configuration example.

What CQL operations can I perform through