> ## 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.

[Connect or manage this source](https://app.vortexiq.ai/workbench/settings/sources) · [How connecting works](/integrations/connector-catalogue) · [Create a workflow](https://app.vortexiq.ai/workbench/flows/create?connector=sqlite)

<CardGroup cols={5}>
  <Card title="14">
    performance signals
  </Card>

  <Card title="4">
    automated checks
  </Card>

  <Card title="Build your own">
    automated fixes
  </Card>

  <Card title="Ready to build yours">
    workflows
  </Card>

  <Card title="17">
    API operations
  </Card>
</CardGroup>

<Tabs>
  <Tab title="Overview">
    ### What you can achieve

    Capabilities are grouped around merchant outcomes, not API terminology.

    <CardGroup cols={2}>
      <Card title="Run operations">
        Monitor orders, fulfilment, delivery and settlement.
      </Card>

      <Card title="Protect revenue">
        Find failures, leaks and risks before they cost sales.
      </Card>

      <Card title="Control risk and change">
        Keep tracking, access and change under governed control.
      </Card>

      <Card title="Catalogue quality">
        Identify missing, inconsistent or outdated product data.
      </Card>

      <Card title="Customer experience">
        Find storefront, speed, accessibility and journey problems.
      </Card>
    </CardGroup>

    ### From connection to verified outcome

    The controlled sequence every capability follows. Nothing changes a connected system without the approval step.

    <Steps>
      <Step title="Connect">
        Authorise the source. Scopes are shown before access is granted.
      </Step>

      <Step title="Monitor">
        Watch the signals against your own baselines, not universal defaults.
      </Step>

      <Step title="Detect">
        Run checks and gather evidence specific to your store.
      </Step>

      <Step title="Recommend">
        Explain what happened, why it matters and the proposed action.
      </Step>

      <Step title="Approve">
        You review scope, risk and reversibility before anything changes.
      </Step>

      <Step title="Execute">
        Apply through governed connector operations.
      </Step>

      <Step title="Verify">
        Confirm the intended result and keep the receipt.
      </Step>
    </Steps>

    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.
  </Tab>

  <Tab title="Monitor (14)">
    ### Monitor performance

    14 performance signals. Open an outcome to see its signals and how each one alerts. Read-only operations do not modify the connected system.

    <AccordionGroup>
      <Accordion title="Run operations (7 signals)">
        | Signal                                     | Alert behaviour    | What it tracks                                                                                                                                 |
        | ------------------------------------------ | ------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------- |
        | **Database File Size (MB)**                | Watch only         | PRAGMA page\_count × PRAGMA page\_size, in MB.                                                                                                 |
        | **Foreign-Key Violations**                 | Merchant rule      | Rows returned by PRAGMA foreign\_key\_check - orphaned child rows when foreign keys are enforced.                                              |
        | **Fragmentation (Free-Page %)**            | 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**      | Alert band 2 / 10  | Sampled hot queries whose EXPLAIN QUERY PLAN reports SCAN TABLE - a missing index. SQLite-distinctive.                                         |
        | **Large Tables With No Usable Index**      | Merchant rule      | Tables >10k rows from sqlite\_schema with no index on common WHERE / JOIN columns.                                                             |
        | **WAL File Ballooning Without Checkpoint** | Merchant rule      | Alerts for WAL File Ballooning Without Checkpoint.                                                                                             |
        | **WAL File Size (MB)**                     | Merchant rule      | WAL frame count × page\_size from PRAGMA wal\_checkpoint. SQLite-distinctive - a ballooning WAL means a reader is holding back the checkpoint. |
      </Accordion>

      <Accordion title="Protect revenue (3 signals)">
        | Signal                                                 | Alert behaviour | What it tracks                                                                                                            |
        | ------------------------------------------------------ | --------------- | ------------------------------------------------------------------------------------------------------------------------- |
        | **Integrity Check Failed (corruption detected)**       | Merchant rule   | Alerts for Integrity Check Failed (corruption detected).                                                                  |
        | **SQLite Table Rows vs Ecom Catalog Count**            | Merchant rule   | SQLite-distinctive XC - many apps cache the product / inventory catalog in a local SQLite file; row drift = sync failure. |
        | **Writer-Lock Contention During Checkout Window (5m)** | Merchant rule   | Writer-Lock Contention During Checkout Window (5m), broken down by row.                                                   |
      </Accordion>

      <Accordion title="Control risk and change (3 signals)">
        | Signal                                        | Alert behaviour    | What it tracks                                                                                      |
        | --------------------------------------------- | ------------------ | --------------------------------------------------------------------------------------------------- |
        | **Integrity Check Status**                    | Merchant rule      | PRAGMA integrity\_check - anything other than a single 'ok' row indicates B-tree / page corruption. |
        | **Last Backup / VACUUM Snapshot (hours ago)** | Alert band 24 / 72 | Most recent Online-Backup-API copy, VACUUM INTO snapshot, or filesystem snapshot timestamp.         |
        | **SQLite File Health Score**                  | Merchant rule      | Composite of integrity, fragmentation, WAL state, and index coverage.                               |
      </Accordion>

      <Accordion title="Catalogue quality (1 signals)">
        | Signal                                  | Alert behaviour | What it tracks                                                                                                |
        | --------------------------------------- | --------------- | ------------------------------------------------------------------------------------------------------------- |
        | **SQLITE\_BUSY / Lock Contention (5m)** | Merchant rule   | Count of SQLITE\_BUSY / SQLITE\_LOCKED returns on the single writer lock - a long write txn starving readers. |
      </Accordion>
    </AccordionGroup>
  </Tab>

  <Tab title="Audit (4)">
    ### 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. Open a check for the detail.

    <AccordionGroup>
      <Accordion title="Disk usage above 90%">
        **Severity** critical · **Outcome** Run operations · **Fix status** Report only

        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 slower. There is very little runway left at 90%.

        Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.

        Reference: `DB-CAP-002`
      </Accordion>

      <Accordion title="Query error rate above 1% in last 5 minutes">
        **Severity** critical · **Outcome** Run operations · **Fix status** Report only

        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 silently dropping work, and a rate this high in a 5-minute window is an active incident, not background noise.

        Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.

        Reference: `DB-ERR-001`
      </Accordion>

      <Accordion title="Last successful backup older than 72 hours">
        **Severity** high · **Outcome** Run operations · **Fix status** Report only

        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 would be unrecoverable in a real incident, not just delayed.

        Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.

        Reference: `DB-BAK-001`
      </Accordion>

      <Accordion title="p95 query latency above 200ms sustained 15m">
        **Severity** high · **Outcome** Customer experience · **Fix status** Report only

        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 database inherits that slowness directly, and a sustained p95 this high is usually already visible to customer

        Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.

        Reference: `DB-PERF-001`
      </Accordion>
    </AccordionGroup>

    #### Build your own automated fixes

    Turn any finding into an automated fix with a Vortex IQ workflow: **over 13,000 read and write operations across more than 200 connectors** are available as building blocks, with approval, verification and rollback on every change.
  </Tab>

  <Tab title="Automate">
    ### 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 **over 13,000 operations across more than 200 connectors** to automate the work in your own words.

    Changes follow your configured approval policy: the target, proposed change, affected records, risk, reversibility and verification plan are shown before execution.

    [Create a workflow](https://app.vortexiq.ai/workbench/flows/create?connector=sqlite)

    #### 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.

    <Accordion title="Browse the operations you can build with">
      | 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.
    </Accordion>
  </Tab>
</Tabs>