mcp-cassandra-server
If you are the rightful owner of mcp-cassandra-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
This Model Context Protocol (MCP) server integrates the Apache Cassandra database with Claude Desktop, enabling database operations through natural language interactions.
The Cassandra MCP Server is designed to bridge the gap between the Apache Cassandra database and the Claude Desktop environment, allowing users to perform database operations using natural language commands. This integration simplifies complex database tasks by translating user-friendly queries into CQL (Cassandra Query Language) commands. Users can execute a wide range of operations such as querying data, creating tables, inserting, updating, and deleting records, all through intuitive language inputs. The server supports parameterized queries to enhance security and prevent SQL injection attacks. It also provides a structured format for query results, making it easier for users to interpret the data. The server is highly configurable, allowing users to set environment variables for connection details and keyspace configurations. This flexibility ensures that the server can be tailored to fit various deployment scenarios and user requirements.
Features
- Natural language interaction for database operations
- Supports all CQL query types with parameterized queries
- Automatic table creation with schema definition
- Data type conversion between JavaScript and Cassandra
- Structured query result format
Tools
execute_query
Execute CQL queries on the Cassandra database with support for all query types and parameterized inputs.
create_table
Create new tables with defined schema and primary keys, automatically if they don't exist.
insert_data
Insert new records into existing tables with support for all Cassandra data types.
update_data
Update existing records based on conditions with parameterized queries for safety.
delete_data
Remove records based on specified conditions, supporting single or multiple deletions.
list_tables
List all tables in the current keyspace for quick schema discovery.
