BigQuery to ER Diagram

How it works

1. Copy a BigQuery WITH / CTE query, or your CREATE TABLE DDL.
2. Paste it into the editor — BigQuery CTE queries are auto-detected.
3. Each CTE becomes a node; columns come from its SELECT list, and FROM/JOIN references (including backtick project.dataset.table) are drawn as edges.
4. Arrange, hide nodes, then export PNG/SVG or convert to Mermaid/DBML.

Example

A BigQuery CTE query like this:

WITH customers AS (
  SELECT id, email FROM `proj.shop.customers_raw`
),
orders AS (
  SELECT o.id, o.customer_id
  FROM `proj.shop.orders_raw` o
)
SELECT * FROM orders

…renders customers and orders as nodes, linked to the base tables they read from. Try it with your own →

Why use it

• Private: everything runs in your browser — nothing is uploaded or stored on a server.
• CTE lineage — see how each WITH step depends on tables and other CTEs.
• Interactive: drag tables, auto-arrange, hide noise, add notes, and manually link columns.
• Export a high-res PNG, vector SVG, or the schema as Mermaid / DBML / PlantUML code.
• Free & open source — no account, no sign-up.

FAQ

How do I visualize a BigQuery CTE query?

Paste your WITH … AS (…) query. Each CTE becomes a node, columns come from its SELECT list, and references to other CTEs or backtick-quoted project.dataset.table tables are drawn as edges.

Does it work with BigQuery CREATE TABLE DDL too?

Yes — paste standard CREATE TABLE statements and it draws a classic ER diagram with foreign-key relations.

Is my schema uploaded anywhere?

No. Everything runs locally in your browser — your schema is never uploaded to or stored on any server.

Is it free?

Yes. It is completely free and open source, with no account or sign-up required.

Related