In order to support the user when designing models or managing databases, pgModeler introduces a set of tools that can be helpful in these two jobs. In the case of modeling, we have features that facilitate the navigation throughout the model, a database model structure validator, a feature to fix corrupted model files, and many others.
In the database management field, the user counts with a reasonably featured tool that helps to explore database structures, create database objects from code snippets or typed SQL commands, and a data manager which is able to handle information held by tables and views. The available advanced tools in pgModeler are: model overview, magnifier tool, source code preview, model fix, model objects, operations history, model validation, objects ids swapping, object finder, model restoration, layers management, model changelog, SQL tool, object metadata handler, command-line interface, crash handler, and bug report. They will be completely detailed in the next subsections.