PostgreSQL + Orcabase
Ask your app’s database anything.
Connect the Postgres database behind your product and ask about orders, signups and customers in plain words. Orcabase reads it live, through a login that can only look, so every answer uses today’s numbers.
- Live connection
- Always current
- Read-only login
How many new customers did we get in August?
412 new customers in August, 23% more than July.
- The best month yet, and the first above 400.
- 71% of them started with the sampler box.
- Most arrived in the second half of the month.
New customers by month
How I got this· 4 steps
- Looked at your customers and orders
- Counted first paid orders by month
- Compared August with July
- Split new customers by first product
Example answer. Numbers are illustrative.
In plain words
What happens when you connect PostgreSQL to Orcabase?
Orcabase signs in to your database with a login you create for it, one that can read but never change anything. When you ask a question, the agent looks at what your app stores, works out the answer and shows it with a chart.
Nothing is copied. Every answer reads your data as it is right now, and your product keeps running as usual. Orcabase keeps only the latest result of each saved chart, so dashboards open fast.
Ask in plain words
What you can ask about your PostgreSQL data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
How many people signed up last week, and how many ordered?
Which customers haven’t ordered in 60 days?
What’s our average order value, month by month?
Which plan do new customers pick most?
How long does it take a new customer to order again?
Which products are most often bought together?
What share of revenue comes from repeat customers?
Show me orders by country for the last 90 days.
What Orcabase can read
Everything in PostgreSQL, read where it lives.
Stays in your database. Orcabase keeps only the latest result of each saved chart, so dashboards open fast.
Everything your app stores
New tables, automatically
Only what you share
Your own summaries
Numbers worth defining
Define them once. Every answer agrees.
Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your PostgreSQL data.
Revenue
Paid orders minus refunds, counted on the day each order was paid.
New customers
People whose first paid order falls in the period.
Repeat purchase rate
Share of customers who order again within 90 days of their first order.
Average order value
Revenue divided by the number of paid orders.
Active customers
Customers with at least one order in the last 30 days.
Dashboards to start with
Your PostgreSQL numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Monday numbers
4 charts- Revenue, this week vs last
- New customers by week
- Orders by product
- Repeat purchase rate
Customer health
4 charts- Active customers
- No order in 60 days
- Days to second order
- Revenue from repeat customers
Better together
Ask across PostgreSQL and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect PostgreSQL, step by step.
- 1
Create a read-only login
Run two lines on your database to make a login that can read everything and change nothing. The PostgreSQL guide has them.
- 2
Add it to Orcabase
Go to Data Sources → New data source, pick PostgreSQL, and enter the host, port, database name and the new login.
- 3
Test the connection
Click Test connection. When it says Connected, you’re ready.
- 4
Ask your first question
Open the agent and ask about last week. It finds its way around your data by itself.
What you’ll need
- Your database’s host, port and name.
- A read-only login for Orcabase. The PostgreSQL guide has the two lines that create one.
- A database that accepts connections from the internet, or an allowlist we can be added to.
- How it connects
- Live connection
- How fresh
- Live. Every answer reads your data as it is right now.
- Where your data lives
- Stays in your database. Orcabase keeps only the latest result of each saved chart, so dashboards open fast.
- Who can set it up
- Anyone in your organization.
- Your login
- A read-only login you create for Orcabase. Its password is encrypted and never shown again.
- Cost
- Included on every plan.
Which Postgres hosts work with Orcabase?
Can Orcabase change or slow down my database?
My database only allows known IP addresses. What now?
Does Orcabase copy my PostgreSQL data?
Your PostgreSQL data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.