Alternatives
Products that do what The TypeScript Semantic Layer for ClickHouse does
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…
- 1
- 2OF
2020 · github.com
- 3
- 4KB
2020 · kretes.dev
- 5
- 6
- 7IW
Hi! I wanted to understand more about databases' internals so I wrote one from scratch. It has a T-SQL inspired syntax with support for functions and procedures. It can be used stand-alone as a SQL engine or with a server allowing for persistence and replication to other connected clients. Performance are nothing near sqlite of course but that's beside the point. It’s a small database engine that can run in a web app as a way to store session data, do small calculations on a web worker, store the document/data the user is editing or facilitate “multiplayer” feature by broadcasting the…
2022 · github.com
- 8FC
Hi HN, there’s a distinct lack of modern self-hosted scale-out query engines. A lot of the innovation in the last 10 years has been in SaaS-only systems. That’s also been true for Firebolt until now. We’re now taking the radical step of offering our query engine as a Docker image that’s free for commercial use without any real restrictions on what you can use it for (basically everything except competing with our SaaS offering). There are helm charts and docker compose files in the repo as well to help you get started. The focus of Firebolt is on low-latency, high-concurrency analytics like…
2025 · github.com
- 9MO
2019 · github.com
- 10TW
Built QueryWeaver, an open-source text2SQL tool that uses a graph to create a semantic layer on top of your existing databases. When you ask "show me customers who bought product X in a certain ‘REGION’ over the last Y period of time," it knows which tables to join and how. When you follow up with "just the ones from Europe," it remembers what you were talking about. Instead of feeding the model a list of tables and columns, we feed it a graph that understands what a customer is, how it connects to orders, which products belong to a campaign, and what "active user" actually means in your…
2025 · github.com
- 11DR
We’ve built SQLRooms, an open-source framework for creating single-node data analytics apps powered by DuckDB. It lets you build fully client-side, data-centric apps using React and DuckDB running in the browser (via WebAssembly) or in Electron. No server or backend is required — apps can work offline, preserve data privacy, and run queries on large datasets with sub-second performance. Features: - Query large datasets in browser with DuckDB (WASM) - Modular design for building composable data UIs (query editors, dashboards, notebooks, etc.) - Data privacy-preserving AI assistant that can…
2025 · sqlrooms.org
- 12PW
Turn any SQL code block on your website into a runnable query editor with just a tag. Powered by DuckDB WASM running entirely in the browser – no backend needed. Perfect for documentation sites, tutorials, and blog posts. Features: • Full SQL analytics engine (DuckDB) running client-side • Syntax highlighting with live editing • One-click query execution (or Ctrl+Enter) • Works with any static site – just add the CDN script • Only 23KB minified, loads DuckDB on-demand • Dark/light theme support Try it: https://widget.pondpilot.io GitHub:…
2025 · github.com
- 13CU
Hi HN, I've been building CH-UI, an open-source ClickHouse workspace. Today I'm releasing v2, which is a complete rewrite from scratch. v1 was a React SPA served via Docker. v2 is a single Go binary with an embedded Svelte frontend — download, run, open browser. No Docker, no Node, no runtime dependencies. What it does: - Multi-tab SQL editor with autocomplete - Database/table explorer with data preview - Saved queries - Tunnel architecture: run `ch-ui server` on one machine and `ch-ui connect` next to your ClickHouse — secure WebSocket tunnel, no VPN needed - Self-update (`ch-ui…
Feb 2026 · ch-ui.com
- 14L0
What's your tool chain for data and document processing? - jq is great, but limited to JSON; and jQuery limited to HTML; templating systems get messy for non-trivial logic; TypeScript lacks pattern matching and schema support. So I built Lambda — an expressive functional language that combines the power of Lisp, TypeScript, and many DSLs like jq, jQuery, RelaxNG, etc. It has a lightweight 9 MB runtime, built from scratch in C/C++, that provides an end-to-end document processing pipeline (parse → validate/query/transform → layout → render/view). Internally, Lambda parse…
Mar 2026 · github.com
- 15CU
CH-UI is an open-source web interface for managing and interacting with ClickHouse databases. Key features include an advanced SQL editor with IntelliSense, real-time data visualization, and comprehensive monitoring capabilities. Built with TypeScript and featuring IndexedDB-based caching, it's designed to handle large datasets efficiently. Available as a Docker image for quick deployment.
2025 · github.com
- 16TS
2024 · litdb.dev
- 17CA
I've been building a bunch of random side projects, as I'm sure we all are. Most analytics tools were either too heavy or required juggling multiple free tiers across different subdomains. After looking what's out there I couldn't find a lightweight analytics platform that worked on the free tier of fly.io. It's a single Go binary using DuckDB for events and SQLite for metadata, so there are no external dependencies to manage. Drop a script tag on your site and it auto-captures pageviews and clicks. The part I'm most excited about: it uses an LLM to automatically name raw click events into…
Feb 2026 · github.com
- 18DA
This demo is build with subZero [0] - The TypeScript library to build internal tools fast Everything is running in JS (express+react-admin), there are no external dependencies (other supporting services), which makes for an easy deployment (single container/service) to any platform that can run JavaScript. The demo uses SQLite as the db but PostgreSQL/MySQL/ClickHouse are also supported. [0] https://getsubzero.today/
2023 · demo.subzero.cloud
- 19TC
2020 · github.com
- 20QF
2019 · github.com
- 21TT
Hi HN, I built TypeGraph, a type-safe knowledge graph library that runs on your existing Postgres or SQLite. After years of building knowledge graphs and other graphy things, I had the same issues whenever an application’s relationship modeling (permissions, RAG context, recommendations) outgrew standard ORMs: deploy a dedicated graph database (heavy ops, separate infra, data syncing headaches), or roll a graph-in-SQL implementation by hand. I've hand-rolled enough of these to know the drill: same table structures, same traversal boilerplate, same performance surprises. I wanted graph…
Feb 2026 · typegraph.dev
- 22LQ
Hey #SQL and #js people, I'm stoked to introduce Linked QL - a “magic wand” query client for your database that simplifies how you query data and manage your schemas. If you've worked with structured data on a real world project, then chances are that you've also had a hair-pulling experience figuring out relational queries, managing schemas and coordinating dozens of migration files. You also may have had to move from a tool like Prisma to one like Drizzle in search of sanity, and then realise that this too inherits everything that makes an ORM and ORM! I am writing Linked QL to be…
2024 · github.com
- 23LO
Hey HN, I'm Karan. I built Logchef because we moved our log workloads to ClickHouse at Zerodha and found the ecosystem lacking for actual log exploration. Tools like Metabase and Grafana are great for dashboards, but log exploration is a different workflow. The Grafana ClickHouse plugin requires manual column configuration for logs, has no field sidebar, and its ad-hoc filters are slow on large tables. Grafana's RBAC is Enterprise-only, and even then it's datasource-level and not at table-level. If someone has access to the ClickHouse datasource, they can query any table. In Logchef, you…
Dec 2025 · logchef.app
- 24LO
Hey HN, I built Lytics because other offerings don't let you compare dimensions (all functionality is crammed into a SPA) and I wanted segment-able click tracking with accurate heatmaps. Lytics uses the Quarkus web framework, clickhouse for the backend, and it has a query transpiler for the reports and heatmaps. Heatmaps use a custom renderer I built, and for the best possible experience they overlay directly on your website, no iframes are used. It's open source so you can dive into the code or host it yourself. Live demo here:…
Jan 2026 · lytics.cloud
Ranked by how close each launch is in meaning, then by votes. Refine with a description →