sqlite3 /path/sqlitefile ‘.databases’
sqlite3 /path/sqlitefile ‘.tables’
sqlite3 /path/sqlitefile ‘.schema table’ //for column names
sqlite3 /path/sqlitefile “select x,y from tablename where x like ‘%value%’’’
https://gitlab.com/Screwtapello/sqlite-schema-diagram