Sign inTry Free

SingleStore Flow Ingest API

On this page

Note

This is a Preview feature.

The Ingest API enables you to configure pipelines for moving data from a supported source database into SingleStore. You can use this API to:

  • Configure and test connections to supported source databases and the destination database (SingleStore).

  • Retrieve connection details for source and destination databases.

  • Set and retrieve schedules for data transfers, including modes such as manual, periodic, daily, weekly, and monthly.

  • List all databases selected for ingestion.

  • Perform pipeline operations, including full extract, sync struct, sync new tables, and manual delta.

Refer to the Example Flow API Scripts for sample Python and bash applications that use the API.

Base URL

All Ingest API requests must be sent to the following base URL:

http://<host>:<port>/ingest/api/ingest

Where <host> is the hostname or IP address and <port> is the port number where the Ingest service is running.

Ingest API Reference

The following endpoints include HTTP methods, required headers, request and response formats, and example requests.

Additional Information

Supported Database Types

Source Database

Extract Type

Type

Oracle

Log Miner

rds.oracle11lm

Oracle

Fast Log Miner

rds.oracle11lfm

Oracle

Remote Log Miner

rds.oracle11lmrm

Oracle

Continuous Log Miner

rds.oracle11lmc

Oracle

Full extracts

rds.oraclefem

Oracle

Timestamps

rds.oraclets

Oracle (Pluggable Database)

Fast Log Miner

rds.oracle11lmp

Oracle (Pluggable Database)

Continuous Log Miner

rds.oracle11lmcp

Oracle (RAC)

Log Miner

rds.oracle11lmrac

Oracle (RAC)

Continuous Log Miner

rds.oracle11lmcrac

Oracle (RAC) (Pluggable Database)

Log Miner

rds.oracle11lmracp

Oracle 19c

Continuous Log Miner

rds.oracle11lmc19

Oracle 19c (Pluggable Database)

Continuous Log Miner

rds.oracle11lmcp19

Microsoft SQL Server

Change Tracking

rds.msadbctm

Microsoft SQL Server

CDC

rds.mscdcm

Microsoft SQL Server

Full extracts

rds.msfull

Microsoft SQL Server

Timestamps

rds.msts

MySQL 5.1 or higher

Log

rds.mysql

MySQL 5.1 or higher

Continuous

rds.mysqlc

Postgres

Log

rds.pgres

MongoDB

Self-managed

rds.mongo

MongoDB

Atlas

rds.mongoatlas

Any Database

Full Extracts

rds.jdbcfe

Default Ports

Source Database

Default Port

Oracle

1521

Microsoft SQL Server

1433

MySQL 5.1 or higher

3306

Postgres

5432

Last modified: October 20, 2025

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK