Dashboards built for analysts
Connect your warehouse directly, write SQL, render rich visualisations — without learning a new BI dialect or paying enterprise pricing.
Last updated June 2026 · By Widgets PRO Team
Direct warehouse access
PostgreSQL, MySQL, BigQuery, Snowflake — read-only queries, parameterised inputs, full SQL.
Twenty chart types
Line, bar, area, scatter, heatmap, treemap, funnel, candlestick, sankey — pick the one that fits the question.
Cohorts & funnels
Retention matrices and conversion funnels render from a single SQL query — no special widget needed.
Parametrised dashboards
Date pickers, dropdowns, and search inputs bind directly to SQL — change a filter, every widget rerenders.
Scheduled refresh
Cache expensive queries with a 5-min / 1-hour / nightly refresh — fast for viewers, gentle on the warehouse.
Embed anywhere
Drop a dashboard into your data wiki, intranet, or customer portal with a single iframe.
Looker-grade analysis, dashboard-tool simplicity
Write SQL, get visualisations. No semantic layer to maintain, no per-seat licence, no IT ticket to add a column to a model.
- Read-only credentials with statement-level timeout
- Parameter binding to date pickers and dropdowns
- Query history per data source
- CSV export from any chart or table
Built for shared workspaces
Share dashboards inside your team with role-based access, or hand off a polished link to a stakeholder. Brand Kit applies your company palette automatically.
- Roles: viewer, editor, admin
- Audit log of who saw what and when
- Embed with theme override per channel
- Public read-only links with password gating
Frequently asked questions
Yes. Point a SQL widget at any PostgreSQL endpoint (read-only credentials recommended), write your query, the result becomes a chart or a table. Parameters and filters bind into the query — no string concatenation needed.
BigQuery and Snowflake via direct SQL widgets on connection strings. ClickHouse over HTTP. Anything else with a SQL endpoint plugs in the same way. For columnar at scale, Widgets PRO supports query result caching to keep dashboards fast.
Yes — dashboards are exportable as JSON/YAML via the CLI (`widgets pull`), check them into Git, review changes in PRs, deploy with `widgets push`. Multiple analysts can edit in parallel; conflicts surface like any code conflict.
CSV export from any chart or table. Full GraphQL API for programmatic access to dashboards, widgets, and the data behind them. MCP server lets an AI agent query the same data via natural language.