Gudu SQL Omni — Offline SQL Lineage & ER Diagrams in VS Code

Column-level lineage and impact analysis across 36 SQL dialects. No data leaves your machine.

Getting Started | Website

Sound Familiar?

• Which reports break if you rename this column? You grep through hundreds of files, hoping you caught everything.
• Where does this metric actually come from? You trace through five layers of CTEs and views by hand, losing an hour each time.
• Is this refactor safe? You push and pray, because mapping every dependency manually is not realistic on a deadline.
• Cloud tools cost $200–$1,000+/seat/month — they want your SQL uploaded to their servers and live in a separate browser tab far from where you work.

You need lineage analysis that is fast, private, and embedded in your workflow.

How It Works

1. Select SQL in your editor
2. Analyze — right-click or press Ctrl+Alt+L
3. Visualize lineage or ER diagrams instantly
4. Export as JSON or PNG

See Every Feature in Action

Column-Level Lineage

Trace the full path of every column through joins, subqueries, CTEs, unions, and window functions. See exactly which source columns feed into each output column — rendered as an interactive graph you can zoom, pan, and export.

Table-Level Lineage

Get a high-level view of how tables relate and depend on each other across your SQL codebase. Understand the flow of data between tables at a glance before diving into column details.

Schema-Level Lineage

Visualize dependencies across entire schemas and databases. Understand how data flows between schema boundaries — critical for cross-team data contracts and migration planning.

ER Diagrams from DDL

Generate entity-relationship diagrams directly from your CREATE TABLE statements. See tables, columns, data types, and foreign key relationships without switching to a separate modeling tool.

Workspace Scanning & dbt Support

Point Gudu SQL Omni at a directory and it analyzes every SQL file, building a unified lineage graph across your entire project. Native dbt support means your models, sources, and refs are resolved automatically.

Lineage Index Explorer

Browse the lineage index to see all tables and columns discovered across your project. Select any table or column to view its upstream and downstream dependencies, then click to navigate directly to the source SQL file.

Upstream & Downstream Analysis

Select a table or column in the lineage index and instantly see everything upstream (where data comes from) and downstream (what depends on it). Click any node to jump to the exact line in the source SQL file.

Complex SQL Made Crystal Clear in Seconds

The Challenge: Your team needs to understand a 40-line SQL query calculating 90-day customer lifetime value with currency conversions.

WITH completed_orders AS (
  SELECT o.order_id, o.customer_id,
         o.order_date, o.amount, o.currency
  FROM raw.orders o
  WHERE o.status = 'COMPLETED'
),
fx AS (
  SELECT f.currency_code, f.rate_to_usd, f.valid_on
  FROM dim.exchange_rates f
),
orders_usd AS (
  SELECT
    o.customer_id, o.order_date,
    o.amount * COALESCE(f.rate_to_usd, 1) AS amount_usd
  FROM completed_orders o
  LEFT JOIN fx f
    ON f.currency_code = o.currency
   AND f.valid_on = DATE_TRUNC('day', o.order_date)
),
recent AS (
  SELECT customer_id, order_date, amount_usd
  FROM orders_usd
  WHERE order_date >= CURRENT_DATE - INTERVAL '90' DAY
)
SELECT
  customer_id,
  SUM(amount_usd) AS ltv_90d
FROM recent
GROUP BY customer_id;

Right-click, Analyze Data Lineage, and instantly see:

What you instantly discover:

• Source Tables: raw.orders and dim.exchange_rates feeding your KPI
• Value Transformation: How amount * rate_to_usd creates normalized values
• Time Window: Exactly where the 90-day filter applies in the pipeline
• Final Aggregation: How SUM(amount_usd) rolls up to ltv_90d per customer

Manual review: ~5 minutes. With Gudu SQL Omni: < 3 seconds.

Key Benefits

Offline & Private

All SQL parsing happens locally inside VS Code. Your SQL never leaves your machine. No cloud uploads, no accounts, no API keys.

Column-Level Accuracy

Full syntax-tree parsing — not regex matching or heuristics. Correctly handles CTEs, subqueries, correlated subqueries, window functions, table-valued functions, and complex joins.

Impact Analysis

See what breaks when a table or column changes before you ship. Identify all downstream queries, views, and transformations affected by your change.

Quick Start

1. Install — Search "Gudu SQL Omni" in VS Code Extensions (Ctrl+Shift+X)
2. Open any .sql file — the extension activates automatically
3. Analyze — Press Ctrl+Alt+L for data lineage, or right-click for more options
4. Scan a project — Right-click any folder in Explorer, select "Analyze SQL Lineage"

No accounts, no API keys, no configuration files. The extension detects your database dialect automatically.

Commands

Works with Your SQL Dialect

36 database dialects supported:

Cloud Data Warehouses — Snowflake, BigQuery, Redshift, Databricks, Azure SQL

Traditional Databases — PostgreSQL, MySQL, Oracle, SQL Server, DB2, SQLite

Big Data Platforms — Spark SQL, Hive, Presto, Trino, Impala, Athena, Flink SQL

Analytical Engines — ClickHouse, DuckDB, Vertica, Greenplum, Teradata, StarRocks, Doris

Enterprise & Others — SAP HANA, Informix, Netezza, Sybase, Couchbase, EDB Postgres, GaussDB, and more

The parser auto-detects the dialect, or you can set a default in settings.

How It Compares

Trusted by Data Teams

"Finally, SQL lineage that works offline. No more worrying about sensitive data leaving our machines." — Senior Data Engineer, Fortune 500

"The column-level lineage is incredibly accurate. Saved us hours debugging data pipelines." — Analytics Lead, Tech Startup

"Impact analysis before deploying changes is a game-changer. We catch issues before production." — Data Architect, Healthcare

Pricing

Free Trial — $0 forever

• Up to 10 tables per analysis
• All 36 SQL dialects
• Column-level lineage & ER diagrams
• No time limit

Personal — $10/month

• Unlimited tables
• Full workspace scanning
• dbt project support
• Use on up to 3 devices
• 14-day money-back guarantee
• Cancel anytime

Enterprise — Custom pricing

• Unlimited tables & devices
• Priority support & volume licensing
• Contact support@gudusoft.com

Configuration

{
  // Set your primary data warehouse
  "guduSQLOmni.general.defaultDbVendor": "snowflake",

  // Include temporary tables in lineage
  "guduSQLOmni.lineage.showTemporaryResult": true,

  // Show all data relationships
  "guduSQLOmni.lineage.showRestrictGroupsRelation": true
}

FAQ

Do you upload my SQL? No. Parsing and analysis happen locally. No SQL leaves your machine.

Do I need to install Java? No. The extension bundles a minimal Java runtime for your platform (Windows, macOS, Linux — x64 and ARM64).

How accurate is the lineage analysis? Full syntax-tree parsing using the Gudusoft SQL Parser — not regex matching. Correctly handles CTEs, subqueries, window functions, and complex joins. Same parser engine trusted by enterprise data governance platforms.

Can I use it with dbt projects? Yes. Point it at your dbt project directory and it builds lineage across your entire model graph, resolving refs and sources automatically.

What happens when the free trial ends? The trial never expires. The extension continues to work with a 10-table limit. Upgrade to Personal ($10/month) to remove the limit.

Can it handle large SQL files? Optimized to handle SQL files up to 10MB. Column-level analysis stays fast.

Does it work offline? Yes. All SQL parsing happens locally. Internet only needed for license activation.

Links

• Website
• Report Issues
• GitHub
• Privacy Policy
• Refund Policy

Gudu Software specializes in SQL parsing and data lineage tools, serving Fortune 500 companies' data governance needs. Our SQLFlow technology powers enterprise data catalogs and governance platforms worldwide.