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

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.