SQLite CLI (Command Line Interface)

sqlite3 /path/to/your/database.sqlite

List tables

.tables

Show table definition

.schema projects

Select all from table

.headers on
.mode column
SELECT * FROM projects;

References

Title
URL