Dry

Don't Repeat Yourself

Find and eliminate duplication across your codebase. Every duplicate is a future bug — when you fix something in one place but forget the copy, users hit the unfixed version.

This skill audits and refactors. For building features, use build. For general performance optimization, use optimize. For database schema design from scratch, use database. For UI component selection, use ui-patterns.

Two Modes

Choose quick scan after implementing features, adding new pages, or building new API endpoints. Choose deep audit when the codebase has grown through many rounds of AI-assisted iteration, or quarterly as hygiene.

---

Quick Scan Workflow

Run this after building or modifying a feature.

Quick DRY scan:
- [ ] Identify what was just built or changed
- [ ] Search for similar patterns in existing codebase
- [ ] Flag any duplication with specific file locations
- [ ] Refactor: extract shared code, reuse existing components
- [ ] Verify nothing broke after refactoring

Process

1. Identify the change — What files were just created or modified? 2. Search for siblings — For each new component, function, or query: does something similar already exist? 3. Decide: reuse or extract — If a near-duplicate exists, reuse it. If two things are now similar, extract a shared version. 4. Refactor — Make the change, run build and tests.

What to Search For

• New component created → search for components with similar props, layout, or purpose
• New utility function → search for functions with similar signatures or logic
• New API endpoint → search for endpoints with similar query patterns or response shapes
• New database query → search for queries hitting the same tables with similar conditions

---

Deep Audit Workflow

Run this for comprehensive deduplication across the full codebase.

Deep DRY audit:
- [ ] Audit UI components for duplication
- [ ] Audit database schema for normalization issues
- [ ] Audit workflow logic for duplicate functions and patterns
- [ ] Generate findings with specific refactoring actions
- [ ] Apply fixes domain by domain, testing after each

See AUDIT-CHECKLIST.md for detailed search patterns and refactoring recipes per domain.

---

Domain 1: UI Components

What to Find

• Near-duplicate components — Two card components, two modal wrappers, two form layouts with slight differences
• Repeated inline styles — Same padding, colors, or layout CSS copied across components instead of using shared tokens or classes
• Same-purpose components — UserList and MemberList that do essentially the same thing with different prop names
• Reimplemented patterns — Custom dropdown when the component library already has one

How to Fix

1. Identical components → Delete one, update imports to point to the survivor 2. Near-duplicates → Extract a shared component with props for the differences 3. Repeated styles → Extract into shared CSS classes, design tokens, or a utility class 4. Reimplemented patterns → Replace with the component library version

AI-Tool-Specific Patterns

Tell AI (for other tools):

Search my codebase for duplicate UI components:
- Find components with similar JSX structure or props
- Find repeated inline styles or CSS classes
- Find components that render the same kind of data differently
For each duplicate: show both versions side-by-side and propose a single shared component.

---

Domain 2: Database Schema

What to Find

• Denormalized data — User's email stored in both users table and orders table instead of joining
• Missing foreign keys — IDs stored as plain integers/strings without proper references
• Repeated column groups — created_at, updated_at, created_by defined inconsistently across tables
• Enum values in columns — Status strings like 'active', 'inactive' repeated instead of using a lookup table
• Duplicate lookup data — Category names stored as strings in every row instead of referencing a categories table

How to Fix

1. Denormalized data → Remove the duplicate column, add a JOIN where needed 2. Missing foreign keys → Add proper FK constraints with ON DELETE behavior 3. Repeated column groups → Standardize naming and types across all tables 4. String enums → Create a lookup table or use a database enum type (for values that won't change) 5. Duplicate lookup data → Extract into a reference table, replace with foreign key

Red Flags in AI-Generated Schemas

AI tools often create self-contained tables per feature. Watch for:

• A projects table with owner_name and owner_email instead of owner_id referencing users
• An invoices table with customer_name, customer_email, customer_address instead of customer_id
• Multiple tables with their own status VARCHAR column using the same string values

Tell AI (for other tools):

Audit my database schema for normalization issues:
- Find columns that store data already available in another table
- Find ID columns without foreign key constraints
- Find string columns that should be lookup tables
- Find inconsistent column naming across tables
For each: explain the problem and write the migration to fix it.

---

Domain 3: Workflow Logic

What to Find

• Duplicate utility functions — Two formatDate() functions in different files
• Repeated API patterns — Same fetch-try-catch-error-handle boilerplate across endpoints
• Copy-pasted validation — Email validation logic in signup, settings, and invite flows
• Duplicate business logic — Price calculation in checkout, invoice generation, and dashboard
• Repeated data transforms — Same array mapping/filtering logic in multiple components

How to Fix

1. Duplicate utilities → Keep one, move to a shared utils/ or lib/ directory, update all imports 2. API boilerplate → Extract a shared API client or wrapper function 3. Repeated validation → Create a shared validation module (e.g., lib/validators.ts) 4. Business logic → Extract into a service or domain module (e.g., lib/pricing.ts) 5. Data transforms → Extract into named functions near the data type they operate on

Search Strategy

Find duplicate logic:
1. Search for functions with identical or near-identical bodies
2. Search for repeated import patterns (same 3+ imports in multiple files)
3. Search for similar try/catch blocks around API calls
4. Search for the same regex or validation pattern in multiple files
5. Search for string literals used in more than 2 files (often config that should be a constant)

Tell AI (for other tools):

Audit my codebase for duplicate workflow logic:
- Find functions with similar names or identical logic in different files
- Find repeated error handling patterns
- Find validation logic that appears in more than one place
- Find business calculations done in more than one place
For each: show all locations and propose a single shared implementation.

---

What NOT to Deduplicate

Not all duplication is bad. Don't over-abstract.

Rule of three: If something appears in 3+ places, extract it. If it's only in 2 places, wait until the third occurrence to confirm it's a real pattern, not coincidence.

---

Common Mistakes

---

Success Looks Like

After a DRY audit, you should see:

• Each UI component exists once with clear props for variation
• Database tables reference each other via foreign keys instead of duplicating data
• Shared logic lives in clearly named modules under lib/ or utils/
• No function body is copy-pasted across files
• New features can reuse existing components and utilities instead of recreating them

---

Related Skills

• optimize — Performance and cleanup (speed, dependencies, dead code)
• database — Schema design, RLS, migrations, query patterns
• ui-patterns — Component selection, state matrix, page composition
• build — Feature development workflow and AI tool prompting
• debug — When deduplication breaks something

Deep Audit Checklist

Structured checklist for the deep DRY audit mode. Work through each domain in order, applying fixes and running tests between domains.

---

UI Components Audit

Search Patterns

# Find components with similar names
Search for files matching: *Card*, *Modal*, *Form*, *List*, *Table*, *Button*, *Badge*, *Dialog*
Group by suffix — multiple files with the same suffix are candidates.

# Find repeated JSX structure
Search for similar HTML/JSX patterns across component files:
- Same div nesting with similar class names
- Same map() rendering patterns
- Same conditional rendering blocks

# Find repeated inline styles
Search for identical style objects, className strings, or Tailwind class combinations
that appear in 3+ components.

# Find reimplemented library components
Check if custom components duplicate functionality from the project's component library
(shadcn/ui, Radix, MUI, etc.).

Refactoring Actions

After UI Fixes

• Run build to catch import errors
• Visual check: do pages still look correct?
• Run any component tests

---

Database Schema Audit

Search Patterns

-- Find potential denormalization: columns that duplicate data from related tables
-- Look for columns like user_name, user_email, customer_name on non-user tables

-- Find missing foreign keys
-- Look for columns ending in _id that lack FK constraints

-- Find repeated string values that should be lookup tables
-- Run: SELECT DISTINCT status FROM [table] for all tables with status/type/category columns
-- If the same set of values appears across tables, it's a candidate for a shared enum or lookup

-- Find inconsistent naming
-- Compare column names across tables: created_at vs createdAt vs date_created

Refactoring Actions

After Database Fixes

• Run all migrations on a test database first
• Verify application queries still work
• Check that RLS policies still apply correctly

---

Workflow Logic Audit

Search Patterns

# Find duplicate function names
Search for function/const declarations with identical names across different files.

# Find similar function bodies
Search for functions with:
- Same parameters (even if named differently)
- Same return type
- Similar logic patterns (map/filter/reduce chains, try/catch blocks)

# Find repeated imports
Search for files that import the same 3+ packages — they likely contain similar logic.

# Find repeated string literals
Search for string literals (URLs, error messages, status values) used in 3+ files.

# Find repeated validation patterns
Search for regex patterns, .test() calls, and validation functions.

# Find repeated API call patterns
Search for fetch/axios calls with similar URL patterns, headers, or error handling.

Refactoring Actions

After Logic Fixes

• Run build to catch import errors
• Run all tests
• Manually test the affected features

---

Reporting

After completing all three domains, summarize findings:

DRY Audit Results:

UI Components:
- [N] duplicates found, [N] fixed
- Key changes: [list extracted/consolidated components]

Database Schema:
- [N] normalization issues found, [N] fixed
- Key changes: [list migrations applied]

Workflow Logic:
- [N] duplicates found, [N] fixed
- Key changes: [list extracted modules]

Remaining items (deferred — rule of three not met):
- [list items with only 2 occurrences, monitored for future extraction]