Inspect database schema and sample data

Inspect SQLite database schema and sample rows

Developers needing quick schema exploration without writing SQL or GUI tools; safe read-only introspection.

• · Optional table name to inspect (string)

• · Full schema dump (all tables if no arg)
• · Row counts per table
• · Sample rows (first 5) for named table
• · Column definitions and indexes

• · sqlite3 CLI

• · youtube_brief.sqlite file exists
• · sqlite3 installed

• · Database locked — other process holding write lock
• · File corrupted — sqlite3 reports syntax errors
• · Large table with millions of rows — LIMIT 5 protects against output overflow

• · Explicit read-only constraint (rejects INSERT/UPDATE/DELETE/DROP/ALTER)
• · Automatic row count reporting for all tables
• · Defensive LIMIT on sample queries