database-schema

Problem: Claude forgets schema details mid-session - wrong column names, missing fields, incorrect types. TDD catches this at runtime, but we can prevent it earlier.

If schema file doesn't exist → CREATE IT before proceeding.

| Drizzle | src/db/schema.ts or drizzle/schema.ts | Built-in TypeScript | | Prisma | prisma/schema.prisma | npx prisma generate | | Supabase | supabase/migrations/.sql + types | supabase gen types typescript | | SQLAlchemy | app/models/.py or src/models.py | Pydantic models | | TypeORM | src/entities/.ts | Decorators = types |

الوعي بالمخطط - القراءة قبل البرمجة، وإنشاء النوع، ومنع أخطاء الأعمدة المصدر: alinaqi/claude-bootstrap.