Open a database 1sqlite> .open test.db Show tables 1sqlite>.table 2n Shows that there is only 1 table named n. Check table schema 1sqlite> .schema 2CREATE TABLE n (id INTEGER PRIMARY KEY,f TEXT,l TEXT); Check contents of a table It's just the usual sql query commands as expected 1sqlite> select * from n; …

1#!/bin/bash 2sqlite3 test.db "create table n (id INTEGER PRIMARY KEY,f TEXT,l TEXT);" 3sqlite3 test.db "insert into n (f,l) values ('john','smith');" 4sqlite3 test.db "select * from n;" See stackoverflow post