GlimpseBI

Documentation

Get up and running.

Accurate, task-focused guides — from your first chart to SQL, dashboards, performance, security, and embeds.

Installation

Install Glimpse BI from WordPress.org or a manual zip upload. On activation it creates its tables and is ready immediately — no configuration required.

Build your first chart

The no-code GUI builder turns a table, an aggregate, and a dimension into a chart — with a live preview as you go. No SQL required.

SQL mode

When the GUI runs out of room, drop to a CodeMirror SQL editor. Queries are validated read-only at the AST level — never a regex — so power users get full SQL without giving up safety.

Dashboards

Arrange charts on a responsive 12-column grid. Drag to reposition, drag a corner to resize, and pin the same chart to as many dashboards as you need.

Dashboard filters

One global filter bar re-slices every chart on a dashboard at once — a date range and a time grain that each chart maps to its own date column.

Chart types

Seven ways to read your data, all themed with one editorial ApexCharts design system so a Glimpse BI chart looks the same on every site.

License activation

Pro

The free plugin works immediately with caps. Pro is unlocked with a license key — activated once, cached locally, and revalidated daily with a 7-day grace window so outages never break your site.

Materialization

Pro

A Pro feature that pre-computes a chart’s results into a dedicated summary table on a schedule — turning slow queries on large databases into instant dashboard loads.

Embeds & shortcodes

Publish charts as public, token-protected iframes — no WordPress login required to view. Each embed has a unique signed token, configurable expiry, hit tracking, and revoke / rotate controls.

Schema & data sources

Glimpse BI introspects your database and lists tables in the builder. A schema mode and allowlist control exactly which tables are chartable.

Caching & performance

Every chart result flows through a stale-while-revalidate cache, and a regeneration lock prevents stampedes — so dashboards stay fast and your database stays calm.

Security model

Glimpse BI is powerful for admins and locked down for everyone else: read-only SQL, a capability gate, bound parameters, query timeouts, and an opt-in table allowlist.

Presets

Install a complete, curated dashboard — charts and layout — in one click. Export your own dashboards as shareable preset files, or upload one you were given.

Exports

Get the underlying data out — per chart or per dashboard — as CSV or JSON. Large exports run as a background job so the browser never hangs.

Troubleshooting

Quick fixes for the issues you’re most likely to hit — missing tables, a greyed-out preset, a slow chart, or an embed that won’t render.