For T-SQL stored procedures · SQL Server

Track every variable and every column in your stored procedures

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

Lineage of dbo.SalesSummary.nNetTotal
  1. INSERT L37 dbo.SalesSummary.nNetTotal ← R.nNetTotal
  2. SELECT INTO L26 #CustomerSummary.nNetTotal ← SUM(nAmount)
  3. INSERT L19 #OrderLines.nAmount ← CASE WHEN C.cSegment = 'VIP' THEN D.nQty * D.nPrice * (1 - @nDiscount) …
  4. SELECT @ L13 @nDiscount ← nPercent
  5. Origin: dbo.Promotions.nPercent · physical table

What you can do with TrackerSQL

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.

Column lineage

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.

Interactive diagram

See the whole path as a left-to-right diagram with zoom, full screen and highlighting of each node's upstream path.

IF / ELSE context

Every assignment shows the condition it runs under, and TrackerSQL flags assignments that sit in alternative branches of the same IF.

Dynamic SQL in plain sight

Detects EXEC(@sql) and sp_executesql, lists variables used inside dynamic SQL text, and tells you which temp tables are only filled there.

Built for daily work

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.

How it works

  1. Paste your stored procedure into the editor. No database connection needed.
  2. Search for a variable or a column in the right panel. The analysis updates as you type.
  3. Walk the chain or the diagram and jump to any line with a click; assignments are highlighted in the editor.
Try it with the built-in example

Your SQL never leaves your browser

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.

Who it is for

Inheriting code

Understand a procedure thousands of lines long that someone else wrote, in minutes.

DBAs and developers

Before changing a calculation, see what it depends on and in which branches it is assigned.

Analysts and auditors

Explain where a report figure comes from, column by column, down to the source table.

Frequently asked questions

Is TrackerSQL free?

Yes. You can use it without signing up or installing anything.

Is my SQL sent to a server?

No. The analysis runs entirely in your browser. Your scripts are only stored in your browser's local storage.

Do I need to connect to my database?

No. TrackerSQL analyzes the text of the stored procedure; it never connects to a database or runs the SQL.

Which SQL dialect does it support?

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.

Is the app available in English?

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.

How accurate is the analysis?

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.

Understand your next stored procedure in minutes

Open TrackerSQL