Kinetica Database REST API

POST-only JSON REST API exposed by every Kinetica deployment on port 9191. Endpoints cover SQL execution (/execute/sql), record ingest and egress (/insert/records/json, /get/records/json), schema and metadata introspection (/show/table, /show/graph, /show/system/properties), filtering (/filter/byarea, /filter/byradius), aggregation (/aggregate/groupby, /aggregate/statistics, /aggregate/histogram, /aggregate/kmeans), graph creation and solving (/create/graph, /match/graph) and cluster administration (/admin/rebalance, /admin/show/cluster/operations). Authentication is HTTP Basic or an OAuth 2.0 bearer token. The base URL is deployment-specific — clusters are self-hosted or provisioned through Kinetica Cloud — so there is no single public production host.

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/kinetica-database-rest-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.

API entry from apis.yml

apis.yml Raw ↑
name: Kinetica Database REST API
description: POST-only JSON REST API exposed by every Kinetica deployment on port 9191. Endpoints cover
  SQL execution (/execute/sql), record ingest and egress (/insert/records/json, /get/records/json), schema
  and metadata introspection (/show/table, /show/graph, /show/system/properties), filtering (/filter/byarea,
  /filter/byradius), aggregation (/aggregate/groupby, /aggregate/statistics, /aggregate/histogram, /aggregate/kmeans),
  graph creation and solving (/create/graph, /match/graph) and cluster administration (/admin/rebalance,
  /admin/show/cluster/operations). Authentication is HTTP Basic or an OAuth 2.0 bearer token. The base
  URL is deployment-specific — clusters are self-hosted or provisioned through Kinetica Cloud — so there
  is no single public production host.
humanURL: https://docs.kinetica.com/7.2/api/rest/
baseURL: https://cloud.kinetica.com/
x-base-url-note: Deployment-specific. The documented form is http://<db.host>:9191 for a self-managed
  cluster; cloud.kinetica.com is the Kinetica Cloud provisioning console that issues a per-cluster host.
tags:
- Database
- SQL
- Analytics
- Vector Search
- Graph Analytics
- Geospatial
- Time Series
tags_raw:
- database
- sql
- analytics
- vector-search
- graph-analytics
- geospatial
- time-series
properties:
- type: Documentation
  url: https://docs.kinetica.com/7.2/
- type: APIReference
  url: https://docs.kinetica.com/7.2/api/rest/
- type: GettingStarted
  url: https://docs.kinetica.com/7.2/guides/quickstart-guide/
- type: Authentication
  url: authentication/kinetica-authentication.yml
- type: Conventions
  url: conventions/kinetica-conventions.yml
- type: ErrorCatalog
  url: errors/kinetica-error-codes.yml