Hi Team, Could you please help me on accessing the community forum database? We had no idea about how to access it and need to know the top viewed topics.

Is this what you are looking for? [image] Discourse Data Explorer Plugin discourse2 Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. open_book Install Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #data-reporting category under the #sql-query tag. If there’s not one to suit your par…

Thanks!! I have already tried this but it shows me to upgrade to business plan. Is there any other way for accessing database. May be through backend or any other way? [image]

I don’t believe so. You might also look at search tools that might let you sort by views.

thanks, that might help. But also want to know about the way to update the database if possible.

On the SaaS version of discourse, You don’t have access to the database or application server. All the updates are being managed by the discourse engineers. If you’d like to access (not recommended) the database directly yourself, You may consider self hosting.

If you self-host, you also have the option of installing the data explorer plugin, which in many cases is probably better than direct db access.

If you have an Internet facing host, a domain, mail servers and a whole lot of time, you can install Discourse and run it your own server: discourse/docs/INSTALL.md at main · discourse/discourse · GitHub

Database Access required for our forum

Product Support

TallTrees June 18, 2021, 9:44am 2

Is this what you are looking for?

Topic		Replies	Views
Can I access Discourse forum Database to use for PowerBI reporting? Data & reporting	4	2750	October 16, 2018
Can I access my Discourse forum database? Product Support	1	2389	May 2, 2016
External Data Analysis Product Support	2	1806	July 6, 2018
Data Explorer Queries accessible to public Feature data-explorer	10	4222	February 11, 2020
How do I extract raw data from my discourse community site? Product Support	5	2185	March 9, 2022

Database Access required for our forum

Related topics