Databases

Dashboards from PostgreSQL, with AI

PostgreSQL powers many web systems and digital products. Connect Hubviz to track usage, revenue and operations without manual exports.

7 days free · Cancel before the trial ends and pay nothing

How to connect: PostgreSQL

  1. Create the connection profile

    Enter your PostgreSQL access details in Hubviz Studio. The profile is saved for reuse in other projects.

  2. Pick tables or write the query

    Browse schemas, tables and views, or write the SQL. If you prefer, describe it in plain language and AI generates the query.

  3. Ask for the dashboard

    With the cube created, ask AI for the dashboard or build it in the visual editor and publish to Hubviz Web.

What you can do

  • Explorer with schemas, tables, views, primary and foreign keys
  • Custom query or direct table selection
  • AI SQL generator based on the database structure
  • Scheduled refresh with cron expressions

Product metrics

Active users, signups, retention and cohorts from application tables.

Recurring revenue

Subscriptions, churn and average ticket by period.

Operations

Orders, lead times and support queues in near real time.

Executive view

Consolidated KPIs for leadership with comparisons.

Frequently asked questions

Does Hubviz change data in PostgreSQL?

No. Hubviz reads data for analysis. We recommend a database user with read-only permission.

Do I need to know SQL?

No. You can pick tables or describe the query in plain language for AI to generate the SQL.

Can I analyze user cohorts?

Yes. Hubviz has a cohort visualization, plus lines, funnels and pivot tables.

See all your company numbers in one place this week

You get 7 free days to connect your sources and build your first dashboards.