Command to access your Rails sqlite3 database from the command line

Public, Databases

harrylevine

Created: Mar 28, 2015     Updated: Mar 28, 2015

$ sqlite3 db/development.sqlite3

Run .tables to get a list of database tables, to confirm you are in the right place

Then run .help for list of available commands

Reference site: https://www.sqlite.org/cli.html

1 vote