Run one approval-gated read-only SQL query against a trusted local SQLite database path and render the rows as a compact report. For best display, alias projected columns as label, detail, and result; the default query lists tables and views from sqlite_schema. The underlying pack operation opens the database read-only, enables sqlite3 safe mode, sets PRAGMA query_only=ON, and never talks to a remote.

How it works 5 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Process (5 steps)

■ query ?

■ row_count count

Count items in query stdout

■ rows slice

Take a subset of

■ table to_table

Format results as a data table

■ card to_summary

Format results as a summary card

Settings 3 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

source setting =

max rows setting = 25

sql query setting = SELECT name AS label, type AS detail, tbl_name AS result FROM sqlite_schema WHERE type IN ('table','view') ORDER BY name