| Command | Description |
|---|---|
| .show | Displays current settings for various parameters |
| .databases | Provides database names and files |
| .quit | Quit sqlite3 program |
| .tables | Show current tables |
| .schema | Display schema of table |
| .header | Display or hide the output table header |
| .mode | Select mode for the output table |
| .dump | Dump database in SQL text format |
From a rails app:
$ sqlite3 db/development.sqlite3
https://www.sitepoint.com/getting-started-sqlite3-basic-commands/