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.
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.
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.
Get started in seconds
No login. No credit card. Open source and free.
-
1
Open app
Download the app, install it, and open it. That's all the setup there is.
-
2
Import CSVs or database
Drop in your CSV files, or connect to your databases and other data sources.
-
3
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.
Show HN: Work with CSV files using SQL. For data scientists and engineers
Superintendent: Load multiple CSV files and write SQL
Superintendent.app: A desktop app for working with large CSV files using SQL. v2.0 now can load 1GB file in 20s and support regex/date parsing!
Superintendent.app: Write SQL on CSV files (Desktop app)
Write SQL on a CSV file. Never would have thought CSVs would be so versitle. producthunt.com/posts/superintendent-app
This cool tool allows you to use SQL to search and manipulate your CSV files. superintendent.app
I use superintendent.app (made by @tanin) basically let's you run SQL on raw CSVs
superintendentは,読ませたCSVファイルをSQL使ってコネコネできるアプリ。SQL知ってる人は便利だと思う superintendent.app
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
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
¿Una aplicación o producto ha mejorado considerablemente tu trabajo del día a día? Empiezo yo: superintendent.app
Handige tool! Superintendent, SQL-tool voor CSV bestanden superintendent.app
Cool app to query CSV’s with SQL! superintendent.app
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!
WOW, I used to work somewhere where someone wrote a similar app but it was more java syntax. This is incredible.
I was looking for such software few weeks ago. Thanks. Really helpful.
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.