Axiom Database Migration

The axiom-database-migration skill enables AI agents to execute database schema changes directly within the Axiom platform. It facilitates the safe evolution of data structures by generating and applying migration scripts without requiring manual intervention or external tooling.

When to use it

• Updating column types or adding new fields to existing tables as application requirements grow.
• Refactoring legacy database schemas to align with modern coding standards or performance needs.
• Automating routine maintenance tasks like index creation or constraint enforcement across distributed environments.
• Ensuring consistent schema versions between development, staging, and production databases.

Key capabilities

• Direct execution of migration commands within the Axiom environment.
• Automated generation of SQL scripts for structural changes.
• Support for complex schema modifications including column additions, removals, and type alterations.
• Integration with existing Axiom workflows to streamline deployment pipelines.

Example prompts

• "Create a migration script to add an email_verified boolean column to the users table."
• "Refactor the orders table schema to include a new status_history JSONB field for audit tracking."
• "Generate and apply a migration that renames the customer_id column to account_id across all related tables."

Tips & gotchas

Ensure your Axiom instance has write permissions on the target database before initiating migrations. Always test generated scripts in a staging environment first, as schema changes can impact existing data integrity if not handled carefully.