Pilotbase

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 free

More free data tools