Last updated: 2026-07-11

SQL Dashboards

Build multi-tile dashboards over live SQL without leaving your database IDE. Each tile runs its own query — against any saved connection, any engine — and renders as a chart, stat, table, pivot, or note, with auto-refresh, parameters, cross-filtering, and alerts built in.

What is a SQL dashboard in Jam SQL Studio?

A dashboard is a grid of tiles, where every tile is backed by a SQL (or KQL) query you can always see and edit. There is no separate BI server, no data model to publish, and no per-viewer licensing — dashboards live inside Jam SQL Studio next to your Query Editor and Table Explorer, and they query your databases directly over the connections you already saved. The connection is chosen per tile, so one dashboard can mix SQL Server, PostgreSQL, MySQL/MariaDB, Oracle, SQLite, and Kusto/Azure Data Explorer tiles on the same screen.

Open dashboards from the Dashboards button in the main toolbar, or from the Dashboards node in the Object Explorer. On a fresh install, starter dashboards offer a one-click, engine-appropriate set of tiles so the first dashboard isn't a blank page.

A populated SQL dashboard with chart, stat, table, and note tiles over live queries. — A dashboard mixing chart, stat, table, and note tiles — every tile backed by a query you can open and edit.

Tile types

Tile	Shows	Key options
Chart	Bar, line, pie, area, or scatter chart of the query result	Same chart builder as the Charts tab, plus dashed reference lines (target values / goal bands with warning or critical coloring)
Stat	One big number from the result	Value column, format (number, percent, currency, duration), compare against a previous-period column or a fixed target, optional sparkline, warning/critical thresholds, alert rules
Table	The raw rows	Row limit, column subset, compact/comfortable density, conditional formatting per column
Pivot	Rows × columns cross-tab	Row column, column column, value column, aggregation (sum, avg, min, max, count)
Note	Markdown text	No query — use for headings, runbooks, and links between sections

Tiles live on a 12-column grid: drag to move, drag edges to resize, or use the keyboard — arrow keys move a focused tile and Shift+arrows resize it, with the grid compacting upward automatically.

Adding tiles — four sources

The Add tile dialog offers four ways to produce the tile's query, all ending in the same live, read-only preview before anything is saved:

SQL — write or paste a query, run the preview, pick the result set if the script returns several, and choose the tile type (the dialog suggests one that fits the result's shape).
Templates — a built-in catalog of DBA queries per engine (see below). Inserting a template drops its SQL into the editor fully editable — nothing is hidden behind the tile.
Visual — build the query in the Visual Query Editor without typing SQL.
AI — describe the tile in plain English; the AI drafts the SQL, you preview and accept. A whole-dashboard Build with AI panel proposes several tiles at once, each individually previewable and rejectable — nothing runs or is added before you act.

You can also pin an existing result onto a dashboard from outside: the pin button on the Query Editor results toolbar (or a result cell's right-click menu), the Table Explorer toolbar, and the chart toolbar all open a confirm sheet that shows exactly what query the tile will carry before it lands.

Template catalog

48 DBA templates ship across the six engines, sourced from the same queries that power the Session Browser, Performance Dashboard, and DBA toolkit — grouped into sessions, performance, indexes, storage, backup, and jobs categories:

Engine	Templates	Examples
SQL Server	10	Longest running queries, blocking chains, top waits, buffer cache hit ratio, tempdb usage
PostgreSQL	10	Active queries, lock waits, cache hit ratio, dead tuple pressure, unused indexes, WAL archive failures
Oracle	9	Active sessions, blocking locks, top SQL by elapsed time, tablespace usage, RMAN backup status
MySQL / MariaDB	8	Active queries, InnoDB lock waits, buffer pool hit ratio, temp tables spilling to disk
Kusto / ADX	7	Running queries, ingestion failures, cluster node health, materialized views
SQLite	4	Database file size, reclaimable free pages, integrity check, index inventory

Templates are honest about compatibility: one that needs a server version or capability your connection hasn't proven is hidden, not shown greyed out, and templates that need a specific grant (for example VIEW SERVER STATE) say so in their description.

The Add Tile dialog's Templates tab listing per-engine monitoring templates with search. — The Templates tab in Add Tile — searchable, per-engine monitoring queries that land as editable SQL.

Refresh and the execution policy

Each tile refreshes manually or on an interval you choose; the toolbar also has a refresh-all.
Tile queries run under a read-only policy — a statement classified as a write is blocked from scheduled refresh unless you explicitly trust that exact tile query, and the trust is revoked automatically the moment the SQL changes.
Hidden dashboards pause their schedules and catch up once visible; a refresh that would overlap a still-running query skips the cycle instead of piling up; a tile that takes far longer than its usual duration gets flagged.
An issue-only health rail lists failing or stale tiles — it stays out of the way when everything is green.

Parameters

Dashboards accept typed parameters that tiles reference in their SQL: a time range (7/28/90 days or a custom from–to), a static list, a query-driven list (label and value columns, optionally cascading off other parameters), and free text. List parameters support multi-select and an "All" option. Values persist per dashboard and never travel in exported definitions.

Cross-filtering and drill-through

Click a chart mark (a bar, a point, a pie slice) or a table row and the dashboard applies that value as a filter to every tile that opted in. Wiring is by example: you map each tile's column or expression to a shared dashboard field once, and clicks do the rest. From a filtered tile you can drill through to a full Query Editor tab carrying the tile's query and the active filters.

Alerts (stat tiles)

A stat tile can carry an alert rule — an operator and threshold that fires an OS notification when crossed, with a cooldown between notifications and automatic re-arm when the value recovers. Alerts can optionally keep refreshing in the background while the dashboard is hidden, on a separate budget so background tiles can't starve the visible ones. Thresholds (warning / critical coloring) work without alerting, too.

Present mode and playlists

Present takes a dashboard full-screen for a wall monitor. A playlist rotates through several dashboards at a fixed cadence, pre-warming the next dashboard's queries so rotation never shows a wall of spinners.

Present mode showing a dashboard full-screen without editor chrome. — Present mode — chrome-less full screen for a wall monitor or screen share; Escape exits.

Dashboards in the Object Explorer

Once at least one dashboard exists, a Dashboards node appears at the top of the Object Explorer. Double-click a dashboard to open it. The right-click menu offers:

Open — open the dashboard tab.
Present — jump straight to full-screen present mode.
Rename — opens dashboard settings (name, parameters, playlist).
Duplicate — disabled with an explanatory tooltip when the free-tier cap is reached.
Export definition… — save the dashboard as a JSON file.
Delete — with a confirmation dialog.

Sharing and export

Definition export/import (JSON) — the file carries queries, layout, and parameters, never credentials or parameter values. Importing on another machine offers a connection remap step listing engine-compatible saved connections for each tile.
PNG / PDF — capture the rendered dashboard for a report or a ticket.
Interactive HTML snapshot (Pro) — a single self-contained file with the data baked in: tables sort locally, nothing phones home (zero network requests), safe to email.

AI agents and MCP

AI agents connected over MCP get five dashboard tools: dashboard_list, dashboard_create, dashboard_add_tile (full tile JSON or a template id), dashboard_update_tile, and dashboard_refresh (per-tile success/error report). Changes made by an agent appear live in the open app.

Free vs Pro

The free Personal tier includes 2 dashboards with every feature above except the HTML snapshot. Pro removes the dashboard cap and adds the interactive HTML snapshot export.

FAQ

How do I create a SQL dashboard in Jam SQL Studio?

Click the Dashboards button in the main toolbar, name your dashboard, and add tiles. Each tile runs its own SQL query against any saved connection and renders as a chart, stat, table, pivot, or markdown note on a 12-column grid. You can also pin an existing result straight from the Query Editor, Table Explorer, or a chart.

Which databases can dashboard tiles query?

All engines Jam SQL Studio supports: SQL Server, PostgreSQL, MySQL/MariaDB, Oracle, SQLite, and Kusto/Azure Data Explorer (KQL). Every tile picks its own connection, so one dashboard can mix tiles from different servers and engines side by side.

Can dashboard tiles auto-refresh?

Yes. Each tile is either manual or on an interval you choose. Refreshes run read-only, pause while the dashboard is hidden and catch up when it becomes visible again, skip a cycle instead of overlapping when a query is still running, and warn when a tile takes far longer than its usual duration.

Can one dashboard combine data from different connections?

Yes. The connection is chosen per tile, not per dashboard — a production PostgreSQL chart can sit next to a SQL Server stat and a Kusto table on the same grid.

How many dashboards can I create for free?

The free Personal tier includes 2 dashboards with every tile type, templates, parameters, cross-filtering, alerts, present mode, and PNG/PDF export. Pro removes the dashboard cap and adds the interactive HTML snapshot export.

Can I share a dashboard with a teammate?

Yes, two ways. Export the dashboard definition as JSON — importing it on another machine offers a connection remap step so tiles bind to the teammate's own engine-compatible connections; no credentials ever travel in the file. Or export an interactive HTML snapshot (Pro): a single self-contained file with the current data, sortable tables, and zero network calls.

Can AI create dashboard tiles?

Yes. The Add Tile dialog has an AI source that drafts a query from a plain-English request, and the Build with AI panel proposes several tiles for a whole dashboard at once — each proposal is previewed read-only and nothing is added until you accept it. External AI agents can also manage dashboards through the dashboard_* MCP tools.

Charts — the chart builder dashboards reuse
Query Editor — pin results to a dashboard
Table Explorer — pin table views to a dashboard
AI Integrations & MCP — dashboard tools for AI agents
Keyboard Shortcuts — grid move/resize keys