Your SQL workspace for CSVs and databases

Join and compare data from CSV files and databases like Postgres, ClickHouse, and Snowflake, right on your machine.

Download for Mac Free and open source · Your data stays on your machine
Superintendent's workspace: a SQL query joining the Album and Artist tables, with results in a grid

Stop writing throwaway scripts to compare data

Every migration, backfill, or "why don't these numbers match?" ticket starts the same way: export from one system, load into another, write a one-off script to diff them. It's tedious work that wears you down. Hours disappear, and the script gets thrown away until next time.

You shouldn't need to build a mini pipeline just to check whether two tables agree.

Check whether two systems agree, in minutes

Join data across sources

Pull query results from CSVs and databases like Postgres, ClickHouse, and Snowflake into one workspace, then join them with plain SQL. No ETL, no staging tables.

Inspect and edit every row

Scroll through millions of rows, spot the bad value, and fix it right in the grid. No LIMIT 100, no UPDATE scripts.

Save your workspace

Keep your validation queries and rerun them after every migration or backfill. Repeat checks take seconds.

Your data stays on your machine

Queries run locally, so your production data and customer exports never get uploaded to a cloud service. It's fast, too: millions of rows, no round-trips, no warehouse bill.

Tanin Na Nakorn

So I built the tool I wished I had.

I built Superintendent because I lived this problem. I used to export CSVs from Stripe, millions of rows of them, and reconcile them against our internal database. Spreadsheets choked on large files, scripts only showed me summaries, and stitching everything together took hours I didn't have.

So I built the tool I wished I had: a local SQL workspace that pulls from any source, with no pipeline to set up. And I made sure you can scroll through millions of rows and inspect every value, so you see exactly what's in your data instead of guessing.

Tanin
Former Stripe Engineer

Get started in seconds

No login. No credit card. Open source and free.

  1. 1
    A fresh, empty Superintendent workspace right after opening the app

    Open app

    Download the app, install it, and open it. That's all the setup there is.

  2. 2
    The Add database dialog listing PostgreSQL, SQLite, and other databases

    Import CSVs or database

    Drop in your CSV files, or connect to your databases and other data sources.

  3. 3
    A SQL query joining two tables, with the results shown in a grid

    Work on your data

    Join your sources with SQL, scroll through every row, and fix bad values right in the grid.

What people are saying

Superintendent is used by thousands of people to work with their data every day.

ProductHunt
on Twitter
Write SQL on a CSV file. Never would have thought CSVs would be so versitle. producthunt.com/posts/superintendent-app
mrkledal
on Twitter
This cool tool allows you to use SQL to search and manipulate your CSV files. superintendent.app
SandeepDinesh
on Twitter
I use superintendent.app (made by @tanin) basically let's you run SQL on raw CSVs
ats
on Twitter
superintendentは,読ませたCSVファイルをSQL使ってコネコネできるアプリ。SQL知ってる人は便利だと思う superintendent.app
macarthy
on Twitter
Thai dev @tanin just launched an app on Product hunt producthunt.com/posts/superintendent-app Super useful for people that have to deal with CSVs
mike_bianco
on Twitter
Neat tool: write SQL that runs over CSV files and results in a CSV output. Like OpenRefine, but more modern with standard SQL. Yes, SQLite can probably do this fairly easily, but I'm a sucker for single-purpose tools that make a particular workflow clean. superintendent.app
DannyProl
on Twitter
¿Una aplicación o producto ha mejorado considerablemente tu trabajo del día a día? Empiezo yo: superintendent.app
gvenk
on Twitter
Handige tool! Superintendent, SQL-tool voor CSV bestanden superintendent.app
LukebAbell
on Twitter
Cool app to query CSV’s with SQL! superintendent.app
NINTSKARI
on Reddit
In my last job I was forced to use VBA with Excel for some large automation tasks. Coming from Python Pandas and SQL background, it was... bad. This looks very cool!
bad-coder-man
on Reddit
WOW, I used to work somewhere where someone wrote a similar app but it was more java syntax. This is incredible.
Wind_Lizard
on Reddit
I was looking for such software few weeks ago. Thanks. Really helpful.
ZackyZack
on Reddit
I don't work with data analysis anymore, but jfc the potential for this thing is awesome. Well done, mate!

Questions

Does my data leave my machine?

No. Superintendent pulls query results from your databases and CSV files into a local workspace and runs your SQL there. Nothing is uploaded to us or to any cloud service, and there's no account to sign up for.

Do edits in the grid change my database?

Yes, but only when you ask. You edit one cell at a time and confirm each change, and Superintendent writes it back to the table. That only works on tables with a primary key, so every edit hits exactly one row. Query results are read-only. Editing an imported CSV changes the copy in your workspace, not the original file.

Why not just use a Python script or the data warehouse?

You can, but a script is code you write, debug, and throw away for every check, and it usually shows you a summary rather than the rows. The warehouse means staging tables, permissions, and compute costs for a one-off question. Superintendent is plain SQL over all your sources, with a grid you can scroll through, and you can save the workspace to rerun the same checks after the next migration or backfill.

Is it really free?

Yes. Superintendent is free and open source, and the code is on GitHub.

Find out why the numbers don't match

Free and open source