Variable tracking
Type @name to get its declaration, every assignment (SET, SELECT @v =, EXEC … OUTPUT), every use and every write to a physical table. One click takes you to the line.
For T-SQL stored procedures · SQL Server
Paste a procedure thousands of lines long and instantly see where each variable is declared, changed and used, and where each column's value comes from, step by step back to the source tables.
No sign-up · Nothing to install · Your SQL never leaves your browser · App interface in Spanish
dbo.SalesSummary.nNetTotaldbo.SalesSummary.nNetTotal ← R.nNetTotal#CustomerSummary.nNetTotal ← SUM(nAmount)#OrderLines.nAmount ← CASE WHEN C.cSegment = 'VIP' THEN D.nQty * D.nPrice * (1 - @nDiscount) …@nDiscount ← nPercentdbo.Promotions.nPercent · physical tableType @name to get its declaration, every assignment (SET, SELECT @v =, EXEC … OUTPUT), every use and every write to a physical table. One click takes you to the line.
Pick a column of the final INSERT and follow every calculation backwards through temp tables, UPDATEs, CTEs, subqueries and variables, down to the source tables or parameters.
See the whole path as a left-to-right diagram with zoom, full screen and highlighting of each node's upstream path.
Every assignment shows the condition it runs under, and TrackerSQL flags assignments that sit in alternative branches of the same IF.
Detects EXEC(@sql) and sp_executesql, lists variables used inside dynamic SQL text, and tells you which temp tables are only filled there.
Several scripts in tabs, notes anchored to your code that you can export, light and dark themes, a syntax-highlighting editor, and analysis in a fraction of a second even for procedures thousands of lines long.
Understands DECLARE, SET, INSERT … SELECT, INSERT … VALUES, SELECT INTO, UPDATE … FROM with aliases,
MERGE, CTEs, subqueries in FROM / JOIN / APPLY, SELECT *, temp tables and table variables.
Stored procedures often contain sensitive business logic. That is why TrackerSQL runs the whole analysis in your own browser: no server receives your code, there are no accounts, and nothing runs against your database.
Understand a procedure thousands of lines long that someone else wrote, in minutes.
Before changing a calculation, see what it depends on and in which branches it is assigned.
Explain where a report figure comes from, column by column, down to the source table.
Yes. You can use it without signing up or installing anything.
No. The analysis runs entirely in your browser. Your scripts are only stored in your browser's local storage.
No. TrackerSQL analyzes the text of the stored procedure; it never connects to a database or runs the SQL.
T-SQL, the dialect of Microsoft SQL Server and Azure SQL: DECLARE, SET, SELECT INTO, INSERT, UPDATE with aliases, MERGE, CTEs, subqueries, temp tables and table variables.
The app interface is currently in Spanish. The analysis works the same on any T-SQL code, whatever language your comments and names are in.
It is a heuristic analysis of the code: it shows where each assignment is and under which condition, but it does not evaluate IF/ELSE conditions or the contents of dynamic SQL, and a SELECT * over a physical table is matched by column name. Double-check critical results.