Code First CDC from Postgres to ClickHouse with MooseStack

In plain words

MooseStack provides a code-first approach to setting up change data capture (CDC) from PostgreSQL databases to ClickHouse. It allows developers to define CDC pipelines programmatically rather than through configuration files. The tool is designed for data engineers and developers who need to sync data between PostgreSQL and ClickHouse efficiently. It's available as an open-source project on GitHub, making it accessible for teams building real-time data pipelines.

written from the facts on this page · September 2026

From the sources

Easy-to-run demo of a CDC pipeline using Debezium (Kafka Connect), PostgreSQL, Redpanda, and ClickHouse. On first start, Moose runs the script configured in moose.config.toml : [ http_server_config ] # ... on_first_start_script = " ./setup-cdc.sh " What setup-cdc.sh does: You’ll see the script’s output and subsequent CDC logs in the same terminal where you ran moose dev . The startup script will seed 10 rows per table. You can seed more rows by running the following commands: # Seed all tables (10 records each) pnpm db:seed # Or seed specific tables / counts pnpm db:seed:customers 100 pnpm db:seed:another 50 # Clear data pnpm db:clear pnpm db:clear:customers pnpm db:clear:another 4)…from github.com

• PS
  Peerdb Streams – Simple, native Postgres change data capture2024 · ▲177

  Hello HN, I am Sai Srirampur, one of the Co-founders of PeerDB. (https://github.com/PeerDB-io/peerdb). We spent the past 7 months building a solid experience to replicate data from Postgres to data warehouses. Now we're expanding to queues. PeerDB Streams provides a simple and native way to replicate changes as they happen in Postgres to Queues (Kafka, Redpanda, Google PubSub, etc). We use Postgres logical decoding to enable Change Data Capture (CDC). Blog post here: https://blog.peerdb.io/peerdb-streams-simple-native-postgres.... 10-min quickstart here:…

• MP
  Managed Postgres with native ClickHouse integrationJan 2026 · ▲45

  Hello HN, this is Sai and Kaushik from ClickHouse. Today we are launching a Postgres managed service that is natively integrated with ClickHouse. It is built together with Ubicloud (YC W24). TL;DR: NVMe-backed Postgres + built-in CDC into ClickHouse + pg_clickhouse so you can keep your app Postgres-first while running analytics in ClickHouse. Try it (private preview): https://clickhouse.com/cloud/postgres Blog w/ live demo: https://clickhouse.com/blog/postgres-managed-by-clickhouse Problem Across many fast-growing companies using Postgres,…

• 
  Tabstack Dev ToolsJun 2026 · tabstack.ai · ▲319

  Ditch your scraper. Make one API call with any tool.

• MD
  Multiplayer Demo Built with Elixir2022 · multiplayer.dev · ▲221

  Hey HN, I’m an engineer at Supabase [0] and one of the creators of this demo. My team and I have been working hard to bring developers the next version of Supabase Realtime. The current version of Realtime [1] is a Change Data Capture (CDC) server for a PostgreSQL database that broadcasts changes via WebSockets to authorized subscribers. It’s written in Elixir/Phoenix. The server utilizes PostgreSQL’s logical replication functionality, which writes database changes to Write-Ahead Logging (WAL) segment files, and a replication slot, responsible for managing and retaining WAL files.…

• 
  pgwire-replication - pure rust client for Postgres CDCJan 2026 · github.com · ▲46

  Lean tokio-based Postgres wire-protocol logical replication client (pgoutput) with TLS and SCRAM. - vnvo/pgwire-replication

• 
  ScratchDB – Open-Source Snowflake on ClickHouse2023 · github.com · ▲261

  Hello! For the past year I’ve been working on a fully-managed data warehouse built on Clickhouse. I built this because I was frustrated with how much work was required to run an OLAP database in prod: re-writing my app to do batch inserts, managing clusters and needing to look up special CREATE TABLE syntax every time I made a change. I found pricing for other warehouses confusing (what is a “credit” exactly?) and worried about getting capacity-planning wrong. I was previously building accounting software for firms with millions of transactions. I desperately needed to move from Postgres to…

• 
  /dev/null▲486

  a social network for devs

  Dev tools · 3d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 28d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 26d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 23d ago · openbot.run

• 
  Talanoa▲346

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 21d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 28d ago · corespeed.io

• 
  Cursor 2.0▲957

  Our first coding model and new interface for agents

  AI · Oct 2025 · cursor.com

• 
  Flask▲806

  Notion + Loom, for video collaboration.

  AI · 2025 · flask.do

• 
  Strange Attractors▲804

  I went down the rabbit hole on a side project and ended up building this: Strange Attractors(https://blog.shashanktomar.com/posts/strange-attractors). It’s built with three.js. Working on it reminded me of the little "maths for fun" exercises I used to do while learning programming in early days. Just trying things out, getting fascinated and geeky, and being surprised by the results. I spent way too much time on this, but it was extreme fun. My favorite part: someone pointed me to the Simone Attractor on Threads. It is a 2D attractor and I asked GPT to extrapolate it to…

  AI · Oct 2025 · blog.shashanktomar.com

• 
  Orchestra▲793

  A chat-centric workspace for builders and modern teams

  Work · 2025 · orch.so

• 
  Autism Simulator▲779

  Hey all, I built this. It’s not trying to capture every autistic experience (that’d be impossible). It’s based on my own lived experience as well as that of friends on the spectrum. I'm trying to give people a feel for what masking, decision fatigue, and burnout can look like day-to-day. That’s hard to explain in words, but easier to show through choices and stats. I'm not trying to "define autism". I’ve gotten good feedback here about resilience, meds, and difficulty tuning. I’ll keep tweaking it. If even a few people walk away thinking, "ah, maybe that’s why my coworker struggles in those…

  Life & fun · 2025 · autism-simulator.vercel.app

• 
  Director▲768

  Lovable for web automation

  AI · 2025 · director.ai