Debug Stored Procedures and Triggers

Set breakpoints, watch variables and table data

Using stored procedures can give you huge benefits, but debugging them can be a tedious job. With the help of Hopper, it becomes easier to use stored procedures and triggers as you can walk through the code step-by-step and see what's going on.

Welcome to Hopper, our Database Stored Routine Debugger tool named after the late Admiral Grace Hopper for popularizing the term "debugging".

Hopper is a standalone tool to debug database stored code, like Stored Procedures and Triggers. These routines normally run at the server, inside your database and cannot be debugged with your normal development tool.

Key Benefits

Stored Procedures, Functions and Triggers are often used during database development, however, Firebird, InterBase and MySQL don't provide a way to debug stored code in the database, running at the server, nor do they provide a programmers API to create one.

Hopper fills this gap by emulating the server side code at the client computer allowing you to step through your code statement by statement. This gives you the much needed insight in your code during development and bug fixing.

Step through your code and investigate what's going on

Set breakpoints with or without conditions

Hopper allows you to set breakpoints, places where the debugger should automatically stop executing code as soon as the given position is reached. Breakpoints can be conditional, so that they only break on a given condition.

Looking for a development tool as well as debugging?

Take a look at Database Workbench, our fully featured database development environment that includes stored code debugging, design, development and testing tools for multiple database systems.

Available Editions

Hopper is available for InterBase, Firebird and MySQL.

Hopper associated with Delphi permits me, at last, to debug the SQL script of stored procedure and continue debugging (in Delphi) while *stepping into* the Pascal code of UDFs called within the script.

It's a delightful experience, thank you Martijn.