All work
Live · free toolWeb · 2025–2026

See exactly how your SQL moves data

LineagePro is a free SQL lineage visualizer. Paste in a multi-statement pipeline and you get an interactive, column-level graph of how data flows from source tables through transformations to targets. Understanding data flow shouldn't require an enterprise contract, so LineagePro doesn't ask for one.

4+
SQL dialects parsed (Snowflake, PostgreSQL, MySQL, Oracle)
Column
level lineage, traced end to end
251
automated backend tests
$0
to use, no signup required
LineagePro column-level lineage graph: sources through transformations to target

Column-level lineage from a multi-statement SQL pipeline, sources to target

The problem

Ask a data team where a column comes from and the answer is usually a person. Someone opens the SQL, then three more files, and rebuilds the path from memory. The queries that most need this are the worst candidates for it: multi-statement pipelines with CTEs stacked on subqueries, where a single target column is fed by joins several layers down. Tools that trace it properly tend to arrive as part of an enterprise catalog, with a procurement cycle attached. The information is already sitting in the query. It just isn't visible.

What we built

  • Column-level lineage. Handles CTEs, nested subqueries, JOINs, window functions, MERGE, UNION, and multi-statement pipelines. Hover any column to trace its full upstream and downstream path.
  • Share and export. Publish a read-only lineage at a public URL, or export SVG, PNG, HTML, Markdown, or DOT for docs and reviews.
  • Pipeline diffing compares before and after SQL, showing exactly which tables and columns were added, removed, or rewired. It is code review for data flow.
  • Governance extras. Tag columns as PII or confidential, annotate lineage, and generate a markdown compliance report straight from the query.

How it's built

Next.js and TypeScript on the front end, with a Monaco SQL editor and a D3 graph (force-directed or hierarchical Dagre layout, plus a minimap for large pipelines). Django on the back end, parsing SQL with SQLGlot across dialects. It is Dockerized and deployed to a small cloud VPS with GitHub Actions. Same production discipline as the client work: CI, tests, health checks, and error monitoring.

Why a free tool?

LineagePro is the data-engineering services pitch in working-software form. It shows the craft (parsing, visualization, product polish) better than any slide could. It also helps engineers who will never hire anyone, and some who do.

Outcomes

  • The tool is live and free to use. No signup, no trial, no contract.
  • Snowflake, PostgreSQL, MySQL, and Oracle all parse through the same SQLGlot-backed backend, so the graph does not depend on where the SQL was written.
  • Tracing holds at the column level through CTEs, subqueries, JOINs, window functions, MERGE, and UNION, across multi-statement pipelines.
  • Lineage leaves the tool in whatever form a review needs: a read-only public link, or SVG, PNG, HTML, Markdown, and DOT exports.