Using the online interface

The Diagrams page is the browser-based way to generate and explore diagrams - no install required. The public Demo works the same way, without needing an account.

1. Paste your SQL

Paste a CREATE PROCEDURE or ALTER PROCEDURE body into the text box and click Generate diagram. The result appears as two panes: the rendered flow diagram at the top, and your original source code, line-numbered, at the bottom.

2. Navigate between diagram and code

Click any node in the diagram to jump to and highlight the exact source lines it came from. Click a line in the code pane to highlight the corresponding node in the diagram and pan/zoom the view to bring it into focus. This works in both directions, so you can use whichever pane is more convenient for a given step.

3. Pan and zoom

Larger procedures produce larger diagrams. Scroll to zoom, drag to pan, and use the on-diagram controls in the corner to reset the view or zoom to fit. This is especially useful for procedures with several nested conditions, loops, or joined tables.

4. Reading the diagram

Rectangles represent a single statement (a SELECT, INSERT, UPDATE, DELETE, MERGE, or EXEC), labelled with the table or procedure name it acts on.
Diamonds represent a decision, such as an IF - with the TRUE/FALSE branches labelled with the actual comparison being made.
Circles mark the entry and exit points of loops.
Grouped boxes ("frames") appear around statements that reference more than one table (a JOIN, or a subquery), showing each table involved and the join relationships between them.

Generating diagrams with the CLI

To generate diagrams for a whole folder of stored procedures at once, install the bnl-diagrams CLI tool and run it from the command line. See the CLI guide for details.