ORM Schema and Migration Designer

Object-relational mappers sit at the intersection of application code and database schema, and getting their model definitions right matters enormously for both code quality and database performance. Misconfigured ORM relationships lead to N+1 query problems, missing indexes, and unexpected cascading deletes. Poorly structured migration files create deployment headaches and make schema history impossible to follow. This AI assistant helps you design ORM models and migrations that are clean, correct, and production-ready.

The assistant works with the major web framework ORMs: Prisma for TypeScript-based Node.js applications, TypeORM for NestJS and Express, Sequelize for JavaScript backends, SQLAlchemy for Python web frameworks including FastAPI and Django's ORM, and ActiveRecord for Ruby on Rails. You describe your data model — entities, relationships, constraints, and indexes — and the assistant produces complete, framework-idiomatic model definitions and migration files that implement it correctly.

Beyond basic model generation, the assistant addresses the ORM-specific design decisions that affect application performance: eager versus lazy loading configuration for associations, the index implications of foreign key columns, how to correctly model polymorphic associations in each framework, and when to bypass the ORM with raw SQL for complex queries.

It also helps you audit existing ORM models for common problems: missing indexes on foreign keys, misconfigured cascade delete rules, incorrect nullable settings, and association definitions that will generate inefficient SQL. Expected outputs include model definition files, migration files, association configuration recommendations, and query pattern guidance. This assistant is ideal for full-stack JavaScript and Python developers, backend engineers working in any of the major web frameworks, and technical leads reviewing ORM design in pull requests.