See How Your Data Flows

Visualize SQL data lineage and understand column-level dependencies at a glance. Trace data from source to output in seconds.

Launch App View on GitHub

flowscope.pondpilot.io

1
2
3
4
5
6
7
8
9
10
11
12

WITH orders AS (
  SELECT * FROM
    warehouse.core.orders
),

customer_orders AS (
  SELECT
    user_id AS customer_id,
    COUNT(*) AS num_orders,
    SUM(amount) AS total_spent
  FROM orders
  GROUP BY user_id
)

orders

order_id user_id amount created_at

customer_orders

customer_id num_orders total_spent

customer_summary

customer_id num_orders total_spent

Features

Understand your SQL at a glance

Automatic lineage extraction and visualization for any SQL query

Column-Level Lineage

See exactly which source columns feed into each output column

Auto-Detection

Paste any SQL and get instant lineage visualization - no setup required

Complex Query Support

CTEs, subqueries, joins, unions - FlowScope handles them all

Export & Share

Export lineage diagrams as images or share interactive links

Privacy First

100% client-side - your SQL never leaves your browser

PondPilot Integration

Seamlessly works with PondPilot App for combined query and lineage analysis

Use Cases

Debug Complex Queries

Trace data flow through CTEs and subqueries to find where transformations happen.

Documentation

Auto-generate visual documentation for your SQL transformations.

Code Review

Quickly understand SQL changes in PRs with visual lineage diffs.

Impact Analysis

See which outputs are affected when source columns change.

Ready to visualize your SQL?

Paste any SQL and instantly see how your data flows from source to output.

Try FlowScope Explore PondPilot App

Part of the PondPilot Flock