Metabase and Baserow

[alex-a-soto]

Hi Cloudron team,

I'm interested in using Metabase and Baserow together. From what I understand, Baserow uses PostgreSQL, and PostgreSQL is one of the official data sources supported by Metabase.

Could it be possible to connect both of these applications in Cloudron?

Thank you for your time and support.

Regards,
Alex

[girish]

@alex-a-soto Yes, if they are on the same server, you can put Baserow's postgres credentials into metabase. Just go into Baserow's Web Terminal and run env | grep POSTGRESQL to get the db connection credentials of Baserow. Put that into Metabase connection as described in https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.html

[JLX89]

@alex-a-soto Building on what @girish mentioned, I've actually already done this. I logged into my Cloudron Server via SSH and ran the following:

docker inspect {BASEROW_APP_ID} | grep CLOUDRON_POSTGRESQL

Note: Change {BASEROW_APP_ID} to the ID of your app

Metabase Settings > Databases >

• Database type: PostgreSQL
• Display Name: Baserow
• Host: postgresql
• Port: 5432
• Database Name: (Output from docker command)
• Database Username: (Output from docker command)
• Database Password: (Output from docker command)
• Schemas: All
• Save Changes

Working between Baserow and Metabase, it's pretty cool you can embed live data (Charts, Graphs) into other applications to give a visual view on data!