Usage Examples MCP Server

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.