pgcli is a command-line PostgreSQL client with auto-completion and syntax colouring, built for quick interactive querying directly from the terminal. Features include:

• Context-aware suggestions that surface tables, columns or keywords as you type
• Fuzzy filter on history
• Syntax highlighting
• Multi-line editing
• Smart pager selection
• Auto switch to vertical output when a result exceeds terminal width
• Configurable row-limit prompt
• Primitive support for psql slash commands
• Optional warnings before destructive statements
• Rich configuration file for prompts and colours

pgModeler is an open-source, cross-platform database modeler designed specifically for PostgreSQL. Aiming to be a reference database design tool in the FOSS ecosystem for PostgreSQL, it offers a robust and feature-rich interface that enables efficient data modeling and rapid code deployment to servers. One of its standout features is reverse engineering, which allows users to generate visual representations of existing databases, making it easier to understand and modify complex structures. Additionally, pgModeler supports the generation of SQL scripts to synchronize a database model with an actual database through a process known as diff. Beyond its core modeling capabilities, the tool includes a minimalist yet functional database server administration module. This module enables users to execute SQL commands, browse databases, and handle data through a simple and intuitive user interface.