schema-builder

Build well-structured Convex schemas following best practices for relationships, indexes, and validators. Single-field indexes : For simple lookups Compound indexes : For filtered queries Remove redundant : by_a_and_b usually covers by_a If converting from nested structures: Before: After: - Creating a new convex/schema.ts file - Adding tables to existing schema - Designing data model relationships - Adding or optimizing indexes - Converting nested data to relational structure - Document-Relational : Use flat documents with ID references, not deep nesting - Index Foreign Keys : Always index fields used in lookups (userId, teamId, etc.) - Limit Arrays : Only use arrays for small, bounded collections (<8192 items) - Type Safety : Use strict validators with v.* types - Single-field indexes : For simple lookups - by_user: ["userId"] - by_email: ["email"] - Compound indexes : For filtered queries - by_user_and_status: ["userId", "status"] - by_team_and_created: ["teamId", "createdAt"] - Remove redundant : by_a_and_b usually covers by_a