About pivotTable
Pick group-by columns and aggregates (count, sum, mean, median, min, max, distinct) or pivot one column into many, with a total row and column and empty cells as blank or 0. Download the result as CSV, or copy the same report as SQL for PostgreSQL, MySQL, SQLite or DuckDB.
Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.
Built on open-source libraries: Arquero, Papa Parse.
From the makers
Pilotbase: one client for every database you run (PostgreSQL, MySQL, MongoDB, Redis and more), with an AI agent built in.
Get Pilotbase freeMore free data tools
sqlBeautify
Format, highlight and fix SQL as you type
sqlCompare
Diff two SQL files like git, after formatting both
downtimeAlert
We check your URL, API or stats page every 30 seconds and email you when it's down
sqlTranslate
Convert SQL between 14 dialects
explainViewer
See where a Postgres query spends its time
keysetBuilder
Keyset pagination queries from your ORDER BY