database
-
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.
28 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.
-
https://github.com/AquiveMedia/magento2-import-remote-db
This Magento 2 script by AquiveMedia automates importing databases from remote servers via SSH with configurable environment settings. It supports table exclusions and compression, making it ideal for efficient, tailored migrations.
