How to browse discourse database?

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 )

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.

7 Likes

PostgreSQL function

SELECT current_database()
1 Like