data_quality
Audit SQLite tables with sampled SQL to find mostly NULL columns, mixed storage types, duplicate key values, dangling foreign keys, and inconsistent date formats.
Instructions
Look for data problems, using SQL over a sample of each table: columns that are mostly or always NULL (and NULL versus empty-string mixes); columns holding mixed storage types (SQLite does not enforce column types; the typeof() distribution is reported, with examples); key-like columns (id, email, uuid, ...) that contain duplicates, case/space-only duplicates, and rows identical in every non-key column; dangling foreign keys even though SQLite does not enforce them by default; and date-looking text columns whose formats are inconsistent.
table: check just this table (default: all ordinary tables). sample: rows to examine per table (100-200000).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| table | No | ||
| sample | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |