How to use SQL to query discourse database

AI-generated summary

Stackfish is seeking guidance on how to run SQL queries against the Discourse database, specifically to find users who participated in a poll. They ask if there’s an ad-hoc query interface available or where they can execute such queries. simon responds by recommending the Data Explorer plugin, which allows users to write and run SQL queries directly against their forum’s database.

This is a follow on question to one I had about finding who took part in a poll. I was told that I could get this with SQL query, but I’m not clear on how or where I can run this query.

Is there an adhoc query screen in discourse? If not, can someone point me in right direction as to where I can run SQL again discourses database.

Thanks

You can now use the Discourse Data Explorer to write SQL queries to your forum’s database.