General plugins (Local): Moodle Adminer
local_adminer
Maintained by 
Andreas Grabs
Andreas GrabsThis plugin is based on the great tool adminer.
The main advantage of this plugin is, it can handle different types of database. So it works with MySQL, PostgreSQL, Oracle and MSSQL.
1558 sites
728 downloads
52 fans
This plugin is based on the great tool adminer.
The main advantage of this plugin is, it can handle different types of database. So it works with MySQL, PostgreSQL, Oracle and MSSQL.
Here are some of the key-features:
1) you can define trigger
2) you can change the order of fields
3) you can easy create or alter views
4) you can create stored procedures
5) if you rename a database so the database is altered and not copied like phpMyAdmin it does
6) you can define foreign key with referential integrity
To install it you only have to copy it into the "local" folder in your moodle-installation and running the notification-page.
After the installation you will find a new link "Moodle Adminer" below "Site administration -> Server".
Useful links
Screenshots
Contributors
Please login to view contributors details and/or to contact them
Thanks for adminer; for my I prefer it to tools like MySQL workbench for my limited needs to interact with the database directly.
I've just come across an issue where adminer showed a blank page when launched. Debugging showed that run_adminer.php could access adminer.php. Our anti virus solution had decided that adminer.php was a 'hacking tool' and quarantined it. I suspect it interpreted the name as 'ad miner'. Just in case someone else has this issue.
Christoph
Adminer is a really great and useful tool!
Do you plan to make it officially compatible with Moodle 3.0 and 3.1, so that it can be installed/upgraded via the build in installer?
I am sorry for the long running. I am very buisy and I wanted the plugin compatible with php7. So it is now.
Best regards
Thank you
Best regards
What DBMS do you use, what error appears a.s.o.
Any update to Moodle 3.4?
Ricardo