Microsoft provides the Transact-SQL debugger within SQL Server Data Tools (SSDT) for Visual Studio. However, the documentation doesn't provide an API.
Best regards,
Cosmog
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".