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:

  • Database management forms for Schema, Table, Index, Foreign key, Trigger, Rule, Sequence, Collation, Domain, Base type, Composite type, Enum type, Tablespace, Aggregate, Function, Foreign servers, Foreign data wrappers, Event triggers and Language objects with full parameters support
  • Assistants for Object information, Actions, Help and Documentation
  • Jump bar for quick objects selection and navigation
  • Task bar with multi-task monitoring support
  • Console message logging view
  • Syntax highlight and autocomplete with fuzzy search algorithm
  • Line numbering with selection highlight
  • Direct editing in the results view, query results explanation
  • Powerful Field editor with preview and HEX presentation of the data
  • Transaction based database updates
  • Code preview and content editing
and many more.

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

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.

  • Different syntax highlight colors for identifiers, double quoted identifiers, single quoted literals, dollar quoted literals, comments, keywords, numeric values, unicode, operators and other.
  • Autocomplete with fuzzy search algorithm, auto-quotation if needed, statement aliases detection, default table detection, recent autocomplete list maintenance, working statement highlight and more.
  • 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.
  • Constraint trigger option with referenced table FROM parameter support.
  • Trigger BEFORE, AFTER and INSTEAD OF type option.
  • For each ROW or STATEMENT.
  • Firing mode and the ability to enable / disable trigger.
  • INSERT, UPDATE, DELETE and TRUNCATE events support.
  • Specific columns selection for UPDATE event.
  • Trigger function selection and quoted string arguments specification.

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:

  • Domain schema (namespace), name, comment and default value.
  • Datatype specific settings, including type, collation, size, precision and scale, array dimensions.
  • Domain check constraints managements, including NOT NULL clause.

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.

Contact form

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.