Extension:Asksql

Asksql extension allows you to do SQL queries through a special page in the wiki, without opening phpMyAdmin etc.

Dangerous if not configured properly!

Installation
This extension sets $wgAllowSysopQueries = true;, so keep that in mind. You must configure $wgDBsqluser and $wgDBsqlpassword in your LocalSettings.php though.
 * 1) Download the latest snapshot, extract the files, and place them under extensions/Asksql
 * 2) Make sure you have ExtensionFunctions.php in your extensions/ folder
 * 3) Add $wgGroupPermissions['bureaucrat']['asksql'] = true; to LocalSettings.php
 * 4) Add require_once('extensions/Asksql/Asksql.php'); to LocalSettings.php
 * 5) Go to  to test the extension out

Settings

 * $wgAllowSysopQueries Set to allow sysop queries.
 * $wgDBsqlpassword The password for $wgDBsqluser.
 * $wgDBsqluser The SQL user used for queries.