> ## Documentation Index > Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt > Use this file to discover all available pages before exploring further. # SQLite on Vortex IQ > Monitor SQLite health, cost and reliability signals, and catch incidents and runaway spend early. Monitor SQLite health, cost and reliability signals, and catch incidents and runaway spend early. No changes are made without the configured approval policy. Read-only operations do not modify the connected system; schedules, access scopes, API usage and data handling remain governed by Vortex IQ controls. [Connect or manage this source](https://app.vortexiq.ai/workbench/settings/sources) · [How connecting works](/integrations/connector-catalogue) | **14** | **4** | **Build your own** | **Ready to build yours** | **17** | | ------------------- | ---------------- | ------------------ | ------------------------ | -------------- | | performance signals | automated checks | automated fixes | workflows | API operations | ## Monitor performance 14 performance signals. Signals with an alert band can raise Nerve Centre alerts; every signal supports a merchant-configured watcher. | Signal | Outcome | Alert behaviour | What it tracks | | ------------------------------------------------------ | ----------------------- | ------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------- | | **Database File Size (MB)** | Run operations | Watch only | PRAGMA page\_count × PRAGMA page\_size, in MB. | | **Fragmentation (Free-Page %)** | Run operations | Alert band 70 / 90 | PRAGMA freelist\_count / PRAGMA page\_count. SQLite-distinctive - high freelist means the file should be VACUUMed to reclaim space. | | **Hot Queries Doing Full Table SCAN** | Run operations | Alert band 2 / 10 | Sampled hot queries whose EXPLAIN QUERY PLAN reports SCAN TABLE - a missing index. SQLite-distinctive. | | **Integrity Check Failed (corruption detected)** | Protect revenue | Merchant rule | Alerts for Integrity Check Failed (corruption detected). | | **Integrity Check Status** | Control risk and change | Merchant rule | PRAGMA integrity\_check - anything other than a single 'ok' row indicates B-tree / page corruption. | | **SQLite File Health Score** | Control risk and change | Merchant rule | Composite of integrity, fragmentation, WAL state, and index coverage. | | **SQLite Table Rows vs Ecom Catalog Count** | Protect revenue | Merchant rule | SQLite-distinctive XC - many apps cache the product / inventory catalog in a local SQLite file; row drift = sync failure. | | **WAL File Ballooning Without Checkpoint** | Run operations | Merchant rule | Alerts for WAL File Ballooning Without Checkpoint. | | **WAL File Size (MB)** | Run operations | Merchant rule | WAL frame count × page\_size from PRAGMA wal\_checkpoint. SQLite-distinctive - a ballooning WAL means a reader is holding back the checkpoint. | | **Writer-Lock Contention During Checkout Window (5m)** | Protect revenue | Merchant rule | Writer-Lock Contention During Checkout Window (5m), broken down by row. | | **Foreign-Key Violations** | Run operations | Merchant rule | Rows returned by PRAGMA foreign\_key\_check - orphaned child rows when foreign keys are enforced. | | **Large Tables With No Usable Index** | Run operations | Merchant rule | Tables >10k rows from sqlite\_schema with no index on common WHERE / JOIN columns. | | **Last Backup / VACUUM Snapshot (hours ago)** | Control risk and change | Alert band 24 / 72 | Most recent Online-Backup-API copy, VACUUM INTO snapshot, or filesystem snapshot timestamp. | | **SQLITE\_BUSY / Lock Contention (5m)** | Catalogue quality | Merchant rule | Count of SQLITE\_BUSY / SQLITE\_LOCKED returns on the single writer lock - a long write txn starving readers. | ## Audit risks and opportunities A fix status appears only where the action, inputs, approval, verification and recovery controls are mapped. Candidate remediations are never executable. | Check | Severity | Outcome | Why it matters | Fix status | | ----------------------------------------------- | -------- | ------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- | | **Disk usage above 90%** | critical | Run operations | A database that runs out of disk stops accepting writes entirely, which for most stores means orders, inventory updates and customer records stop being saved, not just that the database gets | Report only | | **Query error rate above 1% in last 5 minutes** | critical | Run operations | More than 1 in 100 queries is failing right now. Depending on what those queries do, this can mean orders not saving, pages failing to load product or customer data, or background jobs silen | Report only | | **Last successful backup older than 72 hours** | high | Run operations | If something goes wrong with this database right now, the most recent point it can be restored to is over 3 days old. Every order, customer record and inventory change since that backup woul | Report only | | **p95 query latency above 200ms sustained 15m** | high | Customer experience | One in twenty queries against this database is taking over 200ms, sustained for at least 15 minutes, not a brief spike. Any storefront page, checkout step or order sync that depends on this | Report only | ### Build your own automated fixes 4 checks report findings on SQLite today. Turn any finding into an automated fix with a Vortex IQ workflow: **13,885 read and write operations across 229 connectors** are available as building blocks, with approval, verification and rollback on every change. ## Automate approved work Vortex IQ is integrated with **17 read** and **0 write** operations across dbstats, explain query plans, pragma autovacuums, pragma compileoptions, pragma foreignkeychecks, pragma freelistcounts on SQLite. Combine them with anything from the **13,885 operations across 229 connectors** to automate the work in your own words. Changes follow the merchant's configured approval policy: the target, proposed change, affected records, risk, reversibility and verification plan are shown before execution. Read-only operations do not modify the connected system. [Create a workflow](https://app.vortexiq.ai/workbench/flows/create?connector=sqlite) | Resource | Read operations | Write operations | | ----------------------- | --------------- | ---------------- | | dbstats | 1 | 0 | | explain query plans | 1 | 0 | | pragma autovacuums | 1 | 0 | | pragma compileoptions | 1 | 0 | | pragma foreignkeychecks | 1 | 0 | | pragma freelistcounts | 1 | 0 | | pragma integritychecks | 1 | 0 | | pragma journalmodes | 1 | 0 | Signed-in users see the full catalogue in the workflow builder, filtered to the sources they have connected. ### Ready to build your first SQLite workflow Pick a trigger, add the operations above as steps, and every step that changes data pauses for your approval. Monitoring and audits are live now and can start any workflow you build. *** *Generated from the connector capability graph. Counts reflect the servable registry after alias normalisation and de-duplication, and refresh automatically when the registry changes.*