nowfound

Dev tools · alternatives · 2026

24 alternatives to ClickHouse-local – a small tool for serverless data analytics

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:…

ClickHouse-local is a standalone command-line tool for serverless data analytics that combines ClickHouse's database engine with data processing capabilities in a single executable. It runs without requiring a separate… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. ClickHouse-local – a small tool for serverless data analytics launched in 2023; newer entries below may have overtaken it.

  1. 1

    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…

    2023 · github.com · its alternatives →

  2. 2

    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 →

  3. 3

    ClickHouse is a free analytic DBMS for big data.

    2016 · clickhouse.com · its alternatives →

  4. 4

    Open source APM: OpenTelemetry traces, metrics, and logs - uptrace/uptrace

    2021 · github.com · its alternatives →

  5. 5

    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 →

  6. 6
    chdb▲88

    Embedded SQL OLAP engine powered by ClickHouse

    2023 · clickhouse.com · its alternatives →

  7. 7
  8. 8

    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 →

  9. 9

    Write SQL & analyze data with ai

    2024 · chat2db.ai · its alternatives →

  10. 10

    ClickHouse is an open-source analytics DBMS for big data

    2020 · clickhouse.com · its alternatives →

  11. 11

    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 →

  12. 12MP

    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,…

    Jan 2026 · its alternatives →

  13. 13
    Trench▲281

    Open source analytics infrastructure

    2024 · trench.dev · its alternatives →

  14. 14

    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 →

  15. 15

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

    Jun 2026 · tabstack.ai · its alternatives →

  16. 16

    Hello HN! I've found my SQL knowledge to be lacking, so I made a project that uses SQLite as a backend. As it is intended for self-hosting I aim to make it easy to set up and maintain. Getting it up & running takes no more than a few commands (bar setting up a proxy such as nginx, which is out of scope). I've set up a "demo" site at https://forum.agreper.com/ if you want to try out the UI.

    2022 · github.com · its alternatives →

  17. 17

    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 →

  18. 18CO

    Thought i'd share some recent work i'd done after being generally frustrated as to the available analytics for Python modules. Most seem to be either limited in time or incur charges to query. Code is Apache 2 at https://github.com/clickHouse/clickpy The downloads for Python modules are actually available in BigQuery - a row for every package download in the world. Last time i checked it's the largest BigQuery public dataset at almost 700b rows. Wanting to do some serious analytics led to a few frustrations though: - speed for queries - BigQuery is great for complex SQL,…

    2023 · clickpy.clickhouse.com · its alternatives →

  19. 19DA

    I built DataRamen, a local-first SQL explorer that helps you get the data you need fast, without writing repetitive queries every time. You run it locally from the CLI (no cloud version yet), connect your databases, and you're ready to go. The goal is to let you explore and query data like you would in a spreadsheet: intuitive, fast, and without friction. Key features: - Automatic joins & related data navigation: Right-click any row to instantly see related records in other tables (based on foreign keys or references). - Keyboard-driven UI: Hit N to jump to a table, F to filter, and so on,…

    2025 · dataramen.xyz · its alternatives →

  20. 20

    Easily explore local data files with DuckDB

    2025 · github.com · its alternatives →

  21. 21

    Toolkit for building serverless applications

    2019 · serverless.com · its alternatives →

  22. 22

    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 →

  23. 23

    Turn any website to API by several clicks (serverless and support SPA!) - t9tio/cloudquery

    2019 · github.com · its alternatives →

  24. 241C

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 →