Database
-
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.
13 -
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!
228 -
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.
