Dump only specific tables or schema
backups & data
// what it does
Narrows the dump: --tables picks tables, --schema-only skips data entirely, --wheres filters rows per table, and --output-format json/csv exports for analysis instead of SQL. Perfect for pulling one table's recent rows to reproduce a bug locally.
// shell
$ pscale database dump mydb main --tables users,orders --output ./dump$ pscale database dump mydb main --schema-only --output ./schema$ pscale database dump mydb main --tables events --wheres "created_at > '2026-01-01'" --output ./events// gotcha
--wheres applies only when --tables is set, and the clauses pair positionally with the table list — double-check the pairing before trusting a filtered dump.