Intellij PL/pg SQL debugger
Debug PL/pg SQL in Intellij with Datbase Tool to speed up and improve productivity with PostgreSQL
Allow to debug a query from the console like you run it normally: inspect variables and set breakpoints
The pldbgapi extension must be enabled on the target database.
This plugin is in early stage of development.
Submit features => Production ready task list
Report a bug or a problem => Create an issue
Features
- Direct debug from a console
- Code inspection
- Basic variables
- Arrays(including array of composite)
- Breakpoints are persisted across sessions
Limitation
The standard pldbgapi does not send back composite variable, but you can put it in arrays to inspect them.
A modified extension is available in this repo, hope this can be integrated in the official extension soon.
At the moment indirect debugging is not supported but will be available soon.
Installation
-
Using IDE built-in plugin system:
Settings/Preferences > Plugins > Marketplace > Search for "idea-plpgdebugger" >
Install Plugin -
Manually:
Download the latest release and install it manually using
Settings/Preferences > Plugins > ⚙️ > Install plugin from disk...
Plugin based on the IntelliJ Platform Plugin Template.
