AddThisFeature

AI Data Cleanup Suggestions

Surface inconsistent or suspicious records and propose corrections a human approves.

involved AI Safety & Trust

What it adds

A review queue of proposed data corrections, each showing the original value, the reason, and an approval step.

What your agent is told to do

5
  1. 1

    Identify the fields where dirty data actually hurts: names, addresses, phone numbers, currencies, categories, and any field used for matching or reporting. Scope the first pass to those rather than scanning every column.

  2. 2

    Run deterministic checks first — casing, whitespace, duplicate punctuation, known formats, values outside an allowed set — and only send the residue to the model. Do not spend model tokens on problems a rule already solves.

  3. 3

    Separate formatting cleanup from semantic correction and present them as two kinds of suggestion. Trimming a stray space and changing a country from one value to another carry very different risk and deserve different approval thresholds.

  4. 4

    Write every suggestion to a review queue with the original value, the proposed value, the reason, and a confidence. Do not mutate source records directly, and do not auto-apply anything except rules an operator has explicitly promoted to automatic.

  5. 5

    This brief owns data already stored in the app. Rows failing validation during an upload belong to AI Import Error Repair, and header-to-field matching belongs to AI Import Column Mapping; reuse their approval surface rather than building a second one.

Edge cases it handles

8
  • Nothing may overwrite a source record without a review step or an operator-authored rule. An unattended cleanup pass that guesses wrong is worse than the dirt it removed.
  • Formatting cleanup and semantic correction must stay distinguishable in the queue, because a reviewer will approve a hundred whitespace fixes in a batch and must not sweep a changed value through with them.
  • Each suggestion must show the original value alongside the proposal and state the reason plainly, or reviewers approve on trust and stop reading.
  • Values that appear frequently in already-dirty data are not thereby correct. Validate proposals against the app's own reference data and allowed values, not against the majority pattern in the same dirty table.
  • Applying a batch twice must produce the same result as applying it once, and every applied change must be recorded with who approved it and be reversible.
  • Records edited by a user after a suggestion was generated must be re-checked before the fix lands, or approval silently reverts someone's work.
  • Field values may be personal data. Send the minimum needed to judge the value, exclude fields the reviewer has no permission to see, and never send an entire record when one column is under review.
  • When the model is unavailable or returns malformed structured output, keep the deterministic suggestions flowing and mark the semantic pass as unavailable rather than emptying the queue.

Definition of done

9
  • Suggestions appear in a review queue and no source record changes without approval or an explicit operator rule.
  • Formatting and semantic suggestions are labelled distinctly and can be filtered and approved separately.
  • Every suggestion displays the original value, the proposed value, and a stated reason.
  • Applying the same batch twice changes nothing the second time, and every applied change is recorded and reversible.
  • Deterministic checks run before the model and the model only sees what rules could not resolve.
  • A record modified since its suggestion was generated is re-checked before the change is applied.
  • Model unavailability leaves the rule-based suggestions working.
  • The feature matches the existing design system.
  • No existing functionality is broken.

Related features

How it works

  1. 1

    Copy the link

    Grab the Markdown instruction URL for this feature.

  2. 2

    Give it to your AI

    Paste it into Claude Code, Cursor, v0, Lovable — whatever you build with.

  3. 3

    It inspects, then implements

    Your agent reads your existing app first, then adds the feature to fit it.

Works with your stack

These instructions are written to adapt. They tell the agent to detect your framework, match your existing design system, and reuse what you already have — rather than assuming a particular stack.

Need it tighter than that? Customize the feature and tell it exactly what you're running.