How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

SingleStore Queries API

Execute SQL statements against a SingleStore Helios workspace over HTTP. Supports DDL, DML, and SELECT statements returning results as JSON.

SingleStore Queries API is one of 9 APIs that SingleStore publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Query. The published artifact set on APIs.io includes an OpenAPI specification and API documentation.

This API exposes 3 operations across 3 paths, and defines 7 schemas. It is described by OpenAPI 3.2.0, at version v2.

Requests are made against a single base URL, https://{workspaceHost}.

3 operations 3 paths 7 schemas 3 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
v2
Base URL
https://{workspaceHost}
Authentication
HTTP Basic, HTTP Bearer
Terms of Service
Resource Areas
1

Authentication & Security 2

SingleStore Queries API declares 2 security schemes for authenticating requests. It accepts HTTP basic authentication (basicAuth). It accepts HTTP bearer tokens (bearerAuth). By default, every request must be authenticated.

  • basicAuth — HTTP Basic Authentication using SingleStore database credentials. Provide the username and password as a Base-64 encoded username:password string in the Author…
  • bearerAuth — Bearer token authentication using a JWT token obtained from the SingleStore Cloud Portal.

Paths & Operations 3

Across 3 paths, the API surfaces 3 operations — 3 POST. Each is listed below with its method, path, parameters, and response codes.

Queries 3

Execute SQL statements against a SingleStore Helios workspace over HTTP. Supports DDL, DML, and SELECT statements returning results as JSON.

POST
/api/v2/exec
Execute a Sql Statement
execSQL body → 200400401500
POST
/api/v2/query/rows
Execute a Sql Query and Return Rows
queryRows body → 200400401500
POST
/api/v2/query/tuples
Execute a Sql Query and Return Tuples
queryTuples body → 200400401500

Schemas 7

The contract defines 7 schemas that model the data the API accepts and returns. The most detailed are QueryRequest (3 properties), Column (3 properties), ExecRequest (3 properties), Error (2 properties). Each schema is shown below with its type and property counts.

ExecRequest
object
Request body for executing a DDL or DML SQL statement that does not return a result set.
3 properties 1 required
Error
object
Standard error response returned when a Data API request fails.
2 properties
QueryRowsResponse
object
Response returned after a successful SELECT query using the rows format, where each result row is a JSON object with column names as keys.
1 property
Column
object
Descriptor for a single column in a query result set.
3 properties
ExecResponse
object
Response returned after successfully executing a DDL or DML statement.
1 property
QueryRequest
object
Request body for executing a SQL SELECT statement and returning a result set.
3 properties 1 required
QueryTuplesResponse
object
Response returned after a successful SELECT query using the tuples format, where columns are described once and rows are arrays of values.
1 property

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

singlestore-queries-api-openapi.yml Raw ↑

Other APIs SingleStore publishes across the network.

SingleStore Files API
SingleStore Health API
SingleStore Jobs API
SingleStore Organizations API
SingleStore Regions API
SingleStore Secrets API
SingleStore WorkspaceGroups API
SingleStore Workspaces API
Where this information came from

This is an independent, third-party profile of SingleStore Queries API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.