Database API

SQL query execution and schema inspection

REST API endpoints for Database. 7 operations.

Detect database anomalies

POST /api/v1/anomalies

Analyzes recent activity and returns a report of detected database anomalies.

Auth: Bearer API key

Responses

operationId: detectAnomalies

Translate natural language to SQL

POST /api/v1/nl-to-sql

Generates a SQL statement from a natural-language description of the desired query.

Auth: Bearer API key

Responses

operationId: naturalLanguageToSql

Get query optimization suggestions

POST /api/v1/optimize

Analyzes the tenant's database and returns indexing and query optimization suggestions.

Auth: Bearer API key

Responses

operationId: optimizeQuery

List recent query logs

GET /api/v1/query-logs/{tenant_id}

Returns recent query-log entries for a tenant, newest first.

Auth: Bearer API key

Parameters

Responses

operationId: listQueryLogs

Get scaling suggestions

GET /api/v1/scaling

Returns capacity and scaling recommendations for the tenant's database.

Auth: Bearer API key

Responses

operationId: getScalingSuggestions

Execute a SQL query

POST /api/v1/sql

Runs a parameterized SQL statement against the tenant's database and returns the result set.

Auth: Bearer API key

Request body

application/json (required) — schema SqlRequest.

Responses

operationId: executeSql

Execute a batch of SQL queries

POST /api/v1/sql/batch

Runs multiple SQL statements in one request; each query executes independently and returns its own result set.

Auth: Bearer API key

Request body

application/json (required) — schema BatchSqlRequest.

Responses

operationId: batchSql