This plugin allows admins to run SQL queries against the live Discourse database, including parameterized queries and formatting for several common column types.
Follow our Install a Plugin
howto, using git clone https://github.com/discourse/discourse-data-explorer.git
as the plugin command.
Once you've installed it, turn on the data_explorer_enabled site setting, go to /admin/plugins/explorer, and start querying.
TODO - screenshots of interface, etc
MIT