How to Run a One‑Shot SQLite Query from the Linux Command Line and Exit Instantly

In Linux, you often need to query a SQLite database with sqlite3 and have the program exit immediately after the query, which is useful for scripts and automation.

Prepare Test Environment

First create a sample table employees with columns id, name, position, hire_date, then insert a test row for “John Doe”.

CREATE TABLE employees (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    position TEXT NOT NULL,
    hire_date DATE NOT NULL
);
INSERT INTO employees (name, position, hire_date) VALUES ('John Doe','Software Engineer','2024-03-25');

Pass SQL Query via Command Line

The simplest way is to supply the SQL statement as an argument to sqlite3:

sqlite3 /opt/sqlite.db "select * from employees;"

This connects to /opt/sqlite.db, runs the query, prints the result and exits without entering the interactive shell.

Use -cmd Option with .quit Command

You can combine the -cmd flag with the SQLite meta‑command .quit to run a query and then terminate:

sqlite3 -cmd "select * from employees;" /opt/sqlite.db .quit

Use echo or printf with Pipe

Alternatively, pipe the SQL text from echo or printf into sqlite3:

echo "select * from employees;" | sqlite3 /opt/sqlite.db
printf "select * from employees;" | sqlite3 /opt/sqlite.db

Conclusion

Passing the SQL directly on the command line is the most concise method for quick queries; if issues arise, verify the sqlite3 version and environment configuration.