litefind

litefind is a read-only search and introspection tool for SQLite database files — the tool to reach for when you would reach for rg on a directory, but the target is a .db/.sqlite/.sqlite3 file. Tables and columns replace paths and globs.

Three modes: search for a pattern across tables, list tables, and read schema/DDL. The database is opened read-only; there is no write path.

Source and docs on GitHub.