SQLite

sqlite3 <database-name>

#show tables
sqlite > .tables
customers
#table information
sqlite > PRAGMA table_info(customers);

sqlite > SELECT * FROM customers;