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, returning keyspace names and replication configurations.
POST	`/keyspaces`	Create a new keyspace with replication settings
GET	`/keyspaces/{keyspace}/tables`	List all tables in a specific keyspace, returning table names and column families.
POST	`/keyspaces/{keyspace}/tables`	Create a new table within a keyspace, requiring primary key and column definitions in the request body.
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, requiring all primary key columns and optional data columns.
PUT	`/keyspaces/{keyspace}/tables/{table}/rows/{primaryKey}`	Update an existing row by primary key, modifying specified columns while preserving others.
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, accepting SELECT, INSERT, UPDATE, or DELETE statements in the body.
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, returning node availability and connection status.
DELETE	`/keyspaces/{keyspace}`	Drop a keyspace and all its tables, permanently removing all contained data.
DELETE	`/keyspaces/{keyspace}/tables/{table}`	Drop a specific table from a keyspace, permanently deleting the table and all its rows.
GET	`/metrics`	Retrieve cluster metrics and performance statistics, including read/write latency and throughput.

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())

Use Apache Cassandra from Claude / Cursor / ChatGPT

Get a hosted MCP endpoint for Apache Cassandra. Paste your Apache Cassandra API key, copy back one URL, drop it into Claude Desktop, Cursor, or any AI client that supports remote MCP. Your AI calls Apache Cassandra directly with your credentials — no local install, works on mobile.

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

Connect in 60 seconds

Paste your Apache Cassandra key → get an MCP URL → paste into Claude/Cursor. Hosted by IOX, encrypted at rest.

Connect Apache Cassandra to your AI →

Apache Cassandra REST API

API Endpoints

Sponsor this page

Code Examples

Use Apache Cassandra from Claude / Cursor / ChatGPT

Connect in 60 seconds

Related APIs