Get More Deeply Acquainted With Moodle 3.3's Data Model Using This Tool

Moodler Marcus Green has updated his “X-Rays for Moodle” tool, called Moodle ER Diagram, a comprehensive display of the Moodle database. This time, it shows the intricacies of the model that powers Moodle 3.3.

Post Pages - Post Inline - WIRIS

See our coverage on a previous version of the tool here.

Developers often need visualization tools to make sense of large-scale projects. Their importance is particularly notable when it comes to the architecture of data. Keeping tabs on the many links old and new entries have is vital to keeping data useful. While general tools allow this, Green felt a dedicated tool would benefit Moodlers. He used MySQL Workbench to reverse engineer the tables, fields, and connections. Then he simplified the user interface so less technical users could still make sense of the model.

The tool is available at Click on the drill appearing in some of the tables to open a more detailed window. Beware that some of Moodle’s data is stored under the non-relational, XML scheme.

A plain file with the full breakdown of Moodle’s data model is available here.

Visit an archive of the model for previous Moodle versions.

Check out Green’s Moodle SQL Generator plugin.

Moonami LogoThis Moodle Technology related post is made possible by: Moonami a company that provides a full range of Moodle services that combine the flexibility, scalability, and power of Amazon’s world-leading cloud platform (AWS) with fanatical Moodle support. Click here to learn more.


Previous articleLearning Outcomes From US Virtual Schools Subpar, Enrollments Higher According To NEPC
Next articleEcha un Vistazo a ‘Mootivated’, Nuevo Concepto en Ludificación para Moodle


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.