Skip to content
Recued
Menu
← Back to packs

SQLite3 Read-Only Pack

by recued-core v1 app_pack

V3 guarded local SQLite read capability pack. By-value connector composition (service_kind=cli, no separate ingredient): one local sqlite3 CLI ingredient exposes bounded operations for readiness, schema inspection, table/object inventory, file/page stats, attached database listing, integrity checks, quick checks, foreign-key violation counts, and read-only SQL reports. Bundles a manual read-only query report and a scheduled query-result watch so users can turn local app/business SQLite files into dashboards and alerts. Database operations use sqlite3 safe mode, read-only open mode, JSON output, and PRAGMA query_only=ON; approval is ask because schema, health, and query output can reveal local database contents and arbitrary SELECT text can still be expensive. Requires sqlite3 on PATH (Debian/Ubuntu: apt install sqlite3; macOS: sqlite3 is commonly installed with system tools). Local and no-egress.

What this pack installs

Trust & control

What installing this whole pack would let it do. Recued grants these permissions at install — review them there before approving.

Where it runs

Device + server Runs on your device (browser) or your server.

What it's allowed to do

Read Local CLI sqlite3 read-only
Read: sqlite3.version · No approvalRead: db.inspect_schema · Asks approvalRead: db.table_list · Asks approvalRead: db.file_stats · Asks approvalRead: db.database_list · Asks approvalRead: db.integrity_check · Asks approvalRead: db.quick_check · Asks approvalRead: db.foreign_key_violation_count · Asks approvalRead: db.query_readonly · Asks approval

Data it touches

SurfacesLocal CLI

About

Tags

pack:sqlite3sqlite3clisqlitedatabaseschematablesintegrityforeign-keyshealthqueryreportwatchschedulereadonlyjsondeterministiclocal-servicev3composition