Cassandra MCP Server

This repository is a pure Node.js MCP server for Apache Cassandra. It uses the cassandra-driver package and MCP stdio transport, so you do not need Java in the MCP server runtime.

What was fixed

• Added a real package.json so npm and npx can detect the package correctly
• Added tsconfig.json so the project can compile
• Made authentication optional instead of always forcing a password
• Fixed prepared statement parameter typing for array values
• Fixed list_tables to use the configured keyspace reliably

Run locally

npm install
npm run build
npx mcp-cassandra-server

Set your Cassandra connection details first:

export CASSANDRA_CONTACT_POINTS=127.0.0.1
export CASSANDRA_LOCAL_DC=datacenter1
export CASSANDRA_KEYSPACE=your_keyspace

# Optional for secured Cassandra clusters
export CASSANDRA_USERNAME=cassandra
export CASSANDRA_PASSWORD=your_password

If your cluster does not require authentication, leave both CASSANDRA_USERNAME and CASSANDRA_PASSWORD unset.

Claude Desktop config

Use a Node stdio MCP server. If you are running from this local repo, point Claude Desktop at the built file directly:

{
  "mcpServers": {
    "cassandra": {
      "command": "node",
      "args": ["/Users/ent-00379/Downloads/mcp-cassandra-server-main/build/index.js"],
      "env": {
        "CASSANDRA_CONTACT_POINTS": "127.0.0.1",
        "CASSANDRA_LOCAL_DC": "datacenter1",
        "CASSANDRA_KEYSPACE": "your_keyspace",
        "CASSANDRA_USERNAME": "cassandra",
        "CASSANDRA_PASSWORD": "your_password"
      }
    }
  }
}

If you publish the package to npm, this also works:

npx -y mcp-cassandra-server-uvipatil

Available tools

execute_query

Execute any CQL query against Cassandra.

Input:

{
  "query": "SELECT * FROM users WHERE id = ?",
  "params": ["123"]
}

create_table

Create a Cassandra table.

Input:

{
  "tableName": "users",
  "schema": {
    "id": "uuid",
    "email": "text",
    "name": "text"
  },
  "primaryKey": "id"
}

insert_data

Insert a row into a table.

update_data

Update rows matching the supplied conditions.

delete_data

Delete rows matching the supplied conditions.

list_tables

List all tables in the configured keyspace.