Debezium and TimescaleDB
In this article, we are going to present and demonstrate a new feature delivered in Debezium 2.4 - the integration with the TimescaleDB database. TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is implemented as an extension for the PostgreSQL database. This fact leads us to re-use the standard Debezium PostgreSQL connector and implement TimescaleDB support as a single message transform (SMT). TimescaleDB provides three basic building blocks/concepts: Hypertables Continuous aggregates Compression Metadata (catalog) that describes the definitions of the instances and the raw data are typically stored in _timescaledb_internal_schema. TimescaleDb SMT connects to the database and reads and processes the metadata. The raw messages read from the database are then enriched with the metadata stored in Kafka Connect headers, creating the relation between the physical data and the TimescaleDB logical constructs. Debezium examples repository contains
Debezium and TimescaleDB Navigation Menu Home Archive Feed Featured Posts What Nobody Explains About Debezium in 2026 (But Should) Join the Debezium Community Weekly Forum Detect data mutation patterns with Debezium Debezium asynchronous engine Debezium and TimescaleDB Streamlined Performance: Debezium JDBC connector batch support Debezium Operator Takes off to the Clouds Debezium signaling and notifications - Part 3: JMX channel Online machine learning with the data streams from the database Debezium signaling and notifications - Part 2: Customisation Debezium signaling and notifications - Pa
Explore this link on the map →saved by
related reading
- Flink CDC for Postgres: Lessons Learned | sap1ens.comsap1ens.com
- Schedule | POSETTE: An Event for Postgres 2024 - Citus Datacitusdata.com
- PostgreSQL CDC - RisingWavedocs.risingwave.com
- debezium-examples/postgres-toast at main · debezium/debezium-examples · GitHubgithub.com
- Ingest data from self-hosted PostgreSQL | Materialize Documentationmaterialize.com
- Track every PostgreSQL data change using Debezium - DEV Communitydev.to
- GitHub - debezium/debezium: Change data capture for a variety of databases. Please log issues at https://github.com/debezium/dbz/issues. · GitHubgithub.com
- Databases in 2024: A Year in Review // Blog // Andy Pavlo - Carnegie Mellon Universitycs.cmu.edu
- Create a continuous aggregate | Tiger Data Docsdocs.timescale.com
- When Boring is Awesome | Tiger Datatimescale.com
- Databases in 2025: A Year in Review // Blog // Andy Pavlo - Carnegie Mellon Universitycs.cmu.edu
- Two Sizes Fit Most: PostgreSQL and ClickHouse - The New Stackthenewstack.io