Postgres
Most of your company’s truth lives in your database: signups, trials, subscriptions, usage, churn.
The Postgres integration lets Lucien read that data (in a read‑only, analytics‑style way) so it can:
- Answer questions like a data‑savvy Chief of Staff
- Spot trends and anomalies
- Draft reports and updates grounded in what’s actually happening
This page is for non‑technical founders. If you have a technical co‑founder or team, you can share the Postgres read-only user guide with them.
What is Postgres?
If you’re not technical, you can think of Postgres as:
Postgres is one of the most popular databases for building software products. It's commonly the source of truth where your product and billing data actually live.
Your app, billing system, analytics and BI tools often read from (or write to) a Postgres database behind the scenes. Connecting Lucien to Postgres lets it work directly with that data instead of just screenshots or exports.
What the Postgres integration is for
With Postgres connected, Lucien can help you with:
1. Product & usage analytics
Examples of things you can ask:
- "How many active users did we have last week compared to the week before?"
- "Which features are used most by paying vs free users?"
- "What are the top 5 paths users take before upgrading or churning?"
2. Revenue & funnel questions
- "What’s our MRR by plan, and how has that changed over the last 3 months?"
- "Show me a breakdown of trials → activations → paid by cohort."
- "Which customer segments have the highest expansion or churn?"
3. Founder‑friendly reporting
Lucien can draft:
- Weekly product or growth updates based on live data
- Investor updates that reference real numbers, not stale screenshots
- Checklists of follow‑ups (for example: accounts that look at risk)
You’re still in control: Lucien proposes analyses and drafts; you decide what to share and what actions to take.
Read‑only by design
When you connect Postgres, you can (and should) give Lucien read‑only access. That means:
- Lucien can look at data (e.g by running
SELECTqueries). - Lucien cannot change your database (no
INSERT/UPDATE/DELETE).
These restrictions are built into Lucien as uncircumventable physical limitations. However, if you want a hard guarantee of this, we recommend creating a dedicated read‑only database user just for Lucien. There’s a separate guide for that: Create a read‑only Postgres user. If you’re not comfortable doing this yourself, ask your technical co‑founder or a trusted developer to follow that guide.
For more detail on how credentials are stored and protected, read:
- Lucien’s security posture – lucienai.io/security
Where to connect Postgres
You can connect Postgres from two places:
- Lucien app → Integrations → Postgres
- Inside specific workflows that prompt you to "Connect a database" when data is needed
The connection flow walks you through:
- Providing your connection URL (host, port, database, user, password)
- Optionally providing TLS certificates if your database requires them
- Testing the connection before saving anything
The full step‑by‑step is in Connect Postgres.
If you’re not the technical person
That’s fine – most founders aren’t setting up databases themselves.
Here’s the simplest path:
- Share these three docs with your technical co‑founder or trusted engineer:
- Postgres overview (this page)
- Connect Postgres
- Create a read‑only Postgres user
- Once they’ve created the read‑only user and confirmed the connection, test by asking Lucien questions about your product, revenue, and funnels.
If you’re ever unsure about security or access levels, defer to your technical counterpart and the Lucien security posture page.