bagit-completeness-fixity-auditSeparate BagIt structural completeness from checksum validity using bag inventory, manifests, fetch entries and full digest evidence. Use when fast validation passed, a transferred bag needs fixity review or missing payloads must be distinguished from changed bytes. Not for repairing, downloading or
dbt-model-refactor-and-docsSplit a large warehouse or dbt model into staging and intermediate models without changing its output, explain a model's upstream and downstream path from compiled SQL and lineage, and bring model and column descriptions in line with the real selected columns. Use when someone wants to decompose a l
multi-file-lab-workbook-harmonizationMerge many lab or instrument workbooks of similar but not identical layout into one table - inventory every file and sheet (header row, columns, units, date format), group files by layout variant, write a target schema with a per-variant column mapping, convert units and dates by explicit rules, rec
ocr-pdf-text-image-alignment-checkCompare a saved searchable PDF's text positions with its visible scans and approved page anchors. Use when OCR words look plausible but highlights shift, rotate or omit pages, or a sidecar is offered as proof. Not for PDF reading-order audits or redaction.
semi-structured-field-extractionTurn log lines, bench or test data and JSON documents into typed columns and a plot-ready table - inspect real samples and list every field, unit and type variation, map each source field to a column with an explicit cast and a policy for missing, string, array and wrong-type values, verify row coun
sql-migration-equivalence-checkProve that a migrated, dialect-converted, optimized or extended SQL query or table returns the same result as the original - number the statements in source and converted script, write row-count, two-way key anti-join and null-safe per-column diff queries, seed deliberate differences to show the che