Use “SQLite read-only query report” in Recued. 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 sqliteschema.

How it works 5 steps

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

Process (5 steps)

◆ query recued-core.sqlite3.db.query_readonly

Query readonly db on sqlite3

■ 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

▼

Output

summary card

table table

Settings 3 configurable

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

source setting = [object Object]

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