sqlite3

SQLite shell

medium risk

interactive breakdown — edit the command and press Explain

$

⚠ Risks & cautions

Copying a live DB file with cp can yield corruption — use .backup.

What it does

Interactive SQLite client. See the flags and examples below, and run `man sqlite3` for the full reference.

Examples

sqlite3 app.db ".tables"List tables · explain & risk-check →

sqlite3 app.db ".backup backup.db"Online backup · explain & risk-check →

Related

Open the full explainer →More in Databases

Reference text is hand-written and may be incomplete — check man sqlite3 for your version. Test destructive commands on a non-production system first.