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


  • Direct debug from a console
  • Code inspection
    • Basic variables
    • Arrays(including array of composite)
  • Breakpoints are persisted across sessions


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.


  • 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.


View Github