Scheduled read-only watch for one local SQLite query. During the configured local-time window it runs an approval-gated SELECT against a trusted DB path, counts returned rows, renders a table, and sends an in-app notification only when rows are present. Use it for local queues such as overdue invoices, failed jobs, stale records, or other rows needing attention; for best display, alias columns as label, detail, and result.

How it works 7 steps

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

Process (7 steps)

■ query ?

■ row_count count

Count items in query stdout

■ has_rows compare

Check if row count is greater than 0

■ notify ?

skip: step.has_rows not_equal true

■ 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 7 configurable

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

source setting =

channels setting = in_app

end hour setting = 18

max rows setting = 25

weekdays setting = 1,2,3,4,5

sql query setting = SELECT name AS label, type AS detail, tbl_name AS result FROM sqlite_schema WHERE 0

start hour setting = 8