There are a couple of things that I wish I can get straight out of the IDE and they are served via extensions at the moment which would be great if they were exposed as functionalities for postgreSQL installations that have the extensions installed:

1- Integration with pgplslql_check to show issues in function (If the current linter implementation is not going to be expanded upon), this will show errors or warning as you type or at function creation / alter time.

2- pgstatstatements & pgstatkcache so you can have the monitoring stats for queries and other aspects of the database health shown in finer details.

3- index_advisor or something similar

Others might also apply to provide better monitoring and validation of the database