db_overview
Summarize an SQLite database file read-only: size, encoding, journal mode, object counts, per-table row counts, and virtual tables, without modifying the file or creating WAL/SHM files.
Instructions
Start here. Summarise an SQLite database file: size, page size, text encoding, journal mode (WAL or not), user_version, counts of tables / views / indexes / triggers, and a row count for every table (from ANALYZE statistics when present, otherwise an exact count that stops at 100,000). Virtual tables (FTS5, rtree) are listed with their module and their internal shadow tables are folded away. Opening is read-only and never modifies the file or creates -wal / -shm files.
path: the .db / .sqlite file (relative paths are resolved inside the --dir folder, if one was set).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |