Build a lightweight migration framework using Python and SQLite that tracks applied migrations. Create a dedicated database table for migration records, execute new migrations in order, and skip already applied ones. Enhance the framework with rollback capabilities for safer schema changes in production environments.