CLI and API

Operate SQL Flow from code through the same control-plane contract.

The CLI uses the control-plane API. Scripts and operators therefore share validation, authorization, audit, and desired-state reconciliation.

The job to be done

Move committed data with a path your team can explain.

A capability matters when it removes an operational decision, not when it adds another checkbox. SQL Flow connects source-aware capture, durable progress, target apply, and validation so the page you are reading leads to a usable operating path.

Automation creates connections and pipelines, assigns agents or relay halves, provisions targets, edits tables, and controls lifecycle. SQL Flow handles agent enrollment, approval, and revocation; agent-local secret references; create, assign, start, pause, reload, archive, and delete; target schema check and provision.

Why this path matters

Create and operate complete topologies.

Automation creates connections and pipelines, assigns agents or relay halves, provisions targets, edits tables, and controls lifecycle. SQL Flow handles agent enrollment, approval, and revocation; agent-local secret references; create, assign, start, pause, reload, archive, and delete; target schema check and provision.

What changes for you

Health endpoints support orchestration. Fleet, alert, schema, and log reads integrate with monitoring while webhooks deliver notifications. SQL Flow handles fleet-wide search and status; source and destination positions; alert acknowledgement and resolution; scoped keys and sanitized errors.

The outcome

Tell us how you deploy and authorize automation. We will map API, scopes, audit, and commands.

The payoff

See what the capability changes.

API

One authority

Web and CLI use guarded endpoints.

Scope

Read-only or full

Limit automation to required authority.

Audit

Every mutation

Record actor, path, outcome, and denial.

Where the work happens

The details that make the result usable.

Read each capability as part of the operating path. The important question is not whether a feature exists, but what work it removes and what evidence it leaves behind.

Pipeline automation

Create and operate complete topologies.

Automation creates connections and pipelines, assigns agents or relay halves, provisions targets, edits tables, and controls lifecycle.

SQL Flow handles agent enrollment, approval, and revocation; agent-local secret references; create, assign, start, pause, reload, archive, and delete; target schema check and provision.

  • Agent enrollment, approval, and revocation
  • Agent-local secret references
  • Create, assign, start, pause, reload, archive, and delete
  • Target schema check and provision

Operational integration

Connect replication to existing runbooks.

Health endpoints support orchestration. Fleet, alert, schema, and log reads integrate with monitoring while webhooks deliver notifications.

SQL Flow handles fleet-wide search and status; source and destination positions; alert acknowledgement and resolution; scoped keys and sanitized errors.

  • Fleet-wide search and status
  • Source and destination positions
  • Alert acknowledgement and resolution
  • Scoped keys and sanitized errors

Before you choose

Check the path against your environment.

Use the page-specific details below as a short discovery checklist. They are the conditions and work areas that shape the capability, not generic product promises.

  • Agent enrollment, approval, and revocation
  • Agent-local secret references
  • Create, assign, start, pause, reload, archive, and delete
  • Target schema check and provision
  • Fleet-wide search and status
  • Source and destination positions

The path to confidence

See the work. Make the call. Prove the result.

The page keeps the product detail close to the decision it supports. Your team can see what the software handles automatically, what it changes for the target, and what the result leaves ready to operate.

  1. Create and operate complete topologies.

    Automation creates connections and pipelines, assigns agents or relay halves, provisions targets, edits tables, and controls lifecycle. SQL Flow handles agent enrollment, approval, and revocation; agent-local secret references; create, assign, start, pause, reload, archive, and delete; target schema check and provision.

  2. Connect replication to existing runbooks.

    Health endpoints support orchestration. Fleet, alert, schema, and log reads integrate with monitoring while webhooks deliver notifications. SQL Flow handles fleet-wide search and status; source and destination positions; alert acknowledgement and resolution; scoped keys and sanitized errors.

Keep the plan connected

Take the next useful step.

A capability becomes easier to operate when the next decision follows from the constraint you just uncovered. Explore the related work that completes this part of the path.

Your working set

What this page leaves you with

  • One authority
  • Read-only or full
  • Create and operate complete topologies.
  • Connect replication to existing runbooks.
  • Put replication lifecycle into your runbooks.

Take the next step

Put replication lifecycle into your runbooks.

Tell us how you deploy and authorize automation. We will map API, scopes, audit, and commands.

Talk through my use case