Offline SQL Lineage and ER Diagrams inside VS Code

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

Install in VS Code Subscribe – Launch Week $10/mo

Offline & Privacy-first 14-day refund Works with major SQL dialects

Launch week ends in: 00:00:00

How it works

Select SQL
Analyze
Visualize lineage/ER
Export JSON/PNG

Column-Level Lineage

Track data flow across tables and transformations

Impact Analysis

See what breaks before you ship changes

ER Diagrams

Visualize entity relationships from SQL

Offline & Private

Analyze SQL locally. Your SQL never leaves your machine.

Column-level lineage

Trace fields across complex SQL with CTEs and window functions.

Impact analysis

See what breaks when a table/column changes before shipping.

Works with Your SQL Dialect

Support for 30+ SQL dialects including CTE, window functions, and cross-dialect parsing

See the Magic: 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. How long would it take to trace every column, join, and transformation manually?

📝 Your Complex Business Logic

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 ⚡ Instant visualization

🎯 Instant Visual Understanding

Data lineage visualization showing complete flow from source tables through transformations to final output

💡 Currency conversion logic traced instantly

🔍 All data sources identified

📊 90-day filter impact visualized

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

🚀 Transform Hours of Analysis into Seconds

Manual Review ~5 minutes

With Gudu SQL Omni < 3 seconds

Stop wasting time decoding SQL. Whether you're debugging production issues, onboarding new team members, or performing impact analysis for schema changes - Gudu SQL Omni turns complexity into clarity, instantly.

Get Instant SQL Clarity – Subscribe Now 🛡️ 14-day money-back guarantee • Cancel anytime

VS Code plugin vs. online platforms

	Gudu SQL Omni	Online platforms
Privacy	Offline, local parsing	Uploads or agents
Setup	Install & go	Accounts & connectors
Speed	Instant	Network latency
Granularity	Column-level	Varies

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

Personal

$10/month

🚀 Launch Week Special

✅ Unlock unlimited tables
✅ Column-level lineage & impact
✅ All Pro features
🛡️ 14-day refund guarantee
❌ Cancel anytime

Subscription valid until next billing cycle

Subscribe Now

⚠️ Free trial limited to 10 tables. Upgrade to unlock unlimited analysis. VAT calculated at checkout where applicable.

FAQ

Do you upload my SQL?

No. Parsing and analysis happen locally. No SQL leaves your machine.

Which SQL dialects are supported?

Works across major dialects (e.g., Snowflake, BigQuery, Redshift, Databricks, Postgres).

How does the subscription work?

Subscribe for $10/month (Launch Week special). Cancel anytime. Your subscription remains valid until the next billing cycle.

How do I activate Pro?

After subscribing, copy your license key to the extension's Activate/Upgrade command.

Can I cancel anytime?

Yes! Cancel anytime and continue using Pro features until your billing cycle ends.

Refund policy?

14-day no-questions-asked refund. Contact support@gudusoft.com with your order ID.

Does it work offline?

Yes! All SQL parsing happens locally. Internet only needed for license activation.

What about performance with large SQL files?

Optimized to handle SQL files up to 10MB instantly. Column-level analysis stays fast.

Can I use it with my team?

Do you collect telemetry?

Minimal anonymous usage stats only. Can be disabled. We never see your SQL content.