Does this skill handle timestamps automatically?

Yes, using the t.timestamps() method automatically creates createdAt, updatedAt, and deletedAt columns, providing full support for Wheels' soft-delete features.

Where should I store my migration files in a CFWheels project?

Migrations must be stored in the 'app/migrator/migrations/' directory. Placing them in 'db/migrate/' or other locations will prevent Wheels from finding and executing them.

Can I use database-specific functions like NOW()?

No, to maintain cross-database compatibility, you should use CFML date functions (like Now()) and format them using the TIMESTAMP pattern provided by this skill.

How do I apply migrations after they are generated?

After the migration file is created, you must reload Wheels by accessing your application URL with the reload parameters, typically: ?reload=true&password=[your-password].

Why should I avoid string booleans in migration files?

Using string booleans like 'true' instead of actual boolean values (true) can cause silent failures in the CFWheels migrator where tables appear to create successfully but lack primary keys.

Wheels Migration Generator

Name: Wheels Migration Generator
Author: Microck

byMicrock

•

データベース管理

Generates database-agnostic schema migrations for CFWheels applications to ensure cross-database compatibility and consistent deployment.

The Wheels Migration Generator is a specialized tool for CFWheels developers that automates the creation of database-agnostic migrations for creating tables, altering schemas, and managing seed data. It enforces critical best practices such as correct file placement in the 'app/migrator/migrations/' directory and prevents common pitfalls like database-specific SQL functions or duplicate timestamp columns. By automatically correcting common CLI generator bugs—such as the string-boolean parameter error—this skill ensures that your database changes are reliable, transactional, and portable across various database engines.

主な機能

0181 GitHub stars

02Cross-database safe date formatting for data seeding and migrations.

03Automated fixes for CFWheels CLI string-boolean parameter bugs.

04Automatic timestamp management including soft-delete (deletedAt) support.

05Standardized transaction-wrapped migration templates with error handling.

06Database-agnostic schema generation for tables, indexes, and foreign keys.

ユースケース

01Modifying existing schema structures like adding, renaming, or removing columns.

02Performing data migrations and seeding across different environment types.

03Creating new database tables with complex relationships and constraints.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/ordinary-claude-skills wheels-migration-generator

For use in Claude.ai and ChatGPT

Download Skill