Skip to main content

SQLTide
by SQLStack

Streaming pipelines for ClickHouse, in typed SQL.

Change your SQL, see exactly what will rebuild, and replay it from retained stream history.
Website · Demo · Playground · Get started · Docs

PyPI Verification Python versions License

SQLTide brings dbt-style authoring and deployment to streaming. Models compile into ClickHouse tables and materialized views, every build shows its plan first, and a change to your logic is rebuilt from retained Kafka history.

uv tool install sqltide        # or: pip install sqltide
sqt playground                 # create an orders project and start it with Docker

sqt playground creates a small orders project you run on your own machine with Docker: plan a change, build it as a candidate beside the live version, then promote it without changing the consumer's query. Add --template streaming for the same workflow over live order events from Redpanda. Each project's README.md walks through every command; see the playground reference.

To look around the development UI before installing anything, open the UI demo: the same UI in your browser. In desktop Chrome, Edge and Firefox it runs a real ClickHouse engine in the page, so you can promote a staged change and watch the query switch.

SQLTide lineage view showing an orders pipeline

Key features

  • Typed SQL models. Explicit output types, __source() and __ref() dependencies, and offline compilation with no warehouse connection.
  • Replay-aware builds. Affected models are reconstructed from retained stream history.
  • Plans before changes. sqt plan is read-only, and sqt build replans against current warehouse state before it runs.
  • Staged deployments. Build virtually, then audit, promote, and roll back.
  • Quality built in. SQL tests, audits, sensors, and SQLClean rules and formatting.
  • A UI for operating it. Sources, lag, lineage, plans, runs, and quality in sqt dev, with trusted-proxy or password authentication for shared installations.

Example

A source and a model:

sources:
  - name: orders
    kind: kafka
    broker_list: kafka:9092
    topic: source.orders
    replay_boundary:
      mode: offsets
MODEL (
  engine "MergeTree()",
  order_by ["order_id", "_replay_partition", "_replay_offset"],
);

SELECT
  order_id::String AS order_id,
  _replay_partition::Int32 AS _replay_partition,
  _replay_offset::Int64 AS _replay_offset,
  _replay_timestamp::DateTime64(3) AS _replay_timestamp
FROM __source("orders")

Quick start

sqt discover    # inspect authored resources
sqt compile     # validate offline
sqt plan        # read-only warehouse plan
sqt build       # confirm and execute
sqt test
sqt audit
sqt dev         # local UI at 127.0.0.1:8000

sqt playground runs this workflow on a ready-made project locally with Docker; the quickstart walks through it step by step.

Documentation

License

Apache-2.0

Metadata

Release files for sqltide 0.70.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqltide 0.70.1
File Size Uploaded Provenance Actions
sqltide-0.70.1.tar.gz 2.4 MB With provenance Details for sqltide-0.70.1.tar.gz

Built distributions (wheels)

Table of built distributions (wheels) for sqltide 0.70.1
File Actions
sqltide-0.70.1-cp312-abi3-win_amd64.whl CPython 3.12 abi3 Windows x86-64 Details for sqltide-0.70.1-cp312-abi3-win_amd64.whl
sqltide-0.70.1-cp312-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl CPython 3.12 abi3 Linux glibc 2.17+ x86-64 Details for sqltide-0.70.1-cp312-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
sqltide-0.70.1-cp312-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl CPython 3.12 abi3 Linux glibc 2.17+ ARM64 Details for sqltide-0.70.1-cp312-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl
sqltide-0.70.1-cp312-abi3-macosx_11_0_arm64.whl CPython 3.12 abi3 macOS 11.0+ ARM64 Details for sqltide-0.70.1-cp312-abi3-macosx_11_0_arm64.whl
sqltide-0.70.1-cp312-abi3-macosx_10_12_x86_64.whl CPython 3.12 abi3 macOS 10.12+ x86-64 Details for sqltide-0.70.1-cp312-abi3-macosx_10_12_x86_64.whl

Total release size: 115.9 MB

Release files / sqltide-0.70.1.tar.gz

Download URL sqltide-0.70.1.tar.gz
Size 2.4 MB
Tags Source
SHA-256 checksum
How to use checksums
bb4d90e3145d3c0bf09291f43a03cab4ec0ceba80bb4cba6ea46f10b1bf129b8
BLAKE2b-256 checksum
How to use checksums
3b119bf40ce193b69158637b696624b7c8c2622fa1a163db14d071069229f4f0
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 14, 2026.

Transparency log

Release files / sqltide-0.70.1-cp312-abi3-win_amd64.whl

Download URL sqltide-0.70.1-cp312-abi3-win_amd64.whl
Size 25.0 MB
Tags CPython 3.12 Windows x86-64 abi3
SHA-256 checksum
How to use checksums
798fdc24235de2db07213707ce3ea61c5265187b5b784b826e3517bdfcb7a8c7
BLAKE2b-256 checksum
How to use checksums
0d2e93f5dd78cb48cf4f4788e85a97c939bb4b481853e902fa325809aa426ad8
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 14, 2026.

Transparency log

Release files / sqltide-0.70.1-cp312-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl

Download URL sqltide-0.70.1-cp312-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Size 22.6 MB
Tags CPython 3.12 Linux glibc 2.17+ x86-64 abi3
SHA-256 checksum
How to use checksums
b90842e2bbb8cb1d108bb63ede1ab5b0e985ac9aba5472ee5fe7b4dd8e0c99e3
BLAKE2b-256 checksum
How to use checksums
c0f26cef54bdb64a047e71fb5c1676c7f44d5b1694131a730faee21b0cbfbb63
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 14, 2026.

Transparency log

Release files / sqltide-0.70.1-cp312-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl

Download URL sqltide-0.70.1-cp312-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl
Size 21.7 MB
Tags CPython 3.12 Linux glibc 2.17+ ARM64 abi3
SHA-256 checksum
How to use checksums
8b6afac1af49673e2954f39ca2a4fbf5cb247d6e47a3378a8a1d1fc658bb57ef
BLAKE2b-256 checksum
How to use checksums
b0b9706fc28f7255f1b1601131705f801eab9b2cb4e13fce09f7c0ebd6c3ed58
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 14, 2026.

Transparency log

Release files / sqltide-0.70.1-cp312-abi3-macosx_11_0_arm64.whl

Download URL sqltide-0.70.1-cp312-abi3-macosx_11_0_arm64.whl
Size 21.6 MB
Tags CPython 3.12 abi3 macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
6b4650e850df65677c18cb52006267cb1e3646a87c94955b9f772898fa87190e
BLAKE2b-256 checksum
How to use checksums
631b85becc34f186640ad2d1ae8d68eda07c003be4cc32c44ef8f257cf6383e2
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 14, 2026.

Transparency log

Release files / sqltide-0.70.1-cp312-abi3-macosx_10_12_x86_64.whl

Download URL sqltide-0.70.1-cp312-abi3-macosx_10_12_x86_64.whl
Size 22.6 MB
Tags CPython 3.12 abi3 macOS 10.12+ x86-64
SHA-256 checksum
How to use checksums
9b4e0d75df7cf3cf9a4c869f540900c1c78788382d4c28e71afd86682bba27e7
BLAKE2b-256 checksum
How to use checksums
d2c2dc316c8107150d8efc648187434e66c2e4cb9137781a778f094294995c89
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 14, 2026.

Transparency log

Security for sqltide 0.70.1

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Full provenance

All 6 files in this release have been uploaded with provenance metadata.

Select from 6 files

Attestation for sqltide-0.70.1.tar.gz

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 14, 2026.

Transparency log

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

0.70.1 This release

6 release files Full provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page