Database
Magento database management — MySQL optimization, schema design, declarative schema, and database migrations.
-
https://github.com/jellesiderius/mage-db-sync
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.
88107 Apr 2026
-
https://github.com/furan917/Magento2-ReadWriteSplit
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.
2928 Oct 2025
-
https://m-docs.bonlineco.com/
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.
02 Sep 2025
-
https://jigarkarangiya.com/reset-stuck-message-queue-magento-2/
This guide details how to reset a message queue that becomes stuck due to issues like crashes or deadlocks. It provides necessary SQL queries and tips for safely backing up your database before performing a potentially destructive operation. Understanding the causes of stuck queues and the proper steps to reset them is essential for maintaining performance.
29 Jul 2025
-
https://gist.github.com/rhoerr/a55285c9cabad6b87d592d5db7589262
These queries/views aggregate all EAV values for each entity into a JSON column (eav_int, eav_text, etc) for easier debugging. For scoped entities, any scope values will be appended as "{attribute_code}:{store_id}"="{value}".
-
https://m-docs.bonlineco.com/index.html
Mohamed Tawfik published a full Magento 2 Database Documentation portal to make life easier when dealing with complex table structures and relationships.
05 May 2025
-
https://github.com/henriquekieckbusch/sql_bin_magento
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.
15 -
https://github.com/EcomDev/mysql-to-jsonl
The mysql2jsonl tool provides an efficient way to export data from a MySQL database to JSONL (JSON Lines) files and to import data back into a database from these files. It is highly configurable and optimized for performance with concurrency and batching in mind!
229 -
https://www.rakeshjesadiya.com/use-insert-from-select-query-database-magento-with-best-practice/
You can use INSERT IGNORE INTO mysql query with the help of insertFromSelect() method in Magento 2 with use of magento best standard in your module.
