To support the user when designing models or managing databases, pgModeler introduces a set of tools that can be helpful in these two tasks. In the case of modeling, we have features that facilitate navigation throughout the model, a model structure validator, a feature that fixes corrupted model files, and many others.

In the database management section, the user has a reasonably featured tool that helps to explore database structures, create database objects from code snippets or typed SQL commands, and a data handling dialog that can manage information held by tables and views. The available advanced tools in pgModeler are the model overview, magnifier tool, source code preview, model fix, model objects widget, operations history, model validation, objects IDs swapping, object search, model restoration, layers management, model changelog, SQL tool, object metadata handler, command-line interface, crash handler, and bug report. They will be fully detailed in the next subsections.