PostgreSQL Debugger Support (Feature Request)

[vencislav78]

Hi,

I’ve been using DBCode as my main database tool and really like how well it fits into VS Code.

One feature I still miss from DBeaver is PL/pgSQL debugging.

PostgreSQL supports debugging through the plugin_debugger / pldbgapi extension, which is also used by tools such as DBeaver and pgAdmin. It would be great if DBCode could add support for this API and integrate the debugging experience with VS Code.

A useful first version could include:

• Right-click a function or procedure and select Debug
• Enter input parameter values
• Set breakpoints
• Step Into and Step Over
• Continue execution
• Inspect local variables
• View the call stack
• Add watch expressions
• Change variable values where supported

Ideally, this could use the standard VS Code Run and Debug interface, including the Variables, Watch, Call Stack, and Breakpoints panels.

Why / use case

I work with a lot of PostgreSQL functions and procedures, including older and more complex PL/pgSQL code. When troubleshooting execution flow, conditional logic, or intermediate variable values, logging with RAISE NOTICE is often not enough.

At the moment, I still need to open DBeaver specifically for this task. PostgreSQL debugging support would make it possible for me to use DBCode as a complete replacement for DBeaver in my daily work.

Additional context

Relevant implementations can be found in DBeaver and pgAdmin, both of which use PostgreSQL’s existing debugger extension rather than a completely separate debugging engine.

I’d be happy to test an early implementation and provide feedback.

[mikeburgh]

Yeah I had looked at this a while ago, vscode made the debugger very pluggable… the issue I hit was it's basically just Postgres I can make it work with… sql servers is closed and there were two approaches to Oracle, but both had problems.

Let me take another look, it might be worth at least getting it done for Postgres and plugging the others in if there ever becomes a pathway for it