To connect to a database:

sqlite file.db

To list all the tables in the database:

.tables

To show the structure of a table:

.schema tablename