Generate ORM models from database schemas or create database schemas from models for TypeORM, Prisma, Sequelize, SQLAlchemy, and more

MIT License

Free Pricing

Installation

Open Claude Code and run this command:

/plugin install orm-code-generator@claude-code-plugins-plus

Use --global to install for all projects, or --project for current project only.

What It Does

Generate ORM models from database schemas or create database schemas from models.

Features

Database-to-code generation
Code-to-database schema generation
Relationship mapping
Migration file creation
Validation rules
Best practices enforcement

Skills (1)

generating-orm-code SKILL.md View full skill →

Execute use when you need to work with ORM code generation.

ReadWriteEditGrepGlobBash(psql:*)Bash(mysql:*)Bash(mongosh:*)

ORM Code Generator

Overview

Generate type-safe ORM model classes, migration files, and repository patterns from existing database schemas or domain specifications. Supports Prisma, TypeORM, Sequelize, SQLAlchemy, Django ORM, and Drizzle ORM.

Prerequisites

Database connection string or credentials for schema introspection
psql or mysql CLI for querying information_schema
Target ORM framework already installed in the project (prisma, typeorm, sqlalchemy, etc.)
Node.js/Python/Go runtime matching the target ORM
Existing project structure to place generated models in the correct directory

Instructions

Introspect the database schema by querying informationschema.COLUMNS, informationschema.TABLECONSTRAINTS, and informationschema.KEYCOLUMNUSAGE to extract all tables, columns, data types, nullable flags, defaults, primary keys, foreign keys, and unique constraints.

For PostgreSQL, additionally query pgcatalog.pgtype for custom enum types and pgcatalog.pgindex for index definitions. For MySQL, query information_schema.STATISTICS for index details.

Map database column types to ORM field types:

varchar/text -> String / @Column('text')
integer/bigint -> Int / @Column('int')
boolean -> Boolean / @Column('boolean')
timestamp/datetime -> DateTime / @Column('timestamp')
jsonb/json -> Json / @Column('jsonb')
uuid -> String with @default(uuid()) or uuid.uuid4
Custom enums -> Generate enum type definitions

Generate model classes with proper decorators/attributes:

For Prisma: Generate schema.prisma with model blocks, @id, @unique, @relation, and @default directives.
For TypeORM: Generate entity classes with @Entity(), @Column(), @PrimaryGeneratedColumn(), @ManyToOne(), @OneToMany() decorators.
For SQLAlchemy: Generate model classes extending Base with Column(), ForeignKey(), relationship(), and tablename.
For Drizzle: Generate table definitions with pgTable(), serial(), varchar(), timestamp(), and re



      
      
          How It Works
          The ORM agent activates automatically when you discuss ORM models, database schemas, or model generation.
        

      
      
          Use Cases
          "Generate TypeORM entities for a blog with users, posts, and comments"
        

      
      

      
      
  Ready to use orm-code-generator?
  
    
    
  




      
      
          Related Plugins
          
            
                data-seeder-generator
                Generate realistic test data and database seed scripts for development and testing environments
              
                data-validation-engine
                Database plugin for data-validation-engine
              
                database-archival-system
                Database plugin for database-archival-system
              
                database-audit-logger
                Database plugin for database-audit-logger
              
                database-backup-automator
                Automate database backups with scheduling, compression, encryption, and restore procedures
              
                database-cache-layer
                Database plugin for database-cache-layer
              
          
        

      
      
          Tags
          
            ormmodelscode-generationdatabasebackend