Lucien AI logoLucien AI
Postgres

Connect Postgres

This guide walks you through the connection flow shown in the Lucien app – in non-technical language. If you're a non-technical founder or exec, you should feel right at home.

If you’re not comfortable touching database details yourself, you can hand this page to your technical co‑founder or a trusted engineer. The key idea is simple: Lucien only ever has read‑only access.

1. Find the Postgres integration in Lucien

  1. Open the Lucien app https://app.lucienai.io.
  2. Go to Integrations.
  3. Click on Postgres.
  4. Click Connect.

You’ll see a modal asking for connection details.

2. Gather your connection details

You (or your technical person) will need the following from your database provider or hosting platform:

  • Host – where your database is running (for example: db.mycompany.com or an IP address).
  • Port – usually 5432 for Postgres unless customised.
  • Database name – which database Lucien should read from.
  • Username & password – ideally a read‑only user created just for Lucien, but any "normal" Postgres user is fine as Lucien internally has physical limitations that prevent it from ever updating your database.
  • SSL / TLS settings – whether your database requires encrypted connections, and if so, certificates/keys.

Most providers can give you this as a single connection URL, which looks like this:

postgres://USERNAME:PASSWORD@HOST:PORT/DATABASE

Examples:

postgres://lucien_integration:secret-password@db.mycompany.com:5432/production

If you’re unsure where to find this, check your database dashboard (DigitalOcean, Supabase, AWS RDS, etc.) or ask your technical co‑founder or a trusted engineer on your team.

Tip: Never ask an untrusted engineer, or anyone outside your company, for help with your database. Lucien Support will never ask you for your database connection details. If anyone claiming to be from, or to represent, Lucien AI asks for sensitive information about you or your company, immediately end the conversation and report to us at team@lucienai.io.

3. Complete the connection form

In the Connect Postgres Database modal:

  1. Paste your connection URL.
  2. If your database requires client certificates:
    • Upload or paste the Client Certificate.
    • Upload or paste the Client Key.
    • Optionally provide a CA certificate if your provider gives you one.
    • Your certificates can either be uploaded as files or pasted (either as plain text or base64-encoded text). Remember to delete your local copy after as these files can be used by a hacker or bad actor to gain access to your database.

Important!!!

These details are sensitive. Treat them like you would any production secret. Lucien stores credentials securely and encrypts them at rest. For more on that, see Lucien security posture or contact support with questions.

4. Test the connection

Before you save anything, click Test Connection.

Lucien will:

  • Try to open a connection to your database.
  • Run a simple read‑only check to make sure credentials and network access are correct.

If the test succeeds, you’ll see a confirmation message and the Connect button will become active.

If the test fails, see Common connection issues below.

5. Confirm and connect

Once the test passes:

  1. Click Connect.
  2. Wait a few seconds while Lucien saves your settings.
  3. You should now see Postgres marked as Connected in the Integrations list.

From this point on, Lucien can use your database as a read‑only analytics source when answering questions and drafting updates.

Common connection issues

"Connection failed" or "could not connect to server"

  • Check that your database is reachable from the internet.
  • If you use a private network / VPN, your technical team may need to allow Lucien’s IPs (contact support at team@lucienai.io).
  • Verify the connection URL – a typo here is very common. We recommend copying directly from your database provider or secrets manager and pasting into Lucien.

"Authentication failed" or "invalid username/password"

  • Re‑enter the username and password carefully (copy/paste from your provider).
  • Confirm that the user exists and is allowed to connect from Lucien’s location.
  • If you recently changed the password, update it in Lucien and test again.

SSL / certificate errors

  • Make sure you’ve pasted the full certificate text, including the -----BEGIN / -----END lines.
  • Use the exact certificates provided by your database host (don’t re‑format them).
  • If your provider provides certificates as downloadable files, download them and upload directly to Lucien. Remember to delete your local copy after as these files can be used by a hacker or bad actor to gain access to your database.
  • If you’re unsure which fields are required, consult your provider’s Postgres connection docs.

Not sure what any of this means?

If you’re a non‑technical founder and these steps feel too low‑level:

  1. Stop here – don’t guess at database settings.
  2. Share this page with your technical co‑founder or a trusted engineer.
  3. Ask them to set up the connection for Lucien and then hand it back to you.

You should never have to compromise security or production stability to get Lucien connected.

Postgres

Connect your production database so Lucien can reason over real product and revenue data.

Create a read-only Postgres user

How to create a locked-down database user for Lucien, so it can never mutate your data.

On this page

1. Find the Postgres integration in Lucien2. Gather your connection details3. Complete the connection form4. Test the connection5. Confirm and connectCommon connection issues"Connection failed" or "could not connect to server""Authentication failed" or "invalid username/password"SSL / certificate errorsNot sure what any of this means?