Axiom Sqlitedata Migration

What it does

This skill enables AI agents to execute data migration tasks specifically within SQLite databases. It facilitates the movement and transformation of data between different database states or structures while maintaining integrity.

When to use it

• Migrating legacy SQLite data into a new application schema during an upgrade.
• Transforming raw datasets before loading them into an analytics pipeline.
• Moving data from one SQLite file to another with modified column definitions.
• Cleaning and restructuring historical records stored in local database files.

Key capabilities

• Executes migration scripts tailored for SQLite environments.
• Handles structural changes during data transfer operations.
• Supports automated workflows for database versioning updates.

Example prompts

• "Migrate all user records from the old users_v1 table to the new profiles schema in my local SQLite file."
• "Transform the raw transaction logs in this database into a normalized format before saving."
• "Run a data migration script to update the address fields in my customer database to include country codes."

Tips & gotchas

Ensure your source and target schemas are compatible with SQLite constraints before initiating migrations. Always back up your database files prior to running any transformation or movement operations to prevent data loss.