Guide
Query a SQLite database
The SQLite command-line shell provides a direct way to inspect an existing database and run SQL queries.
At a glance
- Read statement
- SELECT
- Schema inspection
- .schema in the SQLite shell
Overview
The SQLite command-line shell provides a direct way to inspect an existing database and run SQL queries. Start by identifying its tables and schema, then write a bounded read query that selects only the fields needed for the question you are answering.
1. Open the intended file
Confirm the database file path before opening it with the sqlite3 shell. Inspect table names and schema using the shell's documented commands so the next query uses actual table and column names.
2. Write a bounded query
Select explicit columns, add a WHERE clause when filtering is needed, and use LIMIT while exploring unfamiliar data. Add ORDER BY when the order matters rather than assuming the returned rows are inherently sorted.
3. Check interpretation
Compare the result with the question and inspect unexpected nulls or duplicate rows. A query that runs successfully can still express the wrong condition, so verify a few known records or expected cases.
Sources and review
MOOR's explanatory text is supported by the following source links.
- SQLite quick start — SQLite
- SELECT syntax — SQLite