When to invoke
- You received a SQLite database file and need a quick schema overview.
- You want to document a local database before migrating or integrating.
Inputs needed
--dbpath to a SQLite database.- Optional:
--tablescomma-separated list of tables (default: all user tables).
Workflow
- Open database in read-only mode.
- Discover user tables.
- For each table, capture columns/types, indexes, and foreign keys.
- Emit a JSON report.
Output format
- JSON written to
--output.
Guardrails
- Read-only: never modify the database.
- Do not infer semantics beyond the declared schema.
Reference code
sqlite_schema_report.pyuses Python stdlibsqlite3.