SingleStore website screenshot

SingleStore

SingleStore is a cloud-native distributed SQL database designed for real-time analytics and mixed workloads. It offers a management API for provisioning and managing cloud workspaces, and a data API for executing SQL statements over HTTP without requiring native database drivers. SingleStore Helios is the fully managed cloud service providing serverless database capabilities with elastic scaling.

2 APIs 0 Features
DatabaseSQLAnalyticsCloudDistributed SQL

APIs

SingleStore Data API

The SingleStore Data API enables developers to execute SQL statements against a SingleStore Helios database over standard HTTP connections without requiring a native database dr...

SingleStore Management API

The SingleStore Management API is a REST interface for programmatically creating and managing workspace groups and workspaces within SingleStore Helios. It supports provisioning...

Collections

Pricing Plans

Rate Limits

Singlestore Rate Limits

5 limits

RATE LIMITS

FinOps

Semantic Vocabularies

Singlestore Context

0 classes · 9 properties

JSON-LD

API Governance Rules

SingleStore API Rules

8 rules · 3 errors 4 warnings 1 info

SPECTRAL

JSON Structure

Singlestore Workspace Structure

0 properties

JSON STRUCTURE

Example Payloads

Resources

🔗
LinkedIn
LinkedIn
🔗
Website
Website
🌐
DeveloperPortal
DeveloperPortal
🔗
Documentation
Documentation
💰
Pricing
Pricing
📰
Blog
Blog
👥
GitHubOrg
GitHubOrg
📝
Signup
Signup
📜
TermsOfService
TermsOfService
📜
PrivacyPolicy
PrivacyPolicy
💬
Support
Support
🔗
LlmsText
LlmsText

Sources

Raw ↑
opencollection: 1.0.0
info:
  name: SingleStore Management API
  version: v1
request:
  auth:
    type: bearer
    token: '{{bearerToken}}'
items:
- info:
    name: WorkspaceGroups
    type: folder
  items:
  - info:
      name: List Workspace Groups
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/workspaceGroups
      params:
      - name: organizationID
        value: ''
        type: query
        description: Filter results to a specific organization when the authenticated user belongs to multiple organizations.
    docs: Retrieves all workspace groups accessible to the authenticated user within the current organization. Returns a list
      of workspace group objects including their IDs, names, regions, states, and configuration.
  - info:
      name: Create a Workspace Group
      type: http
    http:
      method: POST
      url: https://api.singlestore.com/v1/workspaceGroups
      body:
        type: json
        data: '{}'
    docs: Creates a new workspace group in the specified cloud region for the authenticated user's organization. A workspace
      group defines the network boundary, region, and firewall configuration for workspaces deployed within it.
  - info:
      name: Get a Workspace Group
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/workspaceGroups/:workspaceGroupID
      params:
      - name: workspaceGroupID
        value: ''
        type: path
        description: Unique identifier of the workspace group.
    docs: Retrieves detailed information about a specific workspace group identified by its unique ID, including its current
      state, region, firewall configuration, and associated metadata.
  - info:
      name: Update a Workspace Group
      type: http
    http:
      method: PATCH
      url: https://api.singlestore.com/v1/workspaceGroups/:workspaceGroupID
      params:
      - name: workspaceGroupID
        value: ''
        type: path
        description: Unique identifier of the workspace group.
      body:
        type: json
        data: '{}'
    docs: Updates the configuration of an existing workspace group, such as its name or firewall IP allowlist rules. Only
      the fields provided in the request body are modified; omitted fields remain unchanged.
  - info:
      name: Terminate a Workspace Group
      type: http
    http:
      method: DELETE
      url: https://api.singlestore.com/v1/workspaceGroups/:workspaceGroupID
      params:
      - name: workspaceGroupID
        value: ''
        type: path
        description: Unique identifier of the workspace group.
      - name: force
        value: ''
        type: query
        description: When set to true, terminates the workspace group even if it contains active workspaces.
    docs: Terminates and permanently deletes the specified workspace group and all workspaces within it. This operation is
      irreversible. Use the force parameter to bypass safety checks when the group contains active workspaces.
- info:
    name: Workspaces
    type: folder
  items:
  - info:
      name: List Workspaces
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/workspaces
      params:
      - name: workspaceGroupID
        value: ''
        type: query
        description: Filter workspaces by the unique ID of the workspace group they belong to.
    docs: Retrieves all workspaces accessible to the authenticated user, optionally filtered by workspace group ID. Returns
      workspace details including state, size, endpoint, and configuration.
  - info:
      name: Create a Workspace
      type: http
    http:
      method: POST
      url: https://api.singlestore.com/v1/workspaces
      body:
        type: json
        data: '{}'
    docs: Creates a new workspace within an existing workspace group. The workspace provides compute capacity connected to
      the SingleStore database engine. Workspace size determines the number of vCPUs and memory allocated.
  - info:
      name: Get a Workspace
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/workspaces/:workspaceID
      params:
      - name: workspaceID
        value: ''
        type: path
        description: Unique identifier of the workspace.
    docs: Retrieves detailed information about a specific workspace identified by its unique ID, including its current state,
      endpoint hostname, size, auto-suspend settings, and cache configuration.
  - info:
      name: Update a Workspace
      type: http
    http:
      method: PATCH
      url: https://api.singlestore.com/v1/workspaces/:workspaceID
      params:
      - name: workspaceID
        value: ''
        type: path
        description: Unique identifier of the workspace.
      body:
        type: json
        data: '{}'
    docs: Updates the configuration of an existing workspace, such as its auto-suspend settings, cache multiplier, size, or
      deployment type. Only the fields provided in the request body are modified.
  - info:
      name: Terminate a Workspace
      type: http
    http:
      method: DELETE
      url: https://api.singlestore.com/v1/workspaces/:workspaceID
      params:
      - name: workspaceID
        value: ''
        type: path
        description: Unique identifier of the workspace.
      - name: force
        value: ''
        type: query
        description: When set to true, forces termination of the workspace even if it is in an intermediate state.
    docs: Terminates and permanently deletes the specified workspace. This operation is irreversible. The workspace must be
      in a non-transitional state before it can be terminated.
  - info:
      name: Suspend a Workspace
      type: http
    http:
      method: POST
      url: https://api.singlestore.com/v1/workspaces/:workspaceID/suspend
      params:
      - name: workspaceID
        value: ''
        type: path
        description: Unique identifier of the workspace.
    docs: Suspends an active workspace, pausing compute billing while retaining the workspace configuration and associated
      data. The workspace can be resumed at any time using the resume endpoint.
  - info:
      name: Resume a Workspace
      type: http
    http:
      method: POST
      url: https://api.singlestore.com/v1/workspaces/:workspaceID/resume
      params:
      - name: workspaceID
        value: ''
        type: path
        description: Unique identifier of the workspace.
      body:
        type: json
        data: '{}'
    docs: Resumes a suspended workspace, restoring compute capacity and making the workspace available for database connections.
      Optionally disables auto-suspend when resuming.
- info:
    name: Regions
    type: folder
  items:
  - info:
      name: List Regions
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/regions
    docs: Retrieves all cloud provider regions that support workspace group creation within SingleStore Helios, including
      the cloud provider name and region identifier for each available region.
  - info:
      name: List Shared Tier Regions
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/regions/sharedtier
    docs: Retrieves all cloud provider regions that support shared tier (starter) workspace creation within SingleStore Helios.
- info:
    name: Organizations
    type: folder
  items:
  - info:
      name: Get Current Organization
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/organizations/current
    docs: Retrieves information about the organization associated with the current API key, including the organization ID,
      name, and creation timestamp.
- info:
    name: Jobs
    type: folder
  items:
  - info:
      name: List Jobs
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/jobs
      params:
      - name: organizationID
        value: ''
        type: query
        description: Filter results to a specific organization when the authenticated user belongs to multiple organizations.
    docs: Retrieves all scheduled notebook jobs within the current organization, including job configuration, execution history
      metadata, and scheduling details.
  - info:
      name: Create a Job
      type: http
    http:
      method: POST
      url: https://api.singlestore.com/v1/jobs
      body:
        type: json
        data: '{}'
    docs: Creates a new scheduled notebook job within the current organization. Jobs execute a specified notebook on a defined
      schedule or on demand, targeting a specific workspace and optional database.
  - info:
      name: Get a Job
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/jobs/:jobID
      params:
      - name: jobID
        value: ''
        type: path
        description: Unique identifier of the job.
    docs: Retrieves detailed information about a specific scheduled notebook job identified by its unique job ID, including
      its schedule configuration, execution history, and current status.
  - info:
      name: Delete a Job
      type: http
    http:
      method: DELETE
      url: https://api.singlestore.com/v1/jobs/:jobID
      params:
      - name: jobID
        value: ''
        type: path
        description: Unique identifier of the job.
    docs: Permanently deletes a scheduled notebook job identified by its unique job ID. Any currently executing job instances
      are not affected; only future executions are cancelled.
  - info:
      name: List Job Executions
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/jobs/:jobID/executions
      params:
      - name: jobID
        value: ''
        type: path
        description: Unique identifier of the job.
      - name: start
        value: ''
        type: query
        description: The starting execution number for pagination.
      - name: end
        value: ''
        type: query
        description: The ending execution number for pagination.
    docs: Retrieves the execution history for a specific job, with optional pagination by execution number range. Returns
      execution status, timing, and any associated snapshot notebook paths.
- info:
    name: Secrets
    type: folder
  items:
  - info:
      name: List Secrets
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/secrets
      params:
      - name: name
        value: ''
        type: query
        description: Filter secrets by exact name match.
    docs: Retrieves all secrets defined in the current organization, optionally filtered by name. Secret values are not returned
      in list responses; only metadata such as name, ID, and timestamps are included.
- info:
    name: Files
    type: folder
  items:
  - info:
      name: Get or List Stage File
      type: http
    http:
      method: GET
      url: https://api.singlestore.com/v1/stage/:deploymentID/fs/:stagePath
      params:
      - name: deploymentID
        value: ''
        type: path
        description: Unique deployment identifier associated with a workspace group, used to address the stage filesystem.
      - name: stagePath
        value: ''
        type: path
        description: File or directory path within the stage filesystem.
      - name: metadata
        value: ''
        type: query
        description: When set to 1, returns file metadata (size, type, modified date) instead of file content.
    docs: Retrieves a file from the stage filesystem at the specified path, or lists directory contents when the path points
      to a directory. Use the metadata query parameter to return object metadata instead of file content.
  - info:
      name: Upload a Stage File
      type: http
    http:
      method: PUT
      url: https://api.singlestore.com/v1/stage/:deploymentID/fs/:stagePath
      params:
      - name: deploymentID
        value: ''
        type: path
        description: Unique deployment identifier associated with a workspace group, used to address the stage filesystem.
      - name: stagePath
        value: ''
        type: path
        description: File or directory path within the stage filesystem.
      - name: isFile
        value: ''
        type: query
        description: When set to false, creates a directory instead of uploading a file.
    docs: Uploads a file to the stage filesystem at the specified path, creating parent directories as needed. Existing files
      at the same path are overwritten.
  - info:
      name: Rename or Move a Stage File
      type: http
    http:
      method: PATCH
      url: https://api.singlestore.com/v1/stage/:deploymentID/fs/:stagePath
      params:
      - name: deploymentID
        value: ''
        type: path
        description: Unique deployment identifier associated with a workspace group, used to address the stage filesystem.
      - name: stagePath
        value: ''
        type: path
        description: File or directory path within the stage filesystem.
      body:
        type: json
        data: '{}'
    docs: Renames or moves a file or directory within the stage filesystem from the specified old path to a new path provided
      in the request body.
  - info:
      name: Delete a Stage File
      type: http
    http:
      method: DELETE
      url: https://api.singlestore.com/v1/stage/:deploymentID/fs/:stagePath
      params:
      - name: deploymentID
        value: ''
        type: path
        description: Unique deployment identifier associated with a workspace group, used to address the stage filesystem.
      - name: stagePath
        value: ''
        type: path
        description: File or directory path within the stage filesystem.
    docs: Deletes a file or directory from the stage filesystem at the specified path. Directory deletion removes all contained
      files and subdirectories recursively.
bundled: true