Export a query result to CSV

text

.headers on
.mode csv
.once recent_users.csv
SELECT id, email, created_at FROM users ORDER BY created_at DESC LIMIT 100;

Explanation

Good for ad hoc reporting and support workflows.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Move data in and out

Set shell parsing options before import.

Open In sheettextsame section

Export only selected table schema and data.

Open In sheettextsame section

Execute inserts and DDL from a seed script.

Open In sheetbashsame section

Create a backup from inside sqlite3.

Open In sheettext1 tag match

Write a fresh copy of the database to a new file.

Rebuild the database file and reclaim free space.