KitForma field notes

Read SQLite integrity and foreign-key findings correctly

Distinguish structural validity from relational and snapshot completeness.

Integrity is one part of the review

SQLite integrity_check examines the database structure and related consistency rules. This tool requires an ok result before presenting ordinary tables for export. A failure stops processing; the interface does not guess missing pages or claim to repair damaged data. Work on a copy and use a dedicated recovery process when the original is corrupt.

A structurally valid file can still be an incomplete snapshot of a live application. A missing WAL, an outdated backup or a copy taken at the wrong moment can omit expected changes. The workbench cannot know which business transactions should have been present. Compare known records and acquisition details in addition to the technical check.

Foreign keys answer another question

The foreign_key_check output identifies references that violate declared constraints in the supplied snapshot. This can occur when an application disabled enforcement or imported inconsistent data. The report retains the relevant table, row identifier and constraint references, without automatically deleting or filling anything.

A database with no foreign-key violations is not necessarily logically correct. Relationships may be implemented only in application code, and a declared constraint may not express every business rule. Treat the result as evidence about declared SQLite relationships. Investigate a flagged record in the source application before deciding what correction is appropriate.

Work within explicit local bounds

Files, tables, rows, columns and decoded values have visible limits to keep the browser usable. A worker timeout stops a query or export that takes too long. Large databases should be reduced through a trusted SQLite backup or query process before inspection, with the reduction documented. The tool does not silently present a truncated export as a complete one.

Virtual-table data, encryption, attached databases and WAL merging need different handling and are outside this product. Views and triggers are retained as schema text but are not used as user-provided queries. These boundaries make the local read-only workflow understandable: inspect ordinary tables, compare their exact typed records and export selected evidence while leaving the originals untouched.

The evidence behind the check

Sources & assumptions

Formats, algorithms and supported features are documented below. Check the stated scope and inspect your output before using it.

Reviewed 2026-10-19. Read our methodology or report an issue.

Essential local storage remembers this choice for up to 180 days. Your choice applies to this subdomain. Global Privacy Control and Do Not Track override optional measurement.

Advertising has a separate choice. Use Advertising preferences in the footer to allow or reject the optional guide-page banner.