Skip to content

Gudu SQLImpact

Gudu SQLImpact is a command-line utility that performs fine-grained CRUD impact analysis on your SQL source code.
With one command you can generate traceable, line-level reports that reveal who reads or writes which column, and where in your scripts it happens.

Why SQLImpact?

  • Pin-point Accuracy – Column-level lineage with exact file & line numbers.
  • Compliance Ready – Instantly locate GDPR / HIPAA sensitive fields in any script.
  • Migration Friendly – Quantify the blast-radius of schema changes before you start.
  • DevOps Automation – Integrate with CI/CD pipelines to prevent accidental data loss.

Core Features

  1. Column-Level CRUD Detail – JSON output for each SQL statement.
  2. Summary View – Aggregated table & column statistics with statement count.
  3. Sensitive-Column Tracking – Highlight PII columns based on your own list.
  4. Dynamic SQL Warning – Detect EXECUTE IMMEDIATE / sp_executesql, etc.

Learn more on the Features page.

Quick Start

# Analyze a single file
java -jar gudu-sqlimpact.jar --dialect postgres --in simply.sql --out detail.json

# Analyze a directory and produce a summary report
java -jar gudu-sqlimpact.jar --dialect oracle --in scripts/ --summary --out summary.json

Head over to Getting Started for a step-by-step tutorial.

Download

Grab the latest gudu-sqlimpact.jar from the Download page.

Need Help?

Last update: May 20, 2025