Shared on Mage Dispatch · 17 Apr 2025
To execute Magento 2 CLI-like commands directly in your MySQL database without needing PHP or the Magento application layer. The result? Lightning-fast command execution and direct database insights.
Downloads and sanitizes remote databases over SSH, then imports and configures them locally to mirror production or staging in minutes. Built on Magerun2 and can optionally handle WordPress.
A Magento 2 module that implements automatic read/write database splitting. Read queries are distributed across multiple read replicas using round-robin selection, while write operations always go to the master database. CLI operations (indexing, cron, console commands) always use the master to avoid temporary table conflicts. We ensure a 'writer first' approach and include a writer fallback for defensive posturing. It is built to support multiple readers, but 1 will work just as well.
This documentation provides a comprehensive guide to the Magento 2 database structure, designed to help data analysts understand the relationships between tables and their purposes. Magento 2 uses a complex database schema with over 300 tables organized into different modules.
Mage Dispatch is a community-run archive and bi-weekly newsletter for the Magento, Adobe Commerce and Mage-OS ecosystem. Modules, articles, security advisories and tools, hand-picked by developers and shared so good work does not disappear into the void.
Browse the latest links → Explore by topic → Submit a link → About us →
