Lockstock

Docs / Your data and price

Export everything

One click gives you a zip of your whole workspace. Any day, no fee.

In the demo

Built. Owner only.

How

  1. Sign in as the owner and open Export.
  2. Press Export everything. It takes about a minute, and the screen shows the table it is on.
  3. Press Download zip when it is ready.

A double click, a second tab or a retry after a lost answer joins the same export instead of making another.

What is in the zip

FileWhat it holds
csv/<table>.csvOne file per table, header row first, UTF-8, comma separated, every row your workspace owns. Empty cells are NULL.
lockstock.sqlThe same rows as INSERT statements in one transaction. Data only: make the tables from the schema notes first.
manifest.jsonThe row count of every table, checked against the database when the file was made.
README.mdSchema notes, the rules above, and what was left out and why.

The tables are read from the database's own schema when you export, so a table added later is included with no change. Cost tables are included because the owner makes the export.

What is left out

Columns that are secrets never leave the database: sealed tokens (QuickBooks, Shopify), token fingerprints and storage keys. The README lists each one that was dropped. Lockstock's own built-in unit rows, which belong to no workspace, are not exported.

Limits

  • The download link and the stored file last one hour. After that, export again for a fresh one.
  • A zip over 25 MB is refused by the demo's storage, and the job says so. The sample workspace is far under that.
  • If a table cannot be read, the export fails and names the table. Nothing partial is offered.
  • Your books stay in QuickBooks, so they are not part of the zip.

You can also reach the same job without the screen. POST /api/export starts it (JSON body with a requestId), GET /api/export returns the latest job and GET /api/export/{id}/download redirects to the signed zip link. All three need your signed-in session.