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 no limits on dashboards, charts or embeds. 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.

Ask (AI)

Pro

Ask answers plain-English questions about your WordPress data with a real, editable chart. It runs on Glimpse AI credits included with every Pro plan, and by default it sends your schema only, never your rows.

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.