How to browse discourse database?


(Majed Alhrbi) #1

Thank you for this wonderful software.
I tried to find the postgreSQL database (Name , Username, password) but I couldn’t find it anywhere.

I’m using this plugin GitHub - discourse/discourse-data-explorer: SQL Queries for admins in Discourse but still dont know what is the database name ? where can I find it ?

What is the best way to browse database tables and import/export tables?

Note: (Discourse installed through on-click install DigitalOcean )


(cpradio) #2

That plugin permits you to query it from the Admin > Plugins area. Go there and click Data Explorer Plugin, write queries to your hearts content.


(Mittineague) #3

PostgreSQL function

SELECT current_database()