collate-sqllineage
Collate SQL Lineage for Analysis Tool powered by Python and sqlfluff based on sqllineage.
Decision gist · record as of 2026-08-14
Yes. The package is actively maintained, has low install friction, carries no known vulnerabilities, and solves a concrete problem—extracting data lineage from SQL without manual parsing. Use it if you need to understand table dependencies, build data catalogs, or visualize SQL data flow. The permissive MIT license removes licensing concerns.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Low install friction with four runtime dependencies (sqlparse, networkx, collate-sqlfluff, sqlglot).
- Active maintenance with a release 50 days ago.
- Supports Python 3.9, 3.10, 3.11.
License · maintenance · safety
permissive license (permissive) — MIT license (permissive) means you can use, modify, and distribute this package with minimal restrictions, provided you include the license notice.
last release 2026-06-25 (50 days)
0 known vulnerabilities (OSV.dev, 2026-08-14) · 1,468,745 downloads/mo, #3,872 on PyPI
Alternatives
Verify before relying
pip install collate-sqllineage
from sqllineage.runner import LineageRunner
runner = LineageRunner("insert into db1.table1 select * from db2.table2")
print(runner.source_tables) # {Table: db2.table2}
print(runner.target_tables) # {Table: db1.table1}- Whether collate-sqlfluff (a fork-specific dependency) is actively maintained and compatible with current sqlfluff versions
- Performance characteristics when analyzing very large SQL files or complex multi-statement batches
- Whether the graph visualization feature requires additional system dependencies beyond the listed runtime packages
What it is and what it does
collate-sqllineage is a SQL lineage analysis tool that parses SQL statements and identifies which tables are read from (sources), written to (targets), and any intermediate tables created during multi-statement execution. It abstracts away the complexity of SQL parsing by using pluggable backends—sqlfluff or sqlparse—to build an abstract syntax tree, then stores the lineage relationships in a graph using networkx. You can use it as a command-line tool to analyze SQL files or query strings, or import it as a Python library to programmatically extract lineage data.
The package supports multiple SQL dialects, column-level lineage tracking (showing which source columns flow into which target columns), and can visualize the resulting data flow as a directed acyclic graph in a browser. It identifies intermediate tables when analyzing multiple statements in sequence, making it useful for understanding complex data pipelines. This is a fork of the original sqllineage project, maintained by the OpenMetadata community with added sqlfluff support.
Use it for
- Extract source and target tables from INSERT, SELECT, and CREATE statements to understand data dependencies in a pipeline.
- Analyze multi-statement SQL scripts to identify intermediate tables and trace end-to-end data flow from raw sources to final outputs.
- Track column-level lineage to see which source columns contribute to each target column in complex transformations.
- Visualize SQL data lineage as a directed graph to document data flow for data governance or impact analysis.
- Validate SQL syntax across different database dialects (PostgreSQL, BigQuery, Snowflake, etc.) and catch keyword conflicts.
- Integrate lineage extraction into data cataloging or metadata management systems to automatically populate table dependencies.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
The package is actively maintained, has low install friction, carries no known vulnerabilities, and solves a concrete problem—extracting data lineage from SQL without manual parsing. Use it if you need to understand table dependencies, build data catalogs, or visualize SQL data flow. The permissive MIT license removes licensing concerns.
Install
collate-sqllineage on PyPI
Before you install
Low install friction with four runtime dependencies (sqlparse, networkx, collate-sqlfluff, sqlglot). Active maintenance with a release 50 days ago. Supports Python 3.9, 3.10, 3.11.
License in practice
MIT license (permissive) means you can use, modify, and distribute this package with minimal restrictions, provided you include the license notice.
Quickstart
pip install collate-sqllineage
from sqllineage.runner import LineageRunner
runner = LineageRunner("insert into db1.table1 select * from db2.table2")
print(runner.source_tables) # {Table: db2.table2}
print(runner.target_tables) # {Table: db1.table1}Verify before relying
- Whether collate-sqlfluff (a fork-specific dependency) is actively maintained and compatible with current sqlfluff versions
- Performance characteristics when analyzing very large SQL files or complex multi-statement batches
- Whether the graph visualization feature requires additional system dependencies beyond the listed runtime packages
Package facts
| License | permissive license permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagessqlparsenetworkxcollate-sqlfluffsqlglot |
| Maintenance | Actively maintained 50 days since the last release |
| First released | |
| Downloads | 1,468,745 / month, #3,872 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableLicense :: OSI Approved :: MIT LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.9Programming Language :: Python :: Implementation :: CPython |
Evidence: collate_sqllineage-2.1.4-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sql lineage analysis”
- collate-sqllineageAnalyzes SQL statements to extract source and target tables,…
- sqllineageSQLLineage parses SQL statements to extract and visualize data…
- openlineage-sqlProvides a Python interface to a Rust-based SQL parser for extracting…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also sqllineage · syntaqlite · dbt-colibri · openlineage-sql · sqloxide · sql-metadata · sqlglot · pglast · collate-sqlfluff