PostgreSQL management, administration and development GUI for macOS
Created with passion and love

SEQUEL for PostgreSQL basic features and capabilities

SEQUEL for PostgreSQL is a professional DB administration and management tool, with extremely intuitive and feature rich GUI that makes it the best assistant tool for developers and admins. SEQUEL is lightweight, fast and powerful that it can significantly simplify the DB management process. For those who cannot live without a CLI, SEQUEL offers a powerful Query Editor with syntax highlight, autocomplete and a Console log view that is always visible, so you can monitor the communication with your databases. It also features:

SEQUEL allows you to have a direct database connection, or you can use the built-in SSH tunneling or SSL encryption of your connection.
SEQUEL for PostgreSQL supports all PostgreSQL Database servers starting from version 9.1 up to version 10.6

Connections, databases and objects navigation and management

Navigator (navigation panel) provides easy access to all connections, databases and objects. Every element of the database is sorted into a tree view and grouped by type and parent into a folder. The number of elements in a single folder is presented in a label. There is a contextual menu available for each node in the tree. It provides most common actions, which may be executed based on the current selection. The buttons above the tree are context sensitive too. They provide the following functions:

Tasks display, progress indicator and query cancelation

Taskbar presents all the necessary information about running tasks in a simple, multifunctional and elegant way. All the information for the running statements, object synchronisations or reloads, query execution statuses. Every aspect of any of the SEQUEL functions is visualised in the taskbar. The background color is changing when there is an active task present in the taskbar.

Taskbar components

Connection status

An icon, which visualises the current connection status with the database for the last task.

Task

Description of the current task. Provides information for each step of the execution.

Number of tasks

A button used for tasks switching and tasks number counting and listing.

Elapsed time

The time counter since current task start.

Cancelation

A button for query cancelation.

Error

A button for displaying the tasks error in a popover.

Management form tabs, relevant SQL Editor

The tabs for all management forms and the SQL Editor are presented here in the tabbar. Each tab has close button and an indicator for changes in the corresponding management form. For example if the comment of an index has been changed, the tab will show a small pencil on it's right side. In additional the SQL button will bring on focus or open the SQL Editor of the database to which current object belongs. If there are no tabs in the tabbar, the SQL button will open the SQL Editor for the database of the selected object (node) in the Navigator.

Database elements management forms

Workspace is the place where all the management and modification of the elements of the database is happening. There is a form for each of the supported database objects. It is with common interface and controls for reload / reset / sync and create / modify, with the exception for tables and view. For these elements the controls are provided via Action Assistant. Also here is the place for the SQL Editor.

Supported database elements

Schema (namespace)

Tablespace

Language

Table

View

Index

Rule

Trigger

Sequence

Collation

Domain

Enum datatype

Column

Check

Foreign key

Operations logging

Console space provides information for most of the operations like opening, modification or synchronisation of an object, connecting or disconnecting to a database or executing a query. The order of the events logging is ascending and based on time, which means that the most recent messages will appear at the top. There is a label with the number of lines in the console and a trash can button in the right side of the jumpbar. The button is clearing the console from all messages.

Quick connections, databases and objects navigation

Jumpbar gives quick access to all connections, databases and every object, by providing an ordered horizontal representation of the Navigator tree, following the parentheses. In such way one can quickly open an object with the same parent or be informed about belonging of the element in the current tab. In additional there is the line numbering label for the console and the trash can button, which clears all log messages.

Info, Documentation and Help, Action assistants

There are three assistants, which will provide you with useful information, context sensitive help and documentation and all actions you may execute for the current management form in the workspace and tab.

Info Assistant

Info assistant provides all available information for the current / selected object in the workspace. It's great not only for getting detailed information but for learning and understanding what is the system structure of PostgreSQL and how it works. For SQL editor here are all statement execution specific status parameters and time measurements. There is detailed information for all result columns, datatype, table / view relation, default value and more.

Help Assistant

Help assistant presents context sensitive help from the official PostgreSQL documentation. There is a toolbar with search, go forward and back functionalities too. In such way desired keywords may be found inside the current help document.

Action Assistant

Action assistant gives a list of all possible actions that may be performed in the context of the current / selected object in the Workspace.

SQL Editor

The SQL Editor has all the required features for fast query writing and execution. Many of these features are specific to SEQUEL and cannot be found anywhere else.

Multiple or current query execution. Execution of selection in the editor.

Multiple query results visualisation. Modify and edit directly in the result tabs.

Per result tab buttons for explain, cancel and preform of modification and code preview.

Field editor with data preview and hex viewer.

Safety switch - protects the result from unwanted modifications.

Ability to modify fields immediately or using transaction.

Favourite queries and history maintenance

Full result details with per column name, type, parent, category, default value and more.

Schema (namespace)

Schema (namespace) database element has a simple management form. Using it is possible to change the name, comment and the owner of the schema.

Tablespace

Tablespace management form can be used for modifying the name, location, comment of the tablespace and in additional two parameters / options. The parameters are:

seq_page_cost (floating point) - sets the planner's estimate of the cost of a disk page fetch that is part of a series of sequential fetches. The default is 1.0

random_page_cost (floating point) - sets the planner's estimate of the cost of a non-sequentially-fetched disk page. The default is 4.0.

The Info Assistant presents additional information regarding the size of the tablespace.

Language

Language management form defines and registers new procedural language by associating the language name with handler function(s) that are responsible for executing functions written in the language. The form modifies existing languages too. Supported parameters are name, comment, call, inline and validator handlers. The TRUSTED option can be used when language must not grant access to data that the user would not otherwise have.

Table

Table management form provides access to several basic table parameters like name, schema, comment, tablespace, fillfactor percentage, inheritance, system OID availability per row and the logged status of the table. In additional the management form interface is extended with information and tabs for the columns, indices, foreign keys, check, triggers and rules belonging to that table. Also the content of the table may be revised with the ability to perform modifications in the same way like in SQL Editor. Table specific actions may be found in Action Assistant.

Column

Column management is provided via a modal window. In additional to the basic column parameters, there are several specific checkboxes which can be used to determine r set the belonging of the column to primary or unique key, or to a normal index. Supported is also the management of the datatype, collation for collatable datatypes, array dimension, size, precision and scale for NUMERIC datatype, number of statistics details, default value, comment and more.

Index

All available index / key types may be modified using the index management form. It combines many basic and extended settings for primary key, unique key, exclusion, unique index and normal index. Available for modification are the following parameters:

Name, table, tablespace and comment

The type of the index

Condition for partial index predicate (if the index type allows it)

Access method specific parameters

Management of the included columns or expressions as keys of the index

Setting the index as default for CLUSTER operations

Foreign key

In foreign key management form are available settings, options and parameters, which provide easy and fast creation or modification of the key:

Foreign key name and comment.

On DELETE and UPDATE actions selection.

Matching type definition.

Deferrable and validated options.

Selection of the columns to include in the foreign key is easy and there is information for the datatype, which helps in foreign table columns selection.

Check

Check constraint management is provided via a modal window. The available for modification parameters are: check name, NO INHERIT and VALIDATED options, comment and an expression producing a Boolean result which new or updated rows must satisfy for an insert or update operation to succeed.

Trigger

Trigger management form provides access to many of PostgreSQL trigger settings, parameters and options. It also has support for constraint triggers with referenced table parameter. Changes may be performed for:

Trigger name, table or view and comment.

The boolean expression / condition that determines whether the trigger function will actually be executed.

Rule

All PostgreSQL rewrite object parameters are available for modification in the rule management form, including the ability to enable disable the rule itself.

Rule name, table or view and comment.

SQL conditional expression, returning BOOLEAN.

INSERT, UPDATE, DELETE and SELECT events support.

Firing mode specification.

INSTEAD and ALSO execution methods.

Rule action commands management.

View

View management form is extended with several additional tabs for columns, triggers and rules of the view. It also provides access to the content of the view. Supported parameters are:

View schema (namespace), name and comment.

Support for materialized views with management for tablespace and fillfactor percentage.

CHECK OPTION for control of automatically updatable views behaviour.

security_barrier (boolean) for row-level security.

Function

Functions may be managed in every possible way, provided by PostgreSQL server. In additional there is arguments generator, ability to execute and more:

Complete arguments management, including RETURN TABLE.

Parallelisation and volatility setup.

Run-time configuration parameters.

Transformation data types.

Aggregate

Aggregate management form provided direct access to all settings and parameters of an aggregate function. Some of the supported features are:

Complete arguments management support for both, normal and direct arguments.

Parallelisation setup.

Combine, serialise and deserialise functions.

Normal, ordered-set and hypothetical-set aggregates.

Sequence

Sequence management form provided direct access to internal counting variables and parameters of the generator. It also gives the ability to change all basic settings.

Sequence schema (namespace), name and comment.

Owning table and column.

Start, increment, minimum, maximum and next value.

CYCLE and CACHE sequence parameters.

Ability to create temporary sequences.

Collation

Collation management form provides access to all parameters of an existing collation or defines a new one using the specified operating system locale settings, or by copying from another.

Collation schema (namespace), name and comment.

LC_COLLATE and LC_CTYPE settings support.

Owner of the collation

Domain

The domain management form provides access to many parameters of an existing domain datatype, including the check constrains associated with it. Also using the form a new domain can be created. Supported parameters are:

Enum datatype

Enum datatype management form gives access to all parameters available. It may be used for modification of an existing enum or to create new one. It also supports label reordering by dropping and recreating the type.

Your question / comment has been successfully sent and we will get back to you soon! If you have any additional questions or need more information, please don't hesitate to ask.

About Us

SEQUEL TECH EOOD's main area of interest is designing database management software for macOS. SEQUEL for PostgreSQL is the first application of the series, since PostgreSQL is the preferred database for many, including SEQUEL TECH team.

Recent News

SEQUEL for PostgreSQL ver. 1.5 released. The main new features are full functions support, autocomplete prioritisation and Field Preview. Autocomplete has improved speed and algorithm efficiency too, alone with minor bugfixes.
10 January, 2017

SEQUEL for PostgreSQL ver. 1.4.1 released. Main new feature is support for aggregates. There are also many improvements and bug fixes.
16 December, 2016