Documentation

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.

Step by step

1Open Glimpse BI → Settings → Schema.
2Choose a schema mode: Open (all tables) or Allowlist (only listed tables).
3In Allowlist mode, list the tables you want chartable (one per line, with your table prefix).
4Save. The builder’s Source-table list updates to match.
5Use Refresh schema if you add tables and they don’t appear yet (introspection is cached for an hour).

yoursite.com/wp-admin/admin.php?page=glimpsebi-settings

Glimpse BI Settings — cache TTL, query limits, and schema discovery controls.

What’s discoverable

Introspection reads table and column names from the database’s information schema. By default the core WordPress tables (posts, users, comments, terms) are surfaced; switch to Open to chart any table, or Allowlist to restrict to a curated set — useful on shared installs.

Joins

GUI charts are single-table for safety and clarity. To combine tables, use SQL mode and write the JOIN yourself — it passes the same read-only AST validator. (A revenue-by-category chart, for example, joins orders → order-items → products in SQL mode.)

Reference

Schema modesOpen · Allowlist

Default tablesposts · users · comments · terms

Schema cache1 hour (manual refresh)

GUI joinsSingle-table (use SQL mode to join)

NextCaching & performance

Install free in a minute. Ask when you’re ready.

Start with the free plugin from WordPress.org. Upgrade to Pro to unlock Ask, pre-computed charts and Editor roles.

Get the free plugin See Pro plans