Dev tools · alternatives · 2026
24 alternatives to ScratchDB – Open-Source Snowflake on ClickHouse
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…
ScratchDB is a fully-managed data warehouse built on ClickHouse that handles the operational complexity of running OLAP databases in production. It eliminates the need for developers to manually manage batch inserts… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. ScratchDB – Open-Source Snowflake on ClickHouse launched in 2023; newer entries below may have overtaken it.
- 1
Hey there HN! We’re Joe and Stopa, and today we’re open sourcing InstantDB, a client-side database that makes it easy to build real-time and collaborative apps like Notion and Figma. Building modern apps these days involves a lot of schleps. For a basic CRUD app you need to spin up servers, wire up endpoints, integrate auth, add permissions, and then marshal data from the backend to the frontend and back again. If you want to deliver a buttery smooth user experience, you’ll need to add optimistic updates and rollbacks. We do these steps over and over for every feature we build, which can…
2024 · github.com · its alternatives →
- 2
InstantDB▲320Complete backend with auth and storage in one prompt
Apr 2026 · instantdb.com · its alternatives →
- 3
Me with my friend Vitaly Ludvichenko made an experiment to combine ClickHouse server and client to make a self-contained program running a database engine and processing data without a server: https://github.com/ClickHouse/ClickHouse/pull/150 Development continued in the past 6 years, and now clickhouse-local becomes a swiss-army knife for data processing. Say "ffmpeg" for datasets and more. It can resemble textql, octosql, dsq, duckdb, trdsql, q, datafusion-cli, spyql, but has better capabilities and performance. Here is a tutorial:…
2023 · clickhouse.com · its alternatives →
- 4
- 5
We just released a major upgrade to SigNoz with support for Logs management based on ClickHouse. Would love to get any feedback from the community here on what you think and any questions you may have for us Many big companies like Uber and Cloudflare have been shifting to ClickHouse as their main workhorse for Logs management seeing much better performance. for e.g Cloudflare recently shifted from Elastic to ClickHouse and are seeing 8x improvement in memory/cpu resource requirement in ingestion. This is our first release with Logs support and we have added support for: - Filtering…
2022 · github.com · its alternatives →
- 6AT
A bunch of developers and myself have created RepliByte - an open-source tool to seed a development database from a production database. Features: - Support data backup and restore for PostgreSQL, MySQL and MongoDB - Replace sensitive data with fake data - Works on large database (> 10GB) (read Design) - Database Subsetting: Scale down a production database to a more reasonable size - Start a local database with the prod data in a single command - On-the-fly data (de)compression (Zlib) - On-the-fly data de/encryption (AES-256) - Fully stateless (no server, no daemon) and lightweight…
2022 · its alternatives →
- 7
One year ago I open-sourced my very first 'real' project and shared it here. I was a college student in my senior year and desperately looking for a job. At the time of sharing it i couldn't even afford a domain and naively let someone buy the one i had my eyes on lol. It's been a hell of a year with this blowing up, me moving to another country, and switching 2 jobs. In a year we somehow managed to hit 26k stars, grow a 1000+ person discord community, and support 37 languages. I couldn't be more grateful for the community that helped this grow, but now i don't know what direction to take…
2025 · drawdb.app · its alternatives →
- 8EA
2019 · easydb.io · its alternatives →
- 9
Open source APM: OpenTelemetry traces, metrics, and logs - uptrace/uptrace
2021 · github.com · its alternatives →
- 10
Xata▲236xata scratch gives you a disposable copy of your Postgres from the terminal. One command forks a branch with your real data, runs your query, and deletes it.
2022 · xata.io · its alternatives →
- 11
- 12
Hey HN, I'm Marc. I run Numia, a blockchain data company serving real-time APIs at near-petabyte scale. ObsessionDB is managed ClickHouse we built for ourselves that costs roughly 50% less than other managed options. Now we're launching it as a standalone service. We had the classic split: ClickHouse for real-time analytics APIs, BigQuery for data warehouse workloads. Data replicated between both, costs adding up. Managed ClickHouse worked but was too expensive to put our warehouse workload into. Self-hosted meant replica nodes doubling storage and waiting days to copy 25TB to new replicas.…
Jan 2026 · obsessiondb.com · its alternatives →
- 13
ClickHouse is an open-source analytics DBMS for big data
2020 · clickhouse.com · its alternatives →
- 14
We have been using graph DBs more and more at work. I found them painful to work with locally and decided to try and build something better.
Aug 2026 · github.com · its alternatives →
- 15
Hi HN! We are Ashish and Armend, founders of GlassFlow. We just launched our open-source streaming ETL that deduplicates and joins Kafka streams before ingesting them to ClickHouse https://github.com/glassflow/clickhouse-etl Why we built this: Dedup with batch data is straightforward. You load the data into a temporary table. Then, find only the latest versions of the record through hashes or keys and keep them. After that, move the clean data into your main table. But have you tried this with streaming data? Users of our prev product were running real-time analytics…
2025 · github.com · its alternatives →
- 16
2020 · textdb.dev · its alternatives →
- 17
Hey hn! I'm one of the co-founders of highlight.io, an open source monitoring tool. Today we're sharing a ClickHouse-based logging solution we've been working on. We wanted to showcase how we built it and share how you could try it out to give feedback. Since we started working on highlight.io, we've been hyper-focused on "cohesion", or ensuring that when you install your monitoring stack, all of the resources in that stack (user interactions, requests, traces, logs, etc.) are connected in a consumable way. We've written up more about our philosophy on this here [1]. We started building…
2023 · github.com · its alternatives →
- 18
Hey HN, We are excited to announce that we’ve open-sourced AGX, a fast and lightweight data explorer for ClickHouse. It is designed for developers and analysts who want to leverage SQL-native querying in an IDE-like environment. Here’s what makes AGX stand out: - Built on ClickHouse (accessible via embedded chdb or remote instance). - IDE-like user interface: features tabs, a Monaco editor, and a fast keyboard workflow. - Zero setup required: no infrastructure or complex dashboards to manage. - Ideal for exploring live blockchain data, while also flexible enough for general ClickHouse usage…
2025 · github.com · its alternatives →
- 19
30x cheaper than Datadog. Predictable pricing. Exceptional customer support. 7,000+ happy customers. 60-day money back guarantee.
2021 · logtail.com · its alternatives →
- 20
While building an IoT telemetry solution, we ran into hurdles with Clickhouse. For one, you can't insert quickly AND durably into Clickhouse without setting up something like Kafka, which gets complicated for quick projects wanting to make use of Clickhouse's powerful features. Then, trying to actually query Clickhouse and show data in a UI required a whole backend API to handle auth and permissions. We figured that all these parts together – fast, durable ingest, row-level and column-level security and roles, and realtime streaming – were a lot of scaffolding to have to rebuild for every…
Aug 2026 · wavehouse.dev · its alternatives →
- 21
Hi HN, Mike and Warren here! We're excited to share some (early) work towards our next major version of HyperDX. HyperDX makes it easy to visualize/search logs & traces on top of Clickhouse (so incident & bug investigations hopefully go by a little easier). For example, if a team is thinking of migrating to Clickhouse for their observability data warehouse [1][2][3] usually due to cost or data privacy reasons, they can easily throw HyperDX on top to do the UI layer for analysis and dashboarding in a dev-friendly way (aka not needing to type paragraphs of SQL to find some logs) Over the…
2024 · github.com · its alternatives →
- 22
Hi HN, My name is JR and I had a need for a simple analytics solution that allowed me to store (timestamp, json) logs and run SQL over them. It was hard to find the right solution. Solutions like Mixpanel and Amplitude optimized for particular report types. Whereas solutions like Snowflake, BigQuery, etc. required a lot of setup. I built GraphJSON to fit in the middle. I strived for the ease of use of tools like Mixpanel and Amplitude, but wanted to ensure affordances were built to support use cases that big data warehouses enable. Under the hood, GraphJSON is powered by ClickHouse. This…
2022 · graphjson.com · its alternatives →
- 23
RipDB▲65Fast, decentralized key-value Store for web3 builders
2022 · zdenham.github.io · its alternatives →
- 24
ChunkHound’s goal is simple: local-first codebase intelligence that helps you pull deep, core-dev-level insights on demand, generate always-up-to-date docs, and scale from small repos to enterprise monorepos — while staying free + open source and provider-agnostic (VoyageAI / OpenAI / Qwen3, Anthropic / OpenAI / Gemini / Grok, and more). I’d love your feedback — and if you have, thank you for being part of the journey!
Jan 2026 · github.com · its alternatives →
Also compare
Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →