Dev tools · alternatives · 2026
24 alternatives to Nasty, a cross-warehouse, type-checked, unit-testable analytics library
Hey HN - our team wants to open source a project called NASTY (NASTY Abstract Syntax Tree thingY) that we built for ourselves. NASTY was built to maintain testable/composable data pipelines. Our team was ripping our hair out trying to maintain dbt/SQL scripts across different data warehouses (Redshift, BigQuery, Postgres, Snowflake) on top of ever shifting data foundations maintained by our customer's internal data teams. NASTY is the result of our learnings from field experience. We wanted to write abstractions so that we could reuse code. We wanted to bundle those abstractions…
Nasty is a cross-warehouse analytics library that enables testable and composable data pipelines across multiple databases including Redshift, BigQuery, Postgres, and Snowflake. It provides type checking and static… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Nasty, a cross-warehouse, type-checked, unit-testable analytics library launched in 2024; newer entries below may have overtaken it.
- 1
Hi HN, I'm Hugo. I've been building Rocky over the past month, shipping fast in the open. The binary is on GitHub Releases, `dagster-rocky` on PyPI, and the VS Code extension on the Marketplace. I held off on a broader announcement until the trust-system surface was coherent enough to talk about as one thing. The governance waveplan — column classification, per-env masking, 8-field audit trail on every run, `rocky compliance` rollup, role-graph reconciliation, retention policies — landed end-to-end last week in engine-v1.16.0 and rounded out in v1.17.4 (tagged 2026-04-26). That's the…
Apr 2026 · github.com · its alternatives →
- 2
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 →
- 3
A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql
2020 · github.com · its alternatives →
- 4HA
Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…
2024 · hashquery.dev · its alternatives →
- 5
Hey HN, we want to share HelixDB (https://github.com/HelixDB/helix-db/), a project a college friend and I are working on. It’s a new database that natively intertwines graph and vector types, without sacrificing performance. It’s written in Rust and our initial focus is on supporting RAG. Here’s a video runthrough: https://screen.studio/share/szgQu3yq. Why a hybrid? Vector databases are useful for similarity queries, while graph databases are useful for relationship queries. Each stores data in a way that’s best for its main type of query (e.g.…
2025 · github.com · its alternatives →
- 6
- 7
A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
2019 · github.com · its alternatives →
- 8
WhatTheDuck is an in-browser sql tool to analyze csv files that uses duckdb-wasm under the hood. Please provide feedback/issues/pull requests.
2024 · github.com · its alternatives →
- 9
I created a web page to compare different analytical databases (both self-managed and services, open-source and proprietary) on a realistic dataset. It contains 20+ databases, each with installation and data loading scripts. And they can be compared to each other on a set of 43 queries, by data load time or by storage size. There are switches to select different types of databases for comparison - for example, only MySQL compatible or PostgreSQL compatible. If you play with the switches, many interesting details will be uncovered. Full description:…
2022 · benchmark.clickhouse.com · its alternatives →
- 10CD
Hi HN! This is a little site I put together while learning the Elm language as part of a hackathon at my work, I thought you might enjoy it. Be sure to click the `(source)` buttons next to the graphs: you can edit them interactively & write your own queries against the entire data set. The syntax isn't well documented yet, but you can probably get the general idea pretty quickly based on the examples there. If you like it, have questions, etc. let me know! If folks think this is cool, maybe I can get it turned into a legit project. :)
2022 · codestat.dev · its alternatives →
- 11
Types generator for your Bun.sql queries. Contribute to ilbertt/bun-sqlgen development by creating an account on GitHub.
Jun 2026 · github.com · its alternatives →
- 12
Enterprise-Grade OSS PostgreSQL Distribution with HA, PITR, IaC, Monitor, 12 kernel forks and 575 PG extensions. Best-of-breed products integrated as a platform. Self-host Postgres like a Pro! - pgsty/pigsty
2023 · github.com · its alternatives →
- 13AT
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 →
- 14DD
Gleb, Alex, Erez and Simon here – we are building an open-source tool for comparing data within and across databases at any scale. The repo is at https://github.com/datafold/data-diff, and our home page is https://datafold.com/. As a company, Datafold builds tools for data engineers to automate the most tedious and error-prone tasks falling through the cracks of the modern data stack, such as data testing and lineage. We launched two years ago with a tool for regression-testing changes to ETL code…
2022 · its alternatives →
- 15
Code Bits▲90Helpful code snippets for data processing and analysis
2018 · interviewqs.com · its alternatives →
- 16
Hello HN! My name is Paras and I am building this project called Slashbase. It's an open-source collaborative IDE for databases in browser. Connect to your database, browse data, run a bunch of queries or share queries within your team, right from your browser. Works with two types of databases: PostgreSQL and MongoDB. It's written in Golang and Nextjs React Framework and runs as a single binary. Features: - Cloud based: Setup on your server. Works in browser. - Easy to use: with minimal interface it is simple to use. - Collaborative: Works with your teams. Easy sharing queries within team.…
2022 · github.com · its alternatives →
- 17KA
The most powerful type-safe SQL query builder for TypeScript
2023 · kysely.dev · its alternatives →
- 18
A simple utility for running exhaustiveness checks on Go "sum types." - BurntSushi/go-sumtype
2017 · github.com · its alternatives →
- 19OO
Hi! One of the creators here. Very proud to finally be able to show you what we've been working on for over a year now. Curious to hear your thoughts! Objectiv is open-source (APLv2) product analytics infrastructure. It's built around a generic but strict event taxonomy, open/common data- and infra tools (currently PG, snowplow, working on bigquery with more to come), and the analyses are done using our pandas-like, SQL speaking modeling library called Bach. As a result, we’re moving towards a vision wherein models can be shared openly, independent of product, platform[1] or data…
2022 · objectiv.io · its alternatives →
- 20SC
2019 · conroy.org · its alternatives →
- 21
Hey, For those of you who don't know my little tool Musoq, I wanted to introduce it as a small tool that allows you to query with SQL-like syntax without any database. It allows you to query various things from niche ones like CAN DBC files, weird ones like C# code, interesting ones with Git querying to regular stuff like CSV, TSV and various others. I am quite a bit experimenting with various things so I'm hybridizing the engine with LLMs or doing other weird stuff that are more or less practical :-) I wanted also to share some recent developments in this little project as I hope it might…
2024 · github.com · its alternatives →
- 22
Simon(sfarshid) and I spend a lot of time on GitHub. As data nerds we put together a quick tool to explore your repository’s data. How it works: - Data Loading: We use dlt to pull data (issues, PRs, commits, stars) from GitHub - Semantic Layer: Relta wraps the underlying dataset into a semantic layer so the LLM doesn’t hallucinate. - Text-to-SQL: A text-to-SQL agent transforms your plain-English question into a query using the semantic layer - Generative Charts: assistant-ui dynamically generates a chart based on the SQL query - Refinements: If the semantic layer can’t handle your question,…
2024 · github.com · its alternatives →
- 23
We built Gonzo to make log analysis faster and friendlier in the terminal. Think of it like k9s for logs — a TUI that can ingest JSON, text, or OpenTelemetry (OTLP) logs, highlight and boil up patterns, and even run AI models locally or via API to summarize logs. We’re still iterating, so ideas and contributions are welcome!
2025 · github.com · its alternatives →
- 24
Easy postgres codebase injection - aka postgres non data live reload - oelmekki/pgrebase
2016 · github.com · its alternatives →
Also compare
- Rocky – Rust SQL engine with branches, replay, column lineage alternatives
- DrawDB – open-source online database diagram editor (a retro) alternatives
- A SQL database implemented purely in TypeScript type annotations alternatives
- Hashquery, a Python library for defining reusable analysis alternatives
- HelixDB – Open-source vector-graph database for AI applications (Rust) alternatives
- Outerbase alternatives
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 →