Know it before you translate it
SQL Tran's static analysis engine maps every reference, every dependency, and every issue across your entire codebase. Instantly.
Translation without understanding produces broken code. Before SQL Tran touches a single line, the static analysis engine builds a complete map of your database: what references what, what depends on what, and what is already broken in the source.
Static analysis is the pillar of every advanced feature in SQL Tran. It powers accurate translation, dependency mapping, test generation, and issue detection. Without it, you are guessing. With it, you have full visibility.
How it works
A complete dependency graph of your database
After Hummingbird parses your SQL into a syntax tree, the static analysis engine walks the entire codebase and resolves every name reference. It connects tables to the views that query them, procedures to the functions they call, and columns to every expression that reads or writes them.
The analysis is not a one-time scan. It runs continuously as you work, updating the dependency graph in real time as code changes.
What it detects
Surface every issue before migration
Broken references
Objects referencing tables, columns, or procedures that do not exist. Source databases almost always have far more broken code than anyone realizes. SQL Tran surfaces it all.
Unused objects
Code that is never called from anywhere in the database. Dead code adds migration complexity for no value.
Hidden dependencies
Chains of references that are not obvious from reading individual objects. A change in one table can cascade through views, procedures, and functions in ways that are invisible without full-graph analysis.
Untranslatable constructs
Features in the source dialect with no direct equivalent in the target. SQL Tran identifies these early so they can be addressed through emulation or manual review.
The Analysis Tab
IDE-quality code navigation
Go to Definition
Press F12 or Ctrl+click any name to jump to the definition of the referenced object. Navigate complex codebases the way you would in a modern IDE.
Hover for context
Hover any name to see what it declares or references. Instant context without switching views.
Depends on / Referenced by
The Analysis tab shows every object the current one depends on, every object that references it, and every broken reference. In both source and target views.
Key benefits
- Full codebase-wide reference tracking across all object types
- Real-time updates as you edit or override translated code
- Informs translation accuracy: the translator uses analysis results to write better target code
- Powers downstream features: dependency mapping, test generation, creation ordering
See what your database really looks like
Start a free assessment and discover every dependency, every broken reference, and every issue hiding in your codebase.