Plotbase questions, on live data.
Add Basalt as a PostgreSQL database in Plotbase. Questions and dashboards query views directly, with results in milliseconds.
How it works.
Plotbase uses its built-in PostgreSQL driver to connect over the wire protocol. Basalt exposes views as tables with column types and comments, so the query builder and models work without extra mapping.
Set it up in three steps.
Connect the tool
Create a read-only role and add a PostgreSQL database in Plotbase admin. Turn off scheduled syncs; schemas update on change.
# create a read-only login for Plotbase basalt connect metabase --role readonly ✓ role metabase_ro created · 18 views granted ✓ host pg.us-east-1.basalt.dev:5432 · TLS required
Shape it with a view
Write plain SQL over the source. Basalt keeps the view current with every record and tracks lineage back to the topic, partition and offset.
CREATE MATERIALIZED VIEW revenue_by_min AS SELECT date_trunc('minute', ts) AS minute, currency, sum(amount) AS revenue, count(*) AS payments FROM payments WHERE status = 'captured' GROUP BY 1, 2;
Read it from anywhere
Every view is an endpoint the moment it exists. Call it over REST, connect with any Postgres client, or use the SDK from your app.
curl https://api.basalt.dev/v1/views/revenue_by_min?limit=5 \ -H "Authorization: Bearer $BASALT_TOKEN"
What you get.
Built-in driver
Uses Plotbase's PostgreSQL driver on Cloud or self-hosted. No plugin.
Query builder
Views appear as tables, so non-SQL users can filter and group them.
Live dashboards
Set auto-refresh to one minute without load on your source databases.
Column metadata
Types and descriptions carry over, so semantic types are set for you.
Set your data in stone.
Free up to 10M events a month. No card, no sales call. Your first pipeline is live in about four minutes.