Group
  • Database

    Audit my schema for design mistakes that don't scale

    Reviews your full data model for the structural choices that cause pain later: god tables, missing relationships, and fields doing two jobs.

    • Plan & validate
    • Improve quality
    • Advanced
    • General

Free Prompt

Audit my entire database schema for design problems, beyond the basic user-content tables. List every table or collection, its fields, and its relationships, then review for the structural mistakes that cause pain at scale. Look for: god tables accumulating unrelated columns (a users table with 40 columns including billing state, preferences, and cached counts that belong elsewhere); fields storing two things at once (a status column mixing payment state and fulfillment state); relationships modeled as loose ID fields with no enforcement or documentation; arrays or JSON blobs being used where a real related table is the honest model (tags with their own metadata, line items with prices); and cached or computed values stored without a documented recomputation path (denormalized counts that drift when the recompute code forgets a case). For each finding, tell me the concrete problem it causes at 10x data volume or 10x features, and propose the fix as a migration plan, not a rewrite. Some findings will be acceptable trade-offs for a small app; say so explicitly rather than demanding purity. Don't change any schema in this pass. This is an audit and a plan. Deliver: the schema map, findings ranked by future pain, and the migration plan for the ones worth fixing now.

What This Does / How This Helps

Reviews your whole data model for the structural choices that are cheap now and expensive later, and turns the findings into a migration plan instead of a lecture. Schema mistakes compound. The users table grows a column per feature until every query drags 40 fields around, a status column splits into two concepts mid-project, and cached counts drift because nothing recomputes them consistently. Each is survivable alone; together they make every new feature slower to build. The audit stays pragmatic: findings get ranked by actual future pain, and acceptable small-app trade-offs get labeled as such.

Want to skip doing this by hand?

Fortivibe audits your app for all of the areas these prompts cover (and more).

See What We Check

Related Prompts