SQLLineage
SQLLineage is a free, open-source Python package and command-line tool for tracing source and target tables in SQL.
What SQLLineage is
SQLLineage is a free, open-source Python package and command-line tool for tracing source and target tables in SQL. It can combine lineage across multiple statements, identify intermediate tables, and show column-level lineage paths. For visual exploration, it can run a web server that presents table and column relationships as a DAG in a browser. Developers can also import it and use the LineageRunner API. SQLLineage analyzes queries with pluggable sqlfluff and sqlparse parsers. ANSI is the default dialect; the documentation recommends specifying the dialect when analyzing dialect-specific SQL. Metadata can improve column-lineage accuracy for wildcard selections and unqualified columns in joins. A SQLAlchemy metadata provider can query database metadata, but the required database drivers must be installed separately. An opt-in rustworkx graph operator is recommended for improved performance on large lineage graphs. Installation is available through pip from PyPI or directly from GitHub; GitHub installation requires Node.js/npm for the web-based viewer. The repository identifies the license as MIT.
Good
- Combines lineage across multiple SQL statements.
- Shows column-level lineage paths.
- Offers a browser-based DAG view.
- Can be used through a Python API.
Watch out
- Database drivers must be installed separately for metadata queries.
- GitHub installation needs Node.js/npm for the DAG viewer.
- Dialect-specific SQL may need an explicit dialect.
Who it suits
SQLLineage suits developers who need table or column lineage from SQL statements and can work with a Python package or command-line tool. It also suits teams that want to view lineage in a browser-based DAG.
Verdict
SQLLineage provides table and column tracing through command-line, Python, and browser-based workflows. Plan for dialect selection and any separately required database drivers or GitHub-viewer dependencies.
Plans and prices
From SQLLineage's own pricing page, checked 11 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| SQLLineage | Free | Open-source Python package · MIT license · Install via PyPI or GitHub |
The facts
Each one read from SQLLineage's own pages, with the date it was checked.
What it does
- Column lineage
- Its command-line interface can show column-level lineage paths.checked 11 Oct 2026
- Database connections
- Its SQLAlchemy metadata provider queries database metadata, but database drivers must be installed separately.checked 11 Oct 2026
- Graph performance
- An opt-in rustworkx graph operator is recommended for better performance on large lineage graphs.checked 11 Oct 2026
- Installation
- The package can be installed with pip from PyPI or directly from GitHub; GitHub installation requires Node.js/npm for the web-based DAG viewer.checked 11 Oct 2026
- License
- The GitHub repository identifies its license as MIT.checked 11 Oct 2026
- Metadata
- Metadata can improve column-lineage accuracy for wildcard selections and unqualified columns in joins.checked 11 Oct 2026
- Multiple statements
- It combines lineage across multiple SQL statements and identifies intermediate tables.checked 11 Oct 2026
- Purpose
- SQLLineage analyzes SQL commands to identify source and target tables.checked 11 Oct 2026
- Python API
- SQLLineage can be imported as a Python package and used through its LineageRunner API.checked 11 Oct 2026
- Security release
- The changelog describes v1.5.3 as a security release that upgraded dependencies after vulnerability alerts.checked 11 Oct 2026
- SQL dialects
- ANSI is the default dialect, and the documentation recommends specifying a dialect to improve lineage analysis for dialect-specific SQL.checked 11 Oct 2026
- SQL parsing
- It uses pluggable sqlfluff and sqlparse parsers to analyze SQL.checked 11 Oct 2026
- Visualization
- It can start a web server that displays table-level and column-level lineage as a DAG in a browser.checked 11 Oct 2026
Alternatives to SQLLineage
- 1
Atlas
Free planOpen sourceWebAPILinuxmacOS8.3From $39 a month - 2
Coalesce Catalog
Free planWebAPIExtension7.5From $150 a month - 3
Microsoft Defender for Business
AndroidiOSAPImacOS7.5 - 4
Apache Atlas
Free planOpen sourceWebAPILinuxSelf-hosted7.2Free plan - 57.0From $1.15 a month
- 6
Dataedo
WebExtensionSelf-hostedWindows6.5From $18,000 a year