Database Navigation

Admin tools ::: tool_navdb
Maintained by Picture of Ferran Recio CalderóFerran Recio Calderó
Database Navigation (tool_navdb) is a database browsing plugin for Moodle. This plugin is designed especially for Moodle's DB structure and adds some practical tools. Some improvements are virtual foreign keys links, and contextual dropdown menus depending on the table, bookmarked table list and an interactive SQL filter editor.
Latest release:
61 sites
53 downloads
7 fans
Current versions available: 1

Database Navigation (tool_navdb) is a database browsing plugin for Moodle. This plugin is designed especially for Moodle's DB structure and adds some practical tools.

One of the main limitations of Moodle DB structure is that there are no foreign keys. With tool_navdb the first things you'll notice is that, when a DB table content is shown, some fields have hyperlinks to navigate between tables like a standard foreign key. Some examples of this kind of auto-links are:

  • userid goes to a specific entry in mdl_course table
  • courseid goes to mdl_user
  • contextid goes to mdl_context
  • instance ids in tables like mdl_course_modules and mdl_context goes directly to related table
  • etc.

The same happens with the visualisation of fields that Moodle uses in a non standard ways. The plugin add some extra information when you move a mouse over some elements. For example:

  • timestamps stored as integer instead of a proper date format show a human date
  • contextlevel shows a human readable format
  • roleid show a role shortname

Futhermore, some tables like mdl_user, mdl_course, mdl_course_modules... has a dropdown menu on every record entry with useful options for that specific row. Some examples of these are:

  • mdl_user entry: login as, view profile, delete user, go to user's mdl_role_assignments DB records...
  • mdl_course: view course, settings, delete course, go to mdl_role_assignments for this course DB records...

Screenshots

Screenshot #0
Screenshot #1
Screenshot #2

Contributors

Picture of Ferran Recio Calderó
Ferran Recio Calderó (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
Please login to post comments