DEV Community

Christian Münch
Christian Münch

Posted on

🛠️ 𝗡𝗲𝘄 𝗶𝗻 𝗻𝟵𝟴-𝗺𝗮𝗴𝗲𝗿𝘂𝗻𝟮: 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝗶𝗻𝗴 𝗱𝗯:𝗰𝗼𝗺𝗽𝗮𝘁𝗶𝗯𝗶𝗹𝗶𝘁𝘆!

Planning database migrations or version upgrades in Magento/Mage-OS setups often means cross-referencing compatibility matrices, release notes, and EOL calendars. To make this frictionless, I’m currently wrapping up a major addition to n98-magerun2: PR #2158 introduces the read-only db:compatibility command.

What it does: 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.

Key technical highlights:

• Dedicated Mage-OS Detection: Detects Mage-OS as its own first-class product with its own versioning (e.g., 3.0.0), rather than silently treating it as plain upstream Magento.
• Schema-Validated & Live-Enriched: Backed by a versioned dataset generated from magento.watch (no hand-authored guesswork). Running with --online fetches real-time updates directly.
• MariaDB Lifecycle Data: Enriches status, support type, and EOL dates on the fly via the MariaDB Foundation REST API—kept strictly separate from the compatibility verdict.
• Automation & CI Friendly: Clean standard CLI output by default, verbose (-v) breakdown with full citations/lifecycle tables, and comprehensive --format=json export.
• Robust Pipeline: Bundled dataset validation via JSON Schema in build.sh, complete with atomic refresh logic and agent maintenance skills (.agents/skills/).

Feedback and reviews from the community are very welcome! Check out the pull request:
🔗 https://github.com/netz98/n98-magerun2/pull/2158

Magento #AdobeCommerce #MageOS #MySQL #MariaDB #PHP #OpenSource #DevOps #WebDevelopment #Database

Top comments (0)