nowfound

Dev tools · alternatives · 2026

24 alternatives to The TypeScript Semantic Layer for ClickHouse

I've built a type-safe semantic layer in code, for ClickHouse. If you're building analytics off ClickHouse in TypeScript, I would love your feedback. With hypequery there is no platform to adopt, no YAML sprawl. It runs where your app runs. Key features: - Define metrics once, reuse them everywhere: Declare dimensions and measures in one place and then pull from the same source of truth. - Compiles to ClickHouse SQL: No service, no proxy, no extra runtime to deploy. It's a library that generates SQL and runs where your app runs. - Multi-tenancy & Authentication ready: Cross-tenant queries…

Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes.

  1. 1

    The type-safe analytics backend for ClickHouse

    Apr 2026 · hypequery.com · its alternatives →

  2. 2

    A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql

    2020 · github.com · its alternatives →

  3. 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. 4KA

    The most powerful type-safe SQL query builder for TypeScript

    2023 · kysely.dev · its alternatives →

  5. 5

    An extremely simple and explicit ORM for TypeScript - Seb-C/kiss-orm

    2020 · github.com · its alternatives →

  6. 6

    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 →

  7. 7

    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 →

  8. 8

    Hey HN! I built Typebase, a library that gives you Convex's DX with Supabase's openness. After trying Supabase I liked how fast it is to spin up a DB and auth, but really didn't like using RLS and SQL for authorization. With Convex I loved how your server "lives" in your code, but disliked the DB model and the realtime-first defaults. With Typebase you just write TS files inside a typebase/ folder in your existing repo. You can define your DB tables inside a schema.ts file and export server functions that your frontend calls like local functions, fully typed. Auth is built in. Then one…

    Aug 2026 · typebase.io · its alternatives →

  9. 9
    chdb▲88

    Embedded SQL OLAP engine powered by ClickHouse

    2023 · clickhouse.com · its alternatives →

  10. 10
    ShapedQL▲211

    The SQL engine for search, feeds, and AI agents

    Jan 2026 · its alternatives →

  11. 11

    GraphQL APIs in TypeScript with complete e2e type safety

    2021 · uniform-graphql.whatsgood.dog · its alternatives →

  12. 12

    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 →

  13. 13MP

    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 →

  14. 14

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

    2021 · github.com · its alternatives →

  15. 15

    Build Typed GraphQL Queries in TypeScript without the code generation - acro5piano/typed-graphqlify

    2018 · github.com · its alternatives →

  16. 16

    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 →

  17. 17

    Hi HN - Peter from DBOS here with my co-founder Qian (qianl_cs) Today we want to share our TypeScript library for lightweight durable execution. We’ve been working on it since last year and recently released v2.0 with a ton of new features and major API overhaul. https://github.com/dbos-inc/dbos-transact-ts Durable execution means persisting the execution state of your program while it runs, so if it is ever interrupted or crashes, it automatically resumes from where it left off. Durable execution is useful for a lot of things: - Orchestrating long-running or…

    2025 · github.com · its alternatives →

  18. 18

    We've been building Crust (https://crustjs.com/), a TypeScript-first, Bun-native CLI framework with zero dependencies. It's been powering our core product internally for a while, and we're now open-sourcing it. The problem we kept running into: existing CLI frameworks in the JS ecosystem are either minimal arg parsers where you wire everything yourself, or heavyweight frameworks with large dependency trees and Node-era assumptions. We wanted something in between. What Crust does differently: - Full type inference from definitions — args and flags are inferred automatically. No…

    Mar 2026 · github.com · its alternatives →

  19. 19

    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 →

  20. 20

    Hey all, I just released v2.0.0 of FilterQL, a query language and TypeScript library. This version adds support for Operations, which allow you to transform the data after filtering. If you think this would be useful in a project you're working on, give it a try and let me know what you think!

    2025 · github.com · its alternatives →

  21. 21SA

    Hi HN, I’m Tullie, founder of Shaped. Previously, I was a researcher at Meta AI, worked on ranking for Instagram Reels, and was a contributor to PyTorch Lightning. We built ShapedQL because we noticed that while retrieval (finding 1,000 items) has been commoditized by vector DBs, ranking (finding the best 10 items) is still an infrastructure problem. To build a decent for you feed or a RAG system with long-term memory, you usually have to put together a vector DB (Pinecone/Milvus), a feature store (Redis), an inference service, and thousands of lines of Python to handle business logic…

    Jan 2026 · playground.shaped.ai · its alternatives →

  22. 22
    valv▲70

    Your database, safe for agents to query

    Jul 2026 · platform.valv.sh · its alternatives →

  23. 23
    SafeQL▲69

    Write SQL queries with confidence

    2022 · its alternatives →

  24. 24
    qryn▲78

    Polyglot observability for logs, metrics and traces

    2023 · gigapipe.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 →