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
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.
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.
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.
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.
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.
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 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 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 gives a list of all possible actions that may be performed in the context of the current / selected object in the Workspace.
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.
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 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.0random_page_cost
(floating point) - sets the planner's estimate of the cost of a non-sequentially-fetched disk page. The default is 4.0.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 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 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.
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:
CLUSTER
operationsIn foreign key management form are available settings, options and parameters, which provide easy and fast creation or modification of the key:
DELETE
and UPDATE
actions selection.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 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:
BEFORE
, AFTER
and INSTEAD OF
type option.ROW
or STATEMENT
.INSERT
, UPDATE
, DELETE
and TRUNCATE
events support.UPDATE
event.All PostgreSQL rewrite object parameters are available for modification in the rule management form, including the ability to enable disable the rule itself.
BOOLEAN
.INSERT
, UPDATE
, DELETE
and SELECT
events support.INSTEAD
and ALSO
execution methods.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:
CHECK OPTION
for control of automatically updatable views behaviour.security_barrier
(boolean) for row-level security.Functions may be managed in every possible way, provided by PostgreSQL server. In additional there is arguments generator, ability to execute and more:
RETURN TABLE
.Aggregate management form provided direct access to all settings and parameters of an aggregate function. Some of the supported features are:
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.
CYCLE
and CACHE
sequence parameters.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.
LC_COLLATE
and LC_CTYPE
settings support.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:
NOT NULL
clause.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.