ORM Code Generator Skill for PostgreSQL and SQLAlchemy
Generate ORM definitions from an existing schema and verify column types, foreign keys, and defaults in a disposable database.
中文Install in Claude Code
Use your PostgreSQL test schema, a pinned SQLAlchemy version, and synthetic DDL.
- Get the complete `plugins/database/orm-code-generator/skills/generating-orm-code` directory from the pinned GitHub commit.
- Copy it into the target project's `.claude/skills/`. Check `.claude/skills/generating-orm-code/SKILL.md`, start Claude Code at the project root, and call `/generating-orm-code`.
Example task
Define a BigInteger project ID, a tasks.project_id foreign key, and a JSONB metadata_json value. Generate both SQLAlchemy models, add one task locally, and load it through its project.What to check
The query returns the expected relation and JSONB payload. The model preserves the original BigInteger, key, and nullability settings.
Original SKILL.md on GitHub · Updated
Frequently asked question
Can every PostgreSQL bigint become a plain ORM Integer?
Choose a type that preserves the database column range, checking existing data and the project's driver conventions.