NocoDB and Metabase on my Cloudron instance

luisegundo

Thanks for your previous reply and for sending the documentation link.
I read the full guide you mentioned (https://docs.cloudron.io/guides/connect-postgresql/) and also checked the Metabase documentation for PostgreSQL connections.

However, I still cannot identify where exactly Cloudron exposes the PostgreSQL addon credentials for NocoDB. The UI layout on my server does not look like the one shown in the guide, and no credentials or addon entries appear under the app settings.

Since you mentioned that NocoDB does not use SQLite on Cloudron, I want to follow the official and supported path, but I need your help to understand the correct steps.

Could you please provide a clear step‑by‑step explanation of the process below?

Where exactly do I find the PostgreSQL addon credentials for the NocoDB app in the current Cloudron UI?
If the addon must be enabled manually, what is the exact procedure to enable it?
Once I have the credentials, what is the correct sequence to connect Metabase to the NocoDB PostgreSQL database?
If NocoDB requires a re‑installation to activate PostgreSQL, can you confirm that and describe the correct way to perform it?
I want to make sure I am following the supported method, and since I did not find the steps in the documentation, I would appreciate a detailed walkthrough.

Thank you very much.

luisegundo

Hello Cloudron Support,

I opened this forum topic and I am still waiting for an official response before moving forward with the deployment:

https://forum.cloudron.io/topic/14708/nocodb-and-metabase-on-my-cloudron-instance/8?_=1765639092991

We are Cloudron Pro customers and this question is blocking the continuation of our setup.

What we need is a step‑by‑step explanation on how to view or enable the PostgreSQL addon credentials for the NocoDB app in the current Cloudron UI, because the interface shown in the documentation does not match the interface we see.

We read the documentation you shared: https://docs.cloudron.io/guides/connect-postgresql/

However, we were not able to find where the PostgreSQL addon credentials appear for NocoDB, nor how to enable them if they are not visible. We do not want to make any configuration attempts without official guidance.

Our request:
We need Cloudron to explain exactly:

Where in the current Cloudron interface the PostgreSQL addon for NocoDB appears.
If it needs to be enabled manually, how to do that.
Whether NocoDB requires reinstallation in order for the PostgreSQL addon to be activated.
The correct procedure to connect Metabase to NocoDB’s PostgreSQL after retrieving the credentials.
Steps to Reproduce
Fresh Cloudron Pro installation.
Install NocoDB app normally.
Open the app's settings (Resources, Storage, etc.).
No PostgreSQL addon is shown anywhere in the interface.
Logs
No relevant error logs appear, because the issue is not an error — the database credentials are simply not visible anywhere in the UI.

Troubleshooting Already Performed
Verified all app tabs: Info, Resources, Storage, Access Control, Security, etc.
Compared interface with Cloudron documentation.
Reinstalled NocoDB once to test UI changes (no effect).
Asked in the forum and read the suggested documentation.
Did not attempt any manual modifications or unsupported actions.

System Details
Cloudron Version
YourVersion: (paste your Cloudron version here)

Ubuntu Version
YourDetails: (paste your Ubuntu version here)

Cloudron Installation Method
Cloud Image on Vultr (adjust if needed)

james

Hello @luisegundo

To get the PostgreSQL credentials of the nocodb app open the web terminal of the nocodb app:

In this terminal copy and paste the following command and press enter:

printenv | grep -i POSTGRESQL

You will get an output like this:

CLOUDRON_POSTGRESQL_URL=postgres://user876d5ae64c9d44a4979aafbfffb68286:25025a6a57810a29ae4a052a416291bda191d339b63f129e42a512e07ba0b8f36fe6fccddbf3f1c15fd607d6d81d84ab9a1fee67547ff498890405a594d1bdd6@postgresql/db876d5ae64c9d44a4979aafbfffb68286
CLOUDRON_POSTGRESQL_DATABASE=db876d5ae64c9d44a4979aafbfffb68286
CLOUDRON_POSTGRESQL_PASSWORD=25025a6a57810a29ae4a052a416291bda191d339b63f129e42a512e07ba0b8f36fe6fccddbf3f1c15fd607d6d81d84ab9a1fee67547ff498890405a594d1bdd6
CLOUDRON_POSTGRESQL_USERNAME=user876d5ae64c9d44a4979aafbfffb68286
CLOUDRON_POSTGRESQL_HOST=postgresql
CLOUDRON_POSTGRESQL_PORT=5432

Copy and save this output somewhere, you will need it later.

Now in the metabase web UI I can add a database with the previous credentials.
Tip, use the CLOUDRON_POSTGRESQL_URL and put in the Connection string (optional) field in Metabase and give it a descriptive display name instead of the long generated string db876d5ae64c9d44a4979aafbfffb68286:

Now I can access the NocoDB PostgreSQL database in Metabase:

Is this what you needed?

luisegundo

Hello Cloudron Support,

I need assistance with an internal app-to-app database connection.

Context:
We are using NocoDB and Metabase on Cloudron Pro.
NocoDB is working correctly with the internal PostgreSQL addon (confirmed through Web Terminal using printenv | grep POSTGRESQL).
Metabase was freshly reinstalled and is working normally.

Problem:
We cannot establish a connection from Metabase to NocoDB’s PostgreSQL database.

Metabase shows this error:
“No pg_hba.conf entry for host 172.x.x.x”

The Cloudron documentation says that apps can access another app’s PostgreSQL addon via the hostname “postgresql”, and that the addon credentials can be used directly in other apps.

We followed the guide:
https://docs.cloudron.io/guides/connect-postgresql/

We retrieved the credentials inside NocoDB:

CLOUDRON_POSTGRESQL_URL
CLOUDRON_POSTGRESQL_DATABASE
CLOUDRON_POSTGRESQL_USERNAME
CLOUDRON_POSTGRESQL_PASSWORD
CLOUDRON_POSTGRESQL_HOST (postgresql)
CLOUDRON_POSTGRESQL_PORT (5432)

These credentials work inside NocoDB itself, but Metabase cannot connect using them.
It looks like the Metabase container is not allowed to access the NocoDB PostgreSQL addon.

Issue:
We are unable to locate any “Access Control”, “Network Policy”, or “Database addon permissions” screen in the current Cloudron UI for the NocoDB app.
Without these options, we cannot confirm whether Metabase is allowed to reach the internal PostgreSQL service of NocoDB.

What we need clarified:

Where exactly, in the current Cloudron UI, can we allow Metabase to access NocoDB’s PostgreSQL addon?
(or confirm if this access is automatically allowed)
Does Cloudron require any explicit permission or network configuration for one app (Metabase) to connect to another app’s PostgreSQL addon?
Is the “postgresql” hostname the correct one for inter-app communication in this scenario?
If additional configuration is required, could you provide the exact step-by-step instructions?

This is blocking our setup, and we would appreciate detailed guidance.

Thank you.

james

Hello @luisegundo

Have you seen my previous answer? Just want to make sure it was not overlooked.
https://forum.cloudron.io/post/116969

@luisegundo said in NocoDB and Metabase on my Cloudron instance:

Where exactly, in the current Cloudron UI, can we allow Metabase to access NocoDB’s PostgreSQL addon?
(or confirm if this access is automatically allowed)

There is no such feature in the Dashboard to check this.
Network accessibility between apps is default and should work.

@luisegundo said in NocoDB and Metabase on my Cloudron instance:

Does Cloudron require any explicit permission or network configuration for one app (Metabase) to connect to another app’s PostgreSQL addon?

No.

@luisegundo said in NocoDB and Metabase on my Cloudron instance:

Is the “postgresql” hostname the correct one for inter-app communication in this scenario?

Yes.

@luisegundo said in NocoDB and Metabase on my Cloudron instance:

If additional configuration is required, could you provide the exact step-by-step instructions?

See https://forum.cloudron.io/post/116969

luisegundo

Hello @james, thanks for your reply.

Yes, I saw your previous message and I’ve read the referenced post.
However, the issue is still happening even after following all steps exactly as described.

Key points:

You said that inter‑app network access is automatic and always allowed.
You confirmed that no permissions or UI settings are required.
You confirmed that the hostname "postgresql" is correct.

Given all of that, Metabase is still unable to connect to NocoDB’s internal PostgreSQL addon, and keeps returning:

“No pg_hba.conf entry for host 172.x.x.x”

This indicates that:

Metabase is NOT using the hostname “postgresql”
Metabase is instead falling back to an internal Docker IP (172.x.x.x)
The connection is being rejected at the PostgreSQL level

To help us properly debug this, could you clarify:

Why would Metabase try to connect using a 172.x.x.x container IP if “postgresql” is always resolvable between apps?
Is there a way to verify inside each container that the hostname “postgresql” resolves correctly (for example, via ping, nslookup, or another command)?
Is there any scenario where the hostname “postgresql” would NOT resolve automatically?
Is there a way to confirm that both apps are on the same internal Cloudron network?
Could you provide the exact expected behavior when an app tries to use the environment variables of another app’s addon?

We are simply trying to connect Metabase → NocoDB PostgreSQL using the internal addon credentials.
NocoDB works with these credentials, but Metabase refuses the same connection.

We would appreciate a more detailed explanation so we can proceed.

james

Hello @luisegundo

@luisegundo said in NocoDB and Metabase on my Cloudron instance:

Why would Metabase try to connect using a 172.x.x.x container IP if “postgresql” is always resolvable between apps?

By default, the Cloudron internal PostgreSQL Service container with hostname postgresql resolves to the IP address 172.18.30.2.
If Metabase resolves the hostname postgresql to 172.18.30.2 that is correct.

@luisegundo said in NocoDB and Metabase on my Cloudron instance:

Is there a way to verify inside each container that the hostname “postgresql” resolves correctly (for example, via ping, nslookup, or another command)?

Yes, if you open the Web Terminal of an app, you can verify this with either nslookup or dig.

Example from a Cloudron server with just 1x LAMP app and from inside that LAMP apps Web Terminal

root@fbbbe700-24f0-4832-89e8-487e633c35d3:/app/code# nslookup postgresql
Server:         127.0.0.11
Address:        127.0.0.11#53

Non-authoritative answer:
Name:   postgresql
Address: 172.18.30.2
Name:   postgresql
Address: fd00:c107:d509::f

root@fbbbe700-24f0-4832-89e8-487e633c35d3:/app/code# dig postgresql

; <<>> DiG 9.18.30-0ubuntu0.24.04.2-Ubuntu <<>> postgresql
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 26454
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;postgresql.                    IN      A

;; ANSWER SECTION:
postgresql.             600     IN      A       172.18.30.2

;; Query time: 2 msec
;; SERVER: 127.0.0.11#53(127.0.0.11) (UDP)
;; WHEN: Wed Dec 17 19:17:33 UTC 2025
;; MSG SIZE  rcvd: 54

@luisegundo said in NocoDB and Metabase on my Cloudron instance:

Is there a way to confirm that both apps are on the same internal Cloudron network?

If the Metabase app is resolving postgresql to 172.18.30.2 then it is in the same network.

@luisegundo said in NocoDB and Metabase on my Cloudron instance:

We are simply trying to connect Metabase → NocoDB PostgreSQL using the internal addon credentials.

I just want to make sure we are speaking about the same thing here.
Since in my previous post, the Metabase UI states Add a database and you are writing about using the internal addon credentials.
You are trying to add the NocoDB Database inside Metabase with the Add a database, correct?

If you feel like this is going nowhere, please enable Remote Support and write an email to support@cloudron.io and reference this topic in your email.

luisegundo

I need to link the NocoDB database to Metabase, but I need the following information: Database name
Username
Password
Host
Port

How can I get this information?

james

Hello @luisegundo
Please stop creating new topics with the same content, thanks.

Can you please explain what exactly is not working from the provided information in this topic?

luisegundo

This post is deleted!

luisegundo

My knowledge level is beginner, and I was using AI assistance, but it's not working either.

I already asked a colleague for guidance, and he's also having trouble.

Could you tell me exactly how to obtain the following information from NocoDB?

Database name
Username
Password
Host
Port

Please provide a step-by-step guide on how to do this, considering my beginner level.

james

Hello @luisegundo
I have written a guide with screenshots, did you see that one? https://forum.cloudron.io/post/116969
Have you tried following these steps?
At which step do you run into issues?

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

Cloudron Forum

NocoDB and Metabase on my Cloudron instance