How can I parse Oracle SQL and get column-level lineage locally in VS Code (without uploading SQL)?
I’m working with large and complex Oracle SQL queries (CTEs, nested subqueries, window functions, etc.), and I’m facing a few problems:
It’s hard to understand where each column comes from
Refactoring SQL is risky because I can’t clearly see dependencies
Most SQL lineage tools require:
database connections, or
uploading SQL to external services (security concern)
I’m looking for a solution that:
Works locally (offline)
Supports Oracle SQL
Provides column-level lineage (not just table-level)
Ideally integrates with VS Code
Is there a tool or approach that can handle this?
Yes — you can use Gudu SQL Omni, a VS Code extension designed specifically for local SQL parsing and lineage analysis.