Features

Contents

Database Management

Manage the unlimited number of servers and databases with minimum time and effort now. Forward the commands via SSH or HTTP tunneling or enable SSL to secure connection. Customize connections to simplify your work and get quick access to the databases: create host aliases, sort objects, set database colors, or use tabs to work with particular nodes.

Object Management

Get all objects under control and easily manage them from DB Explorer. Simplify work creating and editing tables and all their subobjects, views, stored functions and procedures, user-defined functions, scheduled events, and server objects with visual object editors. Quickly copy any object, view dependencies, and get the object script.

User Management

Get the full list of existing PostgreSQL users at hand, modify them, and assign privileges. All database objects grants are displayed as a grid so that you could easily filter them and grant or revoke privileges on database objects.

Compatibility

SQL Management Studio for PostgreSQL is compatible with PostgreSQL, Amazon RDS for PostgreSQL, Amazon Redshift, Azure Database for PostgreSQL, and fully supports Unicode and all the latest server features.

Database Designer

Design ER diagrams: create and edit objects, visually set the links between them, add virtual relations, comments, and customize the look with advanced style and color properties. When ready, the diagram is automatically implemented to the database by creating the appropriate objects. Create ER-diagrams from the existing databases with the Reverse Engineering function.

DB Compare and Sync

Compare and synchronize databases or selected objects on different servers or within the same server. Set filters on objects and properties to improve speed. Get a detailed representation of differences and modification scripts. Generate reports with database differences. Create scheduled tasks for routine operations.

PostgreSQL services

Run database maintenance tasks with easy-to-use wizards or schedule execution on a regular basis:

  • Backing up databases
  • Restoring databases
  • Analyzing tables
  • Vacuuming tables
  • Reindexing tables

Query Designer

Build complex queries with joins, conditions, and sub-queries in a visual mode without extended knowledge of SQL syntax. Add grouping, filtering, and sorting in the special area selecting fields and values. Use code completion, keyboard templates, procedure hints, and other useful features for manual editing of queries.

Execute Script

Edit and run large scripts from editor or file. Improve navigation on SQL code with statements explorer, customized formatting, and code folding. Include automatic execution of custom scripts into your tasks.

Code Completion

Simplify writing your code with the IntelliSense feature. There is no need to type table columns or other objects names - you can pick them up from the popup list. Information hints and parameters completion is also available.

Debugger

Improve code quality by debugging your code directly in the IDE. Minimize time on locating the errors with step-by-step execution, variables, watches, call stack, and breakpoints.

Data Generator

Generate test data for PostgreSQL tables without effort: set data range or add files with sample data, specify total rows count, preview data, and populate tables immediately or save a result script. Data integrity for linked tables is processed automatically. The use of masks, constraints, formulas and all data types are supported.

Report Designer

Create data reports in a few clicks with a user-friendly wizard and access them from the DB Explorer. Apply suggested display templates or set advanced options and detailed layouts with the specialized editor.

Database Documenter

Automatically generate database structure as a searchable HTML document or a PDF file. Just a few steps and you get documentation with all objects and properties in a customized view. Generated files can be saved in other different formats.

Change Management

Get the database under version control with an integrated change management tool. It will make the process of deploying changes and updates from development to testing and production environments easier and more controllable.

Import Data

Import data into tables from the 10 most popular formats: MS Excel, MS Word, XML, MS Access, PDF, TXT, CSV, and more. Follow the steps of the friendly wizard to set column correspondence, select between insert, update, delete modes and customize data format. Use generators, constants, increments, and replacements if needed. Create automated tasks.

Export Data

Export table, view, or query data to any of 20 popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF, and more. Simple wizard helps to select required fields, set advanced format properties for output data and file layout. Save time for routine operations with templates and command-line execution.

Migrate and Convert

Seamlessly convert databases from any ADO-compatible source to PostgreSQL databases. Migrate tables, select required fields and indices, views, data, customize each element if needed. Automate migration with the console utility.

Data Сompare and Synс

Compare table data between different servers or within the same one and quickly synchronize them. Select columns and records manually or automatically, view comparison results, generate differences reports. Edit the result synchronization script and execute it immediately or save it for future use. Create scheduled tasks to run synchronization automatically.

Server Log Parser

View and analyze PostgreSQL server logs in a simple way. Apply sorting, filtering, and grouping for better viewing. Load collected logs and export them directly from the program.

Server Status

Get real-time information on current connections and processes on the server, manage deadlocks and prepared transactions, and view server log files grouping them by level or time.