Build Live Dashboards from Any SQL Query

Most BI tools make you rebuild your mental model. You already know how to get the answer — it's a SQL query — but then you spend a week translating that into LookML definitions, dragging dimensions onto axes, fighting with date filters, and configuring a data model so that a drag-and-drop builder can do what your query already does.

Fastero skips that translation step entirely. You write a query, click a button, and it becomes a dashboard widget. The query IS the dashboard. If you can SELECT it, you can visualize it.

The workflow: query to widget in one click

Here's what it actually looks like. You connect a database — Postgres, BigQuery, Snowflake, MySQL, Redshift, or any of 30+ supported sources — and open the SQL editor. Write your query:

SELECT
  DATE_TRUNC('month', created_at) AS month,
  plan_tier,
  COUNT(*) AS new_customers,
  SUM(mrr_cents) / 100.0 AS new_mrr
FROM subscriptions
WHERE created_at >= CURRENT_DATE - INTERVAL '12 months'
  AND status = 'active'
GROUP BY 1, 2
ORDER BY 1

Run it. See the results table. Click "Add to Dashboard." Pick a chart type — line, bar, area, number/KPI, or table — and the widget is live. That's it. No model layer, no transformation step, no "publish to production" workflow.

Want a second widget? Write another query, same process. A dashboard is just a collection of queries with chart types assigned. You can rearrange them, resize them, title them — but the source of truth is always the SQL.

Widget types and when to use each

Fastero supports five core widget types. Each one maps to a different shape of SQL result:

Number / KPI — single-value metrics. Total MRR, active users, open support tickets. Your query returns one row, one column. The widget renders it large, with optional comparison to the previous period.

SELECT SUM(mrr_cents) / 100.0 AS current_mrr
FROM subscriptions
WHERE status = 'active'

Line chart — trends over time. Your query returns a date column and one or more value columns. MRR by month, signups by week, error rate by day.

Bar chart — categorical comparisons. Revenue by plan tier, tickets by priority, users by region. Grouped and stacked variants handle multiple series.

Area chart — like line charts but better for showing composition. Stacked area is particularly effective for "what makes up our total revenue" views where you want to see both the trend and the proportions.

Table — when you need the raw numbers. Top 20 customers by spend, recent failed payments, overdue invoices. Tables support sorting, and they're the right choice when your audience will scan individual rows rather than eyeball a trend.

The choice is always yours. Fastero suggests a chart type based on the result shape — a single value gets KPI, a date column gets line — but you can override it. The query determines the data; the widget type determines the presentation.

AI-generated dashboards: skip the SQL entirely

Not every dashboard starts with a query you already know. Sometimes you want to say "build me an executive revenue dashboard from Stripe and Postgres" and get something useful in 60 seconds.

Fastero's AI agent handles this. It inspects your connected schemas, identifies the relevant tables, writes the queries, picks appropriate chart types, and assembles a multi-widget dashboard. You review what it built, edit the SQL if anything's off, and you're live.

This works especially well for common patterns: SaaS metrics dashboards, e-commerce performance views, marketing spend trackers. The AI has seen enough schemas to know that a table called payments with columns amount, status, and created_at is probably revenue data, and that you probably want it grouped by month.

For teams where some people write SQL and others don't, this is the bridge. Your data engineer builds the complex widgets by hand. Your head of ops asks the AI for the ones they need. Both end up on the same dashboard.

Any database, any source — same interface

We wrote a separate post about building KPI dashboards from Postgres specifically. This isn't that. The dashboard feature works identically regardless of which database you connect:

• Warehouses: BigQuery, Snowflake, Redshift, Athena
• Transactional databases: Postgres, MySQL, MSSQL, Oracle
• Local/embedded: DuckDB (including managed)
• SaaS APIs: Stripe, HubSpot, Shopify, Salesforce, Google Ads, GA4

The SQL dialect adapts to the source. DATE_TRUNC on Postgres, DATE_TRUNC on BigQuery (same syntax, different engine), DATEADD on MSSQL. The widget doesn't care — it receives rows and columns and renders them.

Where it gets interesting is cross-source dashboards. Fastero's DuckDB store lets you pull data from multiple connectors and join across them. A single dashboard can show Stripe revenue alongside Postgres product metrics alongside HubSpot pipeline — without a centralized warehouse. You write standard SQL against a unified namespace, and each widget queries wherever its data lives.

Auto-refresh: dashboards that stay current

A dashboard you have to manually refresh is a screenshot with extra steps. Fastero runs each widget's query on a schedule:

• Hourly — operational metrics (error rates, queue depths, active sessions)
• Daily — business KPIs (MRR, signups, churn)
• Weekly — strategic metrics (cohort retention, LTV, growth rates)

You set the schedule per widget or per dashboard. An hourly widget on a daily dashboard refreshes hourly — the widget schedule takes precedence. Results are cached between refreshes, so the dashboard loads instantly even when the underlying query takes 30 seconds.

If scheduled refresh isn't enough, you can add triggers — condition-based checks that fire when a metric crosses a threshold. "Alert me on Slack if daily signups drop below 50% of the 7-day average" is a trigger attached to a dashboard widget. The dashboard shows the current state; the trigger tells you when the state changes.

Sharing and embedding

Every dashboard gets a shareable link. Anyone on your team can view it — no need for individual database credentials, because the dashboard queries through Fastero's connection.

For embedding dashboards in your own product — internal tools, client portals, admin panels — see embedded analytics. The same SQL-powered widgets render inside an iframe with your auth layer controlling access.

Templates for common patterns

Starting from a blank dashboard is fine if you know exactly what you want. But for common use cases — SaaS KPI tracking, e-commerce performance, marketing spend analysis — Fastero includes templates that pre-populate a dashboard with the right queries. Connect your data source, select a template, and the queries adapt to your schema.

Templates are editable. They're a starting point, not a cage. Modify the SQL, swap chart types, add widgets, remove the ones you don't need. Think of them as "dashboards someone already built for this exact use case" rather than rigid configurations.

The gap this fills

There's a dead zone in the dashboard market between "write SQL in a terminal" and "full BI platform with a semantic layer, model definitions, and a three-month implementation." Most data practitioners live in that gap. They have queries that work. They want those queries visualized and refreshed automatically. They want to share the results with five people, not deploy a governed analytics layer to five hundred.

Traditional BI tools — Looker, Tableau, Power BI — are built for the five hundred. They earn their complexity at scale. But if you're a team of 3 to 30 people, the overhead of maintaining LookML definitions, configuring Tableau Server, or managing Power BI Premium capacity is time you could spend actually analyzing data.

Fastero sits where Metabase and Redash aimed to sit — SQL-first, minimal configuration, fast to set up — but with AI generation, cross-source joins, and a scheduling/alerting layer that those tools either lack or bolt on awkwardly.

If you think in SQL, your dashboard tool should speak SQL. Write a query, pick a chart type, set a refresh schedule, share the link. Everything else is overhead.

Try Fastero free — connect any database, turn your SQL queries into live dashboards, and share them with your team in minutes. No credit card required.