Apache Cassandra Rows API

The Rows API from Apache Cassandra — 3 operation(s) for rows.

Operations 7

GET /v2/keyspaces/{keyspace}/{table} Query rows in a table with a WHERE clause #
POST /v2/keyspaces/{keyspace}/{table} Insert a row #
GET /v2/keyspaces/{keyspace}/{table}/rows Retrieve all rows (paged) #
GET /v2/keyspaces/{keyspace}/{table}/{primaryKey} Get a row by primary key #
PUT /v2/keyspaces/{keyspace}/{table}/{primaryKey} Replace a row (upsert) #
PATCH /v2/keyspaces/{keyspace}/{table}/{primaryKey} Partially update a row #
DELETE /v2/keyspaces/{keyspace}/{table}/{primaryKey} Delete a row #

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/cassandra-rows-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

cassandra-rows-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: Apache Cassandra REST API (via Stargate) Columns Rows API
  description: 'Apache Cassandra is accessed primarily via the CQL native protocol, but the

    Stargate data gateway (stargate.io) exposes a documented HTTP REST API that

    sits in front of Cassandra. This best-effort OpenAPI captures the Stargate v2

    REST endpoints for keyspace, table, column, index, type, and row management.

    Source: https://stargate.io/docs/latest/develop/dev-with-rest.html

    '
  version: 2.0.0
  contact:
    name: Apache Cassandra / Stargate
    url: https://cassandra.apache.org/
  license:
    name: Apache 2.0
    url: https://www.apache.org/licenses/LICENSE-2.0.html
servers:
- url: http://{host}:8082
  description: Stargate REST API endpoint in front of a Cassandra cluster
  variables:
    host:
      default: localhost
security:
- cassandraToken: []
tags:
- name: Rows
paths:
  /v2/keyspaces/{keyspace}/{table}:
    get:
      tags:
      - Rows
      summary: Query rows in a table with a WHERE clause
      operationId: queryRows
      parameters:
      - $ref: '#/components/parameters/Keyspace'
      - $ref: '#/components/parameters/Table'
      - in: query
        name: where
        schema:
          type: string
          description: JSON-encoded WHERE clause
      - in: query
        name: fields
        schema:
          type: string
      - in: query
        name: page-size
        schema:
          type: integer
      - in: query
        name: page-state
        schema:
          type: string
      responses:
        '200':
          description: Row page
    post:
      tags:
      - Rows
      summary: Insert a row
      operationId: insertRow
      parameters:
      - $ref: '#/components/parameters/Keyspace'
      - $ref: '#/components/parameters/Table'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              additionalProperties: true
      responses:
        '201':
          description: Row inserted
  /v2/keyspaces/{keyspace}/{table}/rows:
    get:
      tags:
      - Rows
      summary: Retrieve all rows (paged)
      operationId: getAllRows
      parameters:
      - $ref: '#/components/parameters/Keyspace'
      - $ref: '#/components/parameters/Table'
      - in: query
        name: page-size
        schema:
          type: integer
      - in: query
        name: page-state
        schema:
          type: string
      responses:
        '200':
          description: Row page
  /v2/keyspaces/{keyspace}/{table}/{primaryKey}:
    get:
      tags:
      - Rows
      summary: Get a row by primary key
      operationId: getRow
      parameters:
      - $ref: '#/components/parameters/Keyspace'
      - $ref: '#/components/parameters/Table'
      - $ref: '#/components/parameters/PrimaryKey'
      responses:
        '200':
          description: Row
    put:
      tags:
      - Rows
      summary: Replace a row (upsert)
      operationId: replaceRow
      parameters:
      - $ref: '#/components/parameters/Keyspace'
      - $ref: '#/components/parameters/Table'
      - $ref: '#/components/parameters/PrimaryKey'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
      responses:
        '200':
          description: Row replaced
    patch:
      tags:
      - Rows
      summary: Partially update a row
      operationId: updateRow
      parameters:
      - $ref: '#/components/parameters/Keyspace'
      - $ref: '#/components/parameters/Table'
      - $ref: '#/components/parameters/PrimaryKey'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
      responses:
        '200':
          description: Row updated
    delete:
      tags:
      - Rows
      summary: Delete a row
      operationId: deleteRow
      parameters:
      - $ref: '#/components/parameters/Keyspace'
      - $ref: '#/components/parameters/Table'
      - $ref: '#/components/parameters/PrimaryKey'
      responses:
        '204':
          description: Deleted
components:
  parameters:
    Keyspace:
      in: path
      name: keyspace
      required: true
      schema:
        type: string
    Table:
      in: path
      name: table
      required: true
      schema:
        type: string
    PrimaryKey:
      in: path
      name: primaryKey
      required: true
      description: One or more path segments forming the primary key
      schema:
        type: string
  securitySchemes:
    cassandraToken:
      type: apiKey
      in: header
      name: X-Cassandra-Token