Databases Bearer Token

Apache Cassandra REST API

Distributed NoSQL database for scalable applications

Apache Cassandra is a highly scalable, distributed NoSQL database designed to handle large amounts of data across many commodity servers with no single point of failure. It provides high availability and linear scalability, making it ideal for mission-critical applications that require continuous uptime and massive data volumes. Developers use Cassandra's REST API (via Stargate or similar data gateways) to interact with the database without native drivers.

Base URL https://api.cassandra.example.com/v2

API Endpoints

Method	Endpoint	Description
GET	`/keyspaces`	List all keyspaces in the Cassandra cluster
POST	`/keyspaces`	Create a new keyspace with replication settings
GET	`/keyspaces/{keyspace}/tables`	List all tables in a specific keyspace
POST	`/keyspaces/{keyspace}/tables`	Create a new table within a keyspace
GET	`/keyspaces/{keyspace}/tables/{table}/rows`	Retrieve rows from a table with optional filtering
POST	`/keyspaces/{keyspace}/tables/{table}/rows`	Insert a new row into a table
PUT	`/keyspaces/{keyspace}/tables/{table}/rows/{primaryKey}`	Update an existing row by primary key
DELETE	`/keyspaces/{keyspace}/tables/{table}/rows/{primaryKey}`	Delete a row from a table by primary key
POST	`/keyspaces/{keyspace}/tables/{table}/query`	Execute a CQL query against a table
GET	`/keyspaces/{keyspace}/tables/{table}/schema`	Retrieve the schema definition for a specific table
POST	`/keyspaces/{keyspace}/batch`	Execute multiple operations in a single batch request
GET	`/health`	Check the health status of the Cassandra API gateway
DELETE	`/keyspaces/{keyspace}`	Drop a keyspace and all its tables
DELETE	`/keyspaces/{keyspace}/tables/{table}`	Drop a specific table from a keyspace
GET	`/metrics`	Retrieve cluster metrics and performance statistics

Code Examples

curl -X GET 'https://api.cassandra.example.com/v2/keyspaces/userdata/tables/users/rows?page-size=20' \
  -H 'Authorization: Bearer YOUR_AUTH_TOKEN' \
  -H 'Content-Type: application/json'

const response = await fetch('https://api.cassandra.example.com/v2/keyspaces/userdata/tables/users/rows', {
  method: 'POST',
  headers: {
    'Authorization': 'Bearer YOUR_AUTH_TOKEN',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({
    user_id: '123e4567-e89b-12d3-a456-426614174000',
    email: 'user@example.com',
    created_at: new Date().toISOString()
  })
});
const data = await response.json();
console.log(data);

import requests

url = 'https://api.cassandra.example.com/v2/keyspaces/userdata/tables/users/rows'
headers = {
    'Authorization': 'Bearer YOUR_AUTH_TOKEN',
    'Content-Type': 'application/json'
}
payload = {
    'user_id': '123e4567-e89b-12d3-a456-426614174000',
    'email': 'user@example.com',
    'created_at': '2024-01-15T10:30:00Z'
}

response = requests.post(url, json=payload, headers=headers)
print(response.json())

Connect Apache Cassandra to AI

Deploy a Apache Cassandra MCP server on IOX Cloud and connect it to Claude, ChatGPT, Cursor, or any AI client. Your AI assistant gets direct access to Apache Cassandra through these tools:

query_cassandra_table Execute CQL queries against Cassandra tables with natural language input, automatically translating to proper CQL syntax

create_cassandra_keyspace Create new keyspaces with intelligent replication strategy recommendations based on cluster topology

batch_insert_rows Perform batch insertions with automatic partitioning and optimal batch size calculation for performance

analyze_table_schema Analyze table schemas and provide recommendations for partition key optimization and data modeling

monitor_cluster_health Monitor cluster health metrics and provide intelligent alerts for performance degradation or node issues

Deploy in 60 seconds

Describe what you need, AI generates the code, and IOX deploys it globally.

Deploy Apache Cassandra MCP Server →

Apache Cassandra REST API

API Endpoints

Code Examples

Connect Apache Cassandra to AI

Deploy in 60 seconds

Related APIs