Dev tools · alternatives · 2026
24 alternatives to Columnq brings OLAP to Unix pipes
Create full-fledged APIs for slowly moving datasets without writing a single line of code. - roapi/columnq-cli at main · roapi/roapi
Columnq is a Unix command-line tool that brings OLAP (online analytical processing) capabilities to standard Unix pipes. It allows users to perform multidimensional data analysis and aggregation operations on streaming… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Columnq brings OLAP to Unix pipes launched in 2021; newer entries below may have overtaken it.
- 1
- 2
hi hn, hydra ceo here hydra is an open source, column-oriented postgres. you can set up remarkably fast aggregates on your project in minutes to query billions of rows instantly. postgres is great, but aggregates can take minutes to hours to return results on large data sets. long-running analytical queries hog database resources and degrade performance. use hydra to run much faster analytics on postgres without making code changes. data is automatically loaded into columnar format and compressed. connect to hydra with your preferred postgres client (psql, dbeaver, etc). following 4 months…
2023 · hydra-so.notion.site · its alternatives →
- 3
- 4
SnapQL is an open-source desktop app (built with Electron) that lets you query your Postgres database using natural language. It’s schema-aware, so you don’t need to copy-paste your schema or write complex SQL by hand. Everything runs locally — your OpenAI API key, your data, and your queries — so it's secure and private. Just connect your DB, describe what you want, and SnapQL writes and runs the SQL for you.
2025 · github.com · its alternatives →
- 5
Kafka-based Job Queue for Python. Contribute to joowani/kq development by creating an account on GitHub.
2016 · github.com · its alternatives →
- 6
- 7
I built a Rust-based CLI/terminal UI for inspecting Parquet files—data, metadata, and row-group-level structure—right from the terminal. If someone sent me a Parquet file, I used to open DuckDB or Polars just to see what was inside. Now I can do it with one command. Repo: https://github.com/kaushiksrini/parqeye
Nov 2025 · github.com · its alternatives →
- 8
An extensible, state-of-the-art framework for columnar compression, and the fastest FOSS columnar file format. Formerly at @spiraldb, now an Incubation Stage project at LFAI&Data, part of the Linux Foundation. - vortex-data/vortex
2024 · github.com · its alternatives →
- 9LN
2022 · lineapy.org · its alternatives →
- 10HO
hi hn, hydra ceo here hydra is an open-source extension that adds columnar tables to Postgres for efficient analytical reporting. With Hydra, you can analyze billions of rows instantly without changing code. demo video (5 min): https://youtu.be/1yzxgb0Oyrw github repo: https://github.com/hydradatabase/hydra For 1.0 GA release, aggregate queries are over *60% faster* than Hydra beta due to aggregate vectorization. Spatial indexes (gin, gist, spgist, and rum indexes) and pg_hint_plan are now enabled for performance optimization. postgres is great, but…
2023 · hydra.so · its alternatives →
- 11
simplest possible native GUI for inspecting JSON objects with jq - fiatjaf/jqview
2020 · github.com · its alternatives →
- 12TA
Data automation and visualization platform for spreadsheet users.
2022 · columns.ai · its alternatives →
- 13
Query CSVs using SQL. Contribute to jolmg/cq development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 14
- 15
SQL Runtime without any database. Contribute to Puchaczov/Musoq development by creating an account on GitHub.
2018 · github.com · its alternatives →
- 16
A general-purpose data analysis engine radically changing the way batch and stream data is processed - asavinov/bistro
2018 · github.com · its alternatives →
- 17
- 18
aiq lets you use a single CLI command to auto-label text data with a language model API & train an efficient classifier on the labels. Training and inference are super fast (both run on CPU).
2024 · github.com · its alternatives →
- 19DU
I built Duck-UI, a web-based SQL editor that runs DuckDB entirely in your browser via WebAssembly. No backend required. The Problem: Every time I needed to query csv, parquet, or even to play with SQL, I had to either: (a) spin up a Jupyter notebook (b) use the CLI (c) upload to a hosted service. Friction at every step (TOO MUCH to load a csv or even to test some sql (study)... The Solution: DuckDB's WASM runtime lets us run SQL analysis client-side. Load CSV/JSON/Parquet files from disk or URL, write SQL, get results instantly. Data stays on your machine. What It Does: SQL editor…
2025 · demo.duckui.com · its alternatives →
- 20
Easy JSON Query Processor with a Lispy syntax in Go - cube2222/jql
2020 · github.com · its alternatives →
- 21
Every data pipeline job I had to tackle required quite a few components to set up: - One tool to ingest data - Another one to transform it - If you wanted to run Python, set up an orchestrator - If you need to check the data, a data quality tool Let alone this being hard to set up and taking time, it is also pretty high-maintenance. I had to do a lot of infra work, and while this being billable hours for me I didn’t enjoy the work at all. For some parts of it, there were nice solutions like dbt, but in the end for an end-to-end workflow, it didn’t work. That’s why I decided to build an…
2024 · github.com · its alternatives →
- 22
Hey HN, Arroyo is a modern, open-source stream processing engine, that lets anyone write complex queries on event streams just by writing SQL—windowing, aggregating, and joining events with sub-second latency. Today data processing typically happens in batch data warehouses like BigQuery and Snowflake despite the fact that most of the data is coming in as streams. Data teams have to build complex orchestration systems to handle late-arriving data and job failures while trying to minimize latency. Stream processing offers an alternative approach, where the query is compiled into a streaming…
2023 · github.com · its alternatives →
- 23
Free browser-based SQL editor powered by DuckDB. Query and visualize CSV, JSON, Parquet and Arrow files locally or from remote URLs. No installation required.
2024 · sql-workbench.com · its alternatives →
- 24
2023 · openapistack.co · 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 →