New in n98-magerun2: Introducing db:compatibility

Description and use

Automated compatibility checks between Magento and MariaDB/MySQL simplify migrations and upgrades.

Problem

Database migrations or version upgrades in Magento/Mage-OS setups require checking compatibility between Magento releases and MySQL/MariaDB engines, which is tedious and error‑prone.

Outcome

Automated, accurate compatibility checks reduce migration risk, save developer time, and enable CI integration.

Workflow

• 1. Install or update n98-magerun2 to include PR #2158.
• 2. Run n98-magerun2 db:compatibility to check the current Magento installation against the local MySQL/MariaDB engine.
• 3. Optionally add --online to fetch the latest compatibility data from magento.watch and MariaDB Foundation APIs.
• 4. Review the CLI output or export results with --format=json for CI pipelines.
• 5. Use the detailed verbose output (-v) for troubleshooting or documentation.
• 6. Integrate the command into migration scripts or CI workflows to enforce compatibility checks before proceeding.

Evidence

PR #2158 introduces the read-only db:compatibility command.

Source

It automatically checks whether your installed (or target) Magento Open Source, Adobe Commerce, or Mage-OS release is officially supported on your current MySQL or MariaDB engine.