Инструменты для работы с postgresql под windows

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your
Oracle database, scan it automaticaly and extracts its structure or data, it then generates SQL scripts that you can
load into your PostgreSQL database.

Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate
some Oracle data into a PostgreSQL database. It is really easy to used and doesn’t need any Oracle database knowledge than
providing the parameters needed to connect to the Oracle database.

Web Application for Linux/Windows, requires Apache+PHP or Docker.

Abris Platform is an application development platform for creating Web-based front-ends for PostgreSQL databases. Can be used to quickly create applications with convenient forms via SQL declarative description.

Allows to create, alter and drop tables, views, foreign keys, triggers, login or group roles, RLS policies.

Can provide ready to use data visualization templates: detail forms, list forms, charts, tree view representations, maps.

Admin4 is a tool for server maintenance via several plugin modules, running on Windows, Mac OSX, Linux and many more platforms. Currently, plugins for BIND DNS, LDAP and PostgreSQL are included. It is designed as a framework, using Python for fast development of plugins and custom modifications.

AIPG is a high-performance utility for unloading PostgreSQL data.
AIPG enables to move data from PostgreSQL to any data repository in a fast, easy and smart way.

AIPG allows to:

• Unload PostgreSQL data to flat files, tape devices or named pipes.
• Create files for multiple targets, even if target files require different import or load file formats. AIPG supports multiple formats for output files (XML, JSON, Delimited, Non-delimited).
• Perform complete system migration from one PostgreSQL instance to another.
• Eliminate the need for specific data conversion applications. AIPG column function supports conversion to a wide range of data types with the SELECT statement.
• Employ powerful, easy-to-use, and familiar SELECT syntax to specify columns and rows to unload.
• Unload a PostgreSQL row sample with MAXROWS, SKIP, and INTERVAL keywords.

Visit our website for more information and to download a trial license: https://aipg.infotel.com/.

Build data entry forms using Airforms.

Lower software development costs by using Airforms instead of developing custom CRUD applications. Build forms using Airforms’s drag-and-drop interface. No coding skills necessary.

Airforms was built from the ground up to support relational databases. Joins and lookups, and query parameters including multi-valued and cascading parameters are supported.

Airforms also includes a graphical query builder, and tools for browsing database schema, relationships and data. An automatic database diagram generator is also included.

For more information visit Airforms — database form builder.

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python.

It allows an organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase.

Barman most wanted features include backup catalogs, retention policies, remote recovery, archiving and compression of WAL files and backups.

Barman is open source, and its code is distributed under GNU General Public License 3 terms.

For more information and downloads:

• Website
• Documentation
• Downloads

ByteDesigner is the emerging enterprise tool for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!

Its a powerful database design tool, with advanced SQL Editor, and support for all major RDBMS, that can design complex systems.

  Online documentation is found here: http://www.nipdata.com/faq/byte-designer-manual.html

Download a free version at: http://www.nipdata.com/demo

Severalnines’ ClusterControl platform helps deploy, monitor, manage and scale SQL and NoSQL open source databases. Automation and control of database infrastructure across mixed environments, usually the case in large enterprises, makes Severalnines the ideal polyglot persistence solution to support modern business mixed IT environments.

ClusterControl’s popularity provides full operational visibility and control for open source databases.

CopyCat Developer is a set of Delphi / C++Builder components providing customizable replication for PostgreSQL, Firebird, Interbase, Microsoft SQL Server, MySQL, NexusDB, SQLite and Oracle, including heterogeneous replication between different database types.

Cortex is the most sophisticated product in the market for highly automated migrations of Oracle databases to native PostgreSQL.
In fact, migrating the business logic and combining this with all its dependencies between the Data and Code Objects makes Cortex unique.
On average, Cortex is able to automatically migrate at least 80% of all the Oracle Code Objects to native PostgreSQL.
Because we believe in database freedom, we always migrate Oracle databases to native PostgreSQL to avoid any vendor lock-in and to deliver maximum freedom of deployment on-premise and/or in the Cloud.

Database structure modeling, generation and modification focused on PostgreSQL. Database Designer for PostgreSQL is an easy CASE tool with intuitive graphical interface allowing you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.

Database Lab Engine is an open-source (AGPLv3) technology that allows blazing-fast cloning of Postgres databases of any size in seconds. This helps solve many problems such as:

• help build dev/QA/staging environments involving full-size production-like databases,
• provide temporary full-size database clones for SQL query analysis optimization (see Joe bot),
• automatically verify database migrations (DB schema changes) and massive data operations to avoid downtime and performance bottlenecks.

As an example, cloning of 10 TiB PostgreSQL database can take just 2 seconds.

Links:

• Database Lab Engine repository, with the issue tracker
• Documentation
• Tutorial for Amazon RDS PostgreSQL users
• Tutorial for any PostgreSQL database
• Database Lab Engine configuration reference
• Resources (an interactive tutorial, case studies)

Database .NET is an innovative, powerful and intuitive multiple database
management tool, with it you can Browse objects, Design tables, Edit rows,
Export data and run Queries with a consistent interface.

Features:

• Browse Objects
• Table Editor
• Index Editor
• Data Editor
• SQL Editor
  • Multiple Query Tabs
  • Multiple Results
  • Find In Grid
• Data Visualization
• Database Diagram
• Generate scripts: DDL, INSERT
• Code Manager
• Connection Profile
• Connection Manager
• Export to CSV/XML/TXT/XLS/XLSX/SQL/HTM/JSON
• Print SQL statements and query results
• Unicode and MultiLingual Support
• … and much more.

Supported databases:

• PostgreSQL 8.x/9.x
• SQL Server 2000/2005/2008/2008R2/2012
• SQL Server CE 3.1/3.5/4.0 (*.sdf;*.*)
• SQL Server Express and LocalDB
• SQL Azure
• SQLite (*.db;*.db3;*.sqlite;*.*)
• MySQL
• Firebird Super/Classic/Embedded Server (*.gdb;*.fdb;*.*)
• Oracle
• IBM DB2
• IBM Informix
• Sybase ASE
• MS Access 97-2003 (*.mdb;*.mde;*.*)
• MS Access 2007-2013 (*.accdb;*.accde;*.*)
• MS Excel 97-2003 (*.xls;*.*)
• MS Excel 2007-2013 (*.xlsx;*.xlsm;*.xlsb;*.*)
• dBase IV (*.dbf)
• FoxPro (*.dbc)
• Data Sources (OLE DB) (*.udl;*.*)
• ODBC DSN (Data Source Name) (*.dsn;*.*)
• OData (Open Data Protocol)

Free, Portable, All-In-One, Easy to Use and Multi-language.

Supported Platforms: Windows All (x86/x64)

More Info: http://fishcodelib.com/Database.htm

Database Workbench is a complete database development environment offering you many features and helpful tools. The following database systems are supported: PostgreSQL, MySQL & MariaDB, SQL Server, Firebird, Oracle, NexusDB and InterBase.

It supports database specific and database agnostic visual design tools. With these tools, you can create a new database, even for multiple database systems from a single source, or generate a visual diagram from an existing database. Alternatively, you can design the database elsewhere and implement it using the visual editors or database script.

Via drag and drop editing, using SQL Insight, the Describe Companion and easy-to-use source code editors, you’ll be able to do your work in an efficient manner. Viewing object dependencies is easy and can be done in any object editor, as well as the database navigator.

A built-in Test Data Generator allows for volume testing.

The SQL Editor comes with a visual query plan analysis tool, query statistics and visual query builder, as well as an execution timer. All the tools you need to profile your database queries.

You can use it for debugging a stored procedure, function, trigger or package, as this is easy to do with the built in debugging tool.

Database Workbench is licenses in 3 different editions (Basic/Pro/Enterprise) and with a modular approach, you can purchase modules for each separate supported database.

DataFiller version 1.1.1

DataFiller generates random data from a database schema enriched with simple directives in SQL comments to drive eleven data generators which cover typical data types. Reasonable defaults are provided, especially based on key and type constraints, so that few directives should be necessary. The minimum setup is to specify the relative size of tables with directive mult so that the data generation can be scaled.

See the documentation or download. License is GPLv3.

Run with option —test=comics and look at the output for a didactic example.

Convert databases from MS Access to PostgreSQL/ Amazon RDS and vice versa rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

The tool provides the most efficient and easiest way of Access queries conversion to PostgreSQL views including the following types: simple queries of SELECT type, queries with MS Access standard functions (not including statistical with NZ prefix), crosstable queries. DBConvert for Access and PostgreSQL can convert SQL queries AUTOMATICALLY. No need to learn the differences in SQL dialects.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

DBConvert for Firebird & PostgreSQL is a robust cross-database migration and synchronization software that converts database structure and data between PostgreSQL, Firebird, and Interbase.

Use DBConvert and DBSync for Firebird and PostgreSQL to convert and synchronize data between the following databases in any direction:

• Firebird
• Interbase
• PostgreSQL
• Heroku Postgres
• Google Cloud SQL for PostgreSQL
• Amazon Aurora PostgreSQL
• Azure Database for PostgreSQL

DBConvert tools are useful for exporting an entire dataset from Firebird to PostgreSQL.

Or share some of your tables from the source database with the target database.

The type mapping matches Firebird data types with their closest Postgres equivalents.

Or, if you like, you can manually map data types for specific fields.

Convert databases between PostgreSQL, Amazon RDS , MS SQL Server and SQL Azure in any direction rapidly and reliably. Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 5-10 minutes to convert approximately 1 Million records.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Convert databases from MySQL to PostgreSQL/ Amazon RDS in any direction rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 3-5 minutes to convert approximately 1 Million records.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Convert databases from Oracle to PostgreSQL and vice versa rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 4-7 minutes to convert approximately 1 Million records in both directions.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

DBConvert Streams (DBS) is an event-driven data replication platform for database administrators who require zero downtime database migration and continuous data replication as workloads move to the clouds and more data needs to be transferred.

DBS source readers use Change Data Capture (CDC) technology to respond in real time to all data changes in a particular source table or the entire database.

Multiple instances of DBS target writers running in parallel speed up the whole process and improve overall performance.

DBConvert Streams can automatically convert DDL CREATE Table statements between MySQL and PostgreSQL. Thus, there is no need to worry about manual type conversion of MySQL and Postgres databases.

DBS Binaries are available for the following operating Systems and Architectures:

• Linux/ amd64,
• Linux/ arm64
• macOS/ amd64
• Windows/ amd64

Supported Databases:

• PostgreSQL,
• CockroachDB
• MySQL,
• MariaDB

It’s easy to install and run DBConvert Streams with the provided lightweight Docker containers and simple docker-compose configuration. So there is no need to scatter binaries and other artifacts around the host system.

DBConvert Studio is a robust cross-database migration and synchronization software that converts database structure and data between PostgreSQL and other database formats.
It combines mature, stable, battle-proven DBConvert and DBSync Cores with an improved modern UX design.

The following three scenarios of data migration are possible:

• Copy Data. The easiest way to copy data between various database types.
• Synchronization. One-way and Bidirectional synchronization scenarios help to keep databases in sync for all nodes.
• Data Distribution. A data distribution scenario helps to cover more complex cases where data from a source database is converted to multiple destinations.
  All database objects can be renamed during migration.

DBConvert Studio supports more than ten of the most popular on-premises databases, including

• PostgreSQL,
• SQL Server,
• MySQL,
• Oracle,
• Interbase,
• IBM DB2,
• and more.

DB Data Difftective is a utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly. Uses a native connection to PostgreSQL databases.

dbDeveloper is a visual development tool for exploration, creation and modification of multiple databases in a very easy way. It offers a variety of functions from development via tuning up to the deployment and data manipulation.

dbDeveloper supports most popular databases including PostgreSQL server. With the direct database connection and simple compact interface it can speed up your wark and make it more efficient. It is a great tool for every database developer but can also be very useful for administrators and for the end users thanks to its easy-to-use graphical interface.

Draw database diagrams easily with dbdiagram.io

• Write DSL code, get database diagram rendered immediately
• Export diagrams to SQL DDL and PDF
• Share with your colleagues and clients
• Import diagram from SQL dumps
• Use the popular DBML (database markup language)

Build a database wiki easily with dbdocs.io

• Write DBML code to represent your database structure
• Publish to dbdocs, and get a web-accessible wiki site for entire database
• Version control your database structure with Git

With dbdocs, you can:

• Explain complex schema with notes, references and relationships of each field.
• Easily hand over the project database structure in DBML for future maintenance.

dbForge Data Compare for PostgreSQL is a GUI tool for table data comparison and synchronization. This PostgreSQL compare tool helps to custom-tailor the detection of data differences between two PostgreSQL tables, and establish smart management, and safe deployment of table data inconsistencies. The PostgreSQL diff tool also delivers the generation of the PostgreSQL data synchronization scripts with multiple options to keep PostgreSQL data in sync.

Key Features:

• Save time comparing and synchronizing PostgreSQL database data.
• Generate SQL scripts to update one database with the contents of another.
• Copy lookup data from development databases to staging or production.
• Keep an accurate history of all previous PostgreSQL database records.
• Fix problems by restoring missing or damaged data to a single row.
• Automate synchronization tasks with help of command-line interface.
• Deploy to PostgreSQL from 9.5 to 13 as well as to Amazon Redshift.

dbForge Schema Compare for PostgreSQL is a tool for easy and effective comparison and deployment of Redshift database structure differences. The tool allows comparing two PostgreSQL database schemas, gives a comprehensive view of all differences in Amazon Redshift database schemas, and generates clear and accurate SQL synchronization scripts to update the database schemas.

Key features

• Diff and sync Redshift and PostgreSQL databases quickly and efficiently.
• Generate SQL scripts to update one database with the contents of another.
• Apply updates from development databases to staging or production.
• Sync tables between PostgreSQL and Redshift databases.
• Compare the structure of Amazon Redshift databases and fix the errors
• Migrate PostgreSQL schemas to Amazon Redshift
• Automate routine synchronization tasks with command-line interface

For more information and downloads:

• Website
• Documentation
• Download

dbForge Studio for PostgreSQL is a GUI client and universal tool for PostgreSQL database development and management. This PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface.

The PostgreSQL GUI frontend also provides functionality for PostgreSQL data reporting, data editing, data import and export, building pivot tables and master-detail relations.

Key Features:

• SQL Development Save your time and improve code quality when creating and editing queries with the following features: PostgreSQL Code Completion, SQL Code Formatting, SQL Syntax Check.

• Database Explorer — navigate through the object tree and find any PostgreSQL object you are interested in.

• Data Export / Import — support for 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios.

• Query Profiler — locate bottlenecks and tune the performance of slow SQL queries with neatly displayed profiling results.

• Data Reports and Analysis — provides powerful functionality for summarizing and filtering your data and then creating comprehensive and easy-to-read visual reports, allowing you to properly analyze it and share this information with others.

• Data Editor — manage settings of tables, сolor and format your rows and cells using a rich set of fonts and size.

• Pivot Table — advanced filtering, visual data presentation in a graph make your data easier to read, understand, and analyze.

• Master-Detail Browser — view data in related tables simultaneous for the express data analysis and locating specific records and logical errors in the database.

dbMigration .NET is a simple, easy and intuitive multiple database migration tool,
With it you can easily migrate schema and data between different databases without complicated procedure.
Supported databases: PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix,
HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro…etc.

Major features:

• Automatic column macthing
• SQL preview
• Filter source data
• Show target results
• Integrated with Database .NET
• BLOB type support
• Command-Line support

Free, All-In-One, Portable, and Single executable file.

Supported Platforms: Windows All (x86/x64)

More Info: http://fishcodelib.com/DBMigration.htm

DB Schema Difftective is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences, stored procedures, triggers and constraints between two databases. Generates PostgreSQL compatible alter database scripts.

Sync your data between MS Access and PostgreSQL/ Amazon RDS databases rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Synchronize PostgreSQL, Amazon RDS, MS SQL and SQL Azure databases in any direction rapidly and reliably! Operate with a whole database or select only needed dataset to proceed.

Update, Insert and Drop sync keep distributed databases in agreement.

Sync databases with identical or even with different structures! All customizations are organised on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Synchronize PostgreSQL, Amazon RDS and MySQL databases rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

As well, two PostgreSQL databases can be set up as source and destination.

Update, Insert and Drop sync allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Synchronize data between PostgreSQL, Amazon RDS and Oracle databases.
Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Sync databases with identical or even with different structures! All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

DBTransfer — versatile and fast database transfer tool

DBTransfer is a multi-platform Java tool that aims to replicate one database (JDBC or MS Access) to another (JDBC), using an one to one conversion..

It currently supports:

• PostgreSQL (tested)
• MSSQL (tested)
• MySQL/MariaDB/Percona (tested)
• Oracle (tested)
• DB2 (needs testing)
• Access (read only, tested).

With DBTransfer, you can:

• Copy data from one database type to another type. Example: you can migrate your MSSQL to PostgreSQL, without losing the structure, including not only the original schema, the constraints, and of course, the data it self, which is converted to respective data-type.
• Copy one database schema to another.
• Move data from one database to another.
• Compare two databases.

DbVisualizer is a feature rich, intuitive multi-database tool for developers, analysts and database administrators. With its easy-to-use and clean interface, DbVisualizer has proven to be one of the most cost effective database tools available, yet to mention that it runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. Supports many database systems including PostgreSQL.

Features:

• Free and Pro version available
• Runs on Windows, Linux, and macOS
• Flexible user interface in light and dark themes
• Simple navigation of database objects and their properties
• Visual rendering of primary/foreign keys
• Table data editing in spreadsheet
• Export and import database schema
• Query optimization with an explain plan feature
• Visual query builder using drag and drop
• Flexible SQL scripts execution with parameter support
• SQL formatting
• Command-line interface for headless execution

DeZign for Databases is an intuitive database design tool for database developers that can help you model, create and maintain PostgreSQL (and others) databases. It uses entity relationship diagrams to graphically design databases.

Our latest version also adds support for PostgreSQL data model comparisons. In additional to PostgreSQL 7, PostgreSQL 8 (including 8.1) is supported as well.

Invasive software composition platform for building business applications.

Domain model is declared using DSL based on Domain-Driven Design.
Postgres database is maintained from that model:

• tables, views, types, functions and other database objects are created, modified and recreated
• advanced migrations are supported: whenever possible data migration will be performed without data loss
• object oriented features are utilized: nested types as values, tables as entities, views as snowflakes and aggregates
• listen/notify for cache invalidation
• a lot of other boilerplate…

EMS Data Comparer for PostgreSQL is a powerful and easy-to-use tool for PostgreSQL data comparison and synchronization. Using this utility you can view all the differences in compared PostgreSQL tables and execute an automatically generated script to eliminate these differences. Flexible customization of the PostgreSQL comparison and synchronization process will enable you to select tables and fields for comparison, perform partial PostgreSQL data synchronization or data comparison for several tables at once and tune many other options to effectively compare PostgreSQL table data. Data Comparer for PostgreSQL includes a graphical wizard that will guide you through the PostgreSQL data comparison and synchronization process step by step, and a command-line utility for synchronizing PostgreSQL data in one-touch.

EMS Data Import for PostgreSQL is a powerful tool to import data to PostgreSQL tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination PostgreSQL data formats for the selected fields, commit options, number of records to skip, etc. Data Import for PostgreSQL includes a wizard, which allows you to set all the PostgreSQL import options for different files visually, and a command-line utility to execute import to PostgreSQL database in one-touch.

EMS Data Generator for PostgreSQL is an impressive tool for generating test data to PostgreSQL database tables with the possibility to save and edit scripts. The utility can help you to simulate the database production environment and allows you to populate several PostgreSQL database tables with test data simultaneously, define tables and fields for generating data, set value ranges, generate PostgreSQL char fields by mask, define lists of values manually or select them from SQL queries, set generation parameters for each field type and has many other features to generate PostgreSQL test data in a simple and direct way. Data Generator for PostgreSQL also provides a console application, which allows you to generate PostgreSQL test data in one-touch by using generation templates.

EMS Data Import for PostgreSQL is a powerful tool to import data to PostgreSQL tables from MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination PostgreSQL data formats for the selected fields, commit options, number of records to skip, etc. Data Import for PostgreSQL includes a wizard, which allows you to set all the PostgreSQL import options for different files visually, and a command-line utility to execute import to PostgreSQL database in one-touch.

EMS Data Pump for PostgreSQL is an excellent migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to PostgreSQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target PostgreSQL database and fully customize the import process. Data Pump for PostgreSQL has the ability to automate migration to PostgreSQL server task using the helpful console utility. With Data Pump for PostgreSQL database conversion and migration to PostgreSQL become as easy as possible!

EMS DB Comparer for PostgreSQL is an excellent tool for PostgreSQL database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to synchronize structure of PostgreSQL databases and eliminate all or selected differences. The program has the ability to automate PostgreSQL database schemas comparison and synchronization task using the helpful Console Application.

Having EMS DB Comparer for PostgreSQL you can work with several projects at once, define PostgreSQL comparison parameters, print difference reports, and alter modification scripts. Its user-friendly interface greatly simplifies discovering and eliminating differences in PostgreSQL database structure saving your time and therefore money.

EMS DB Extract for PostgreSQL is an impressive and easy-to-use tool for creating PostgreSQL database backups in a form of SQL scripts. This database script utility allows you to save metadata of all PostgreSQL database objects as well as PostgreSQL table data as database snapshot. DB Extract scripts PostgreSQL database objects in the correct order according to their dependencies. Flexible customization of the extract process enables you to select objects and data tables for PostgreSQL database dump and tune many other extract options. DB Extract for PostgreSQL includes a graphical wizard that will guide you through the PostgreSQL extract process step by step, and a command-line utility for creating PostgreSQL backups in one-touch.

EMS SQL Backup for PostgreSQL is an easy-to-use GUI tool to create backups for multiple PostgreSQL servers from a single console. You can use automatic backup tasks with advanced schedules and store them in local or remote folders or cloud storages. PRO, Standard and FREE versions available.

EMS SQL Management Studio for PostgreSQL is a complete solution for PostgreSQL database administration and development. With components that focus on all critical PostgreSQL database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering PostgreSQL databases, managing database schema and objects as well as for PostgreSQL database design, migration, extraction, PostgreSQL query building, data import, export and database comparison.

SQL Studio unites these database tools for PostgreSQL in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing PostgreSQL database administrators and PostgreSQL application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for PostgreSQL offers all essential PostgreSQL tools to make you more productive than ever before!

EMS SQL Manager for PostgreSQL is a high performance tool for PostgreSQL database administration and development. It works with any PostgreSQL versions up to the newest one and supports the latest PostgreSQL features including enumerated, text search, XML and UUID data types, PostgreSQL index key sorting order, arrays of composite types, and others. SQL Manager for PostgreSQL offers plenty of powerful database tools such as Visual Database Designer to create PostgreSQL database in few clicks, Visual Query Builder to build complicated PostgreSQL queries, powerful BLOB editor and many more useful features for efficient PostgreSQL administration. SQL Manager for PostgreSQL has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

EMS SQL Query for PostgreSQL is a useful tool that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual PostgreSQL query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to PostgreSQL databases, select tables and fields for a query to PostgreSQL server, set the selection criteria and much more. Using this query utility you can work with several PostgreSQL queries at once, edit query text in the powerful SQL editor, view the execution results in different modes, create PostgreSQL queries with unions and subqueries visually, build diagrams based on queries, view PostgreSQL query execution plans and perform any other operations you may need in your work with PostgreSQL database queries.

Entity Developer is a powerful ORM designer for ADO.NET Entity Framework, Entity Framework Core, NHibernate, LinqConnect, Telerik Data Access, and LINQ to SQL. It introduces new approaches for designing ORM models, boosts productivity, and facilitates the development of database applications.

Key Features

• Design your data access layer visually, via drag-n-drop, and then generate code automatically. Or simply generate a model from a database or vice versa in a couple of minutes.

• Automating data access layer generation helps you do less mistakes in your code.

• For Entity Framework v1 — v6 our designer offers much more design and code generation features than EDM designer.

• Seamless Visual Studio integration.

• Design Entity Framework Core models visually. Get model-first and database-first support with a lot of settings.

• Optimized work with large models.

IDE Compatibility

Entity Developer integrates with Visual Studio 2008, 2010, 2012, 2013, 2015, 2017 and 2019.

Learn more about Entity Developer features on Devart website.

ERBuilder Data Modeler allows to graphically design databases using Entity Relationship Diagrams to automatically generate the most popular SQL databases. Developers can view physical model structures to understand their databases, create new databases. ERBuilder is extremely easy to use and understand. It provides all the features you would expect from a professional database modeling and design tool.

Features

• Visual data modeling
• Creation of entities, attributes, relationships, views, domains, indexes, sequences, triggers and stored procedures
• Model checking
• Version management
• Generation of an SQL Data Definition Language (DDL) script
• Generation of databases
• Reverse engineering database
• Generation of navigable Database documentation
• Generation of Data Inserts

Enables you to transfer data between PostgreSQL and others database/file systems, e.g.: MySQL, Oracle, SQL Server, Microsoft Access/Excel, FireBIrd, SQLite, CSV etc.

With the step-by-step wizard GUI, everyone can easy transfer data from one to the others. Just select a data source and a target output format, ESF Database Convert can transfer table structure, data, indexes, primary keys, foreign keys and so on automation.

Also, this tool provides some advance options to custom converting process, e.g.: rename table/field name, change field data type/default value …

ETL Validator is a data testing tool that greatly simplifies the testing of Data Integration, Data Warehouse and Data Migration projects. It makes use of our patented ELV architecture to Extract, Load and Validate data from data sources such as databases, flat files, XML, Hadoop and Web Services. It has an inbuilt ETL engine capable of comparing millions of records.

ETL Validator uses PostgreSQL as the Repository & Workschema for storing the test cases and comparing the data.

Excel-to-PostgreSQL is a program to convert Microsoft Excel spreadsheets into PostgreSQL databases. Each worksheet becomes a table, each row becomes a record. Conversion performance is about 10,000 records per second on an average modern PC. Command line support allows automating, scripting and scheduling MS Excel to PostgreSQL conversion.

Features

• All versions of MS Excel are supported (including MS Excel 2016)
• All versions of PostgreSQL starting from v9.0 are supported
• Option to convert individual worksheets
• Option to merge MS Excel data into an existing PostgreSQL database
• Intelligent types mapping
• Stores conversion settings into profile
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

FoxPro-to-PostgreSQL is a program to migrate FoxPro databases to PostgreSQL server. Depending on your privileges on the target PostgreSQL server you can export DBF data into new database or overwrite the contents of an existing PostgreSQL database.

Features

• All formats of FoxPro data and MEMO files are supported
• All versions of PostgreSQL servers are supported
• Support for large .dbf files (4GB+)
• High performance due to direct connection to source and destination databases (the program does not use ODBC or any other middleware software)
• Option to merge DBF data into an existing PostgreSQL database
• All FoxPro code pages are supported
• Stores conversion settings into profile
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limbas is a flexible, free web-based database frontend based on PHP.
It includes functions like reporting, tabularys and base functions like DMS.
There are existing solutions for workflows, CRM, CMS, ticketsystems, webshop, product database, groupware, call center.

Create a webapp from an __existing database__ in 30 seconds!

Portofino is a free and open source web framework that helps developers create outstanding enterprise applications by addressing three specific needs: productivity, features and architecture.

Among its features: content management, CRUD, database connectivity, calendars, charts, security and easy customization using Groovy.

A wizard allows the developer to create a web application by connecting to an existing.database quickly and easily

Moon Modeler is an easy to use cross platform database modeling tool for PostgreSQL and other databases. It allows you to draw ER diagrams with nested JSON, reverse engineer existing database structures and generate SQL scripts.

Key features

• Database modeling
• Visualization of nested structures and JSON
• SQL script generation
• Reverse engineering
• Support for PostgreSQL specifics, modeling of composite types etc.
• GraphQL schema design

Moon Modeler is available for Windows, MacOS and Linux.

MSSQL-to-PostgreSQL is a program to migrate Microsoft SQL or SQL Azure databases to PostgreSQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of Microsoft SQL are supported (including SQL Azure)
• All versions of PostgreSQL are supported
• Tables, data, indexes, constraints, sequences and views are converted
• Option to merge and synchronize MS SQL data into an existing PostgreSQL database
• Option to filter data using SELECT-queries
• Command line support
• Stores conversion settings into profile
• Support for multibyte character sets
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert stored procedures, functions and triggers
• Demo version converts only 50 records per table
• Demo version does not convert views and foreign keys

Requirements

• PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run MSSQL-to-PostgreSQL from)
• Necessary privileges to write into the destination database

MSSQL-to-PostgreSQL Code Converter is a program to migrate stored procedures, functions and triggers from SQL Server to PostgreSQL.

Features

• Built-in functions are converted into PostgreSQL equivalents
• MS SQL types are mapped into PostgreSQL
• Intelligent handling of reserved words and identifiers
• Reading source code from live database or T-SQL script file
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Manual post-processing of the output code may be required
• Demo version converts only 5 stored procedures/functions

MySQL-to-PostgreSQL is a program to migrate PostgreSQL databases to MySQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of PostgreSQL are supported
• All versions of Unix and Windows MySQL are supported
• Fast conversion engine (about 10,000 records per second of average P-IV system)
• Option to merge PostgreSQL data into an existing MySQL database
• Option to convert individual tables
• Converts indexes with all necessary attributes
• Command line support
• Stores conversion settings into profile
• Support for multibyte character sets
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert foreign keys
• Does not convert views, stored procedures and triggers
• Demo version converts only 5 records per table

Requirements

• PostgreSQL environment (server or client components of PostgreSQL
  must be installed on the same machine where you run MySQL-to-PostgreSQL from)
• Necessary privileges to write into the destination database

Try before you buy

Still not sure the program fits your needs? Try free
demo version with limited features. It will allow you to convert only five records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results: http://www.convert-in.com/sql2pgs.htm

Navicat Data Modeler is a powerful and easy-to-use GUI tool for creating and manipulating PostgreSQL database models. It enables users to design PostgreSQL database structures, reverse engineer, forward engineer, generate SQL files and print models to files, etc.

Navicat Data Modeler is available on three platforms — Microsoft Windows, macOS and Linux. Here are some highlights of Navicat Data Modeler:

• Create and manipulate conceptual/logical/physical models.
• Support cloud databases like Amazon RDS, Amazon Redshift.
• Reverse engineer databases/schemas or tables/views to a model.
• Forward engineer a physical model to a SQL file or a database/schema.
• Create and edit table structures directly.

For details, please visit our website: https://www.navicat.com

Navicat™ is a powerful PostgreSQL database administration and development tool that are not only sophisticated enough for professional developers, but also easy to learn for new users. With an user-friendly GUI, Navicat™ lets you quickly and easily create, organize, access and share information in a secure and convenient way.

Navicat supports multiple PostgreSQL server connections which can be connected locally or remotely. Your remote PostgreSQL server can be running on Linux, Unix, Mac OS X or Windows platform.

NextTypes is a standards based information storage, processing and transmission system that integrates the characteristics of other systems such as databases, programming languages, communication protocols, file systems, document managers, operating systems, frameworks, file formats and hardware in a single tightly integrated system using a common data types system.

NextTypes uses PostgreSQL as its data store. Its advanced features as complete SQL support, transactional DDL, deferrable constraints, composite types and full-text search allow building a very complete data system with a high level of abstraction.

NextTypes is a relational/network/objects/files hybrid database system with high level SQL interface, extensive primitive types list, JSON/JSON-LD/XML/Smile/WebDAV/CalDAV/iCalendar/RSS data access, REST interface, customizable MVC architecture, optimistic concurrency control, HTML5/CSS3/SVG/Javascript responsive graphical interface, multilanguage, UTF-8 encoding, syntax highlighting or WYSIWYG editors, robots.txt and sitemap management, text extraction/fulltext search, document management, virus scanning, DoS/SQL injection/CSRF/XSS protection, passwords/X.509 certificates authentication, logging and backup system.

Nucleon Database Master is a modern, powerful, intuitive and easy to use database query, administration, and management software with a consistent and modern user interface. Database Master simplifies managing, monitoring, querying, editing, visualizing, designing relational and NoSQL DBMS.

Database Master allows you to execute extended SQL, JQL (NoSQL) and C# (LINQ) query scripts, provides all database objects such as tables, views, procedures, packages, columns, indexes, relationships (constraints), collections, triggers and other database objects.

Database Master supports more then 40 data sources including PostgreSQL.

Advanced multi-threaded PostgreSQL connection pooler and request router.

complete solution for PostgreSQL monitoring

Full operational data, collected automatically

Okmeter.io monitoring agent knows and collects thousands of real time Postgres metrics on it’s operation and functioning. It guarantees you will have everything need.

Dashboards & reports created by Postgres experts

Practical summaries and detailed views for every aspect of DB performance. You’ll see your DB through the eyes of professional DBAs.

Performance issues auto‑detection

Okmeter knows all potential problems with Postgres beforehand — common pitfalls, suboptimal settings. You’ll be prepared to all of them.

Detailed monitoring of all PostgresSQL subsystems

Query execution monitoring

Workload monitoring is the cornerstone of database performance analysis. You’ll know whenever a DB request generates overload on CPU or disks. Okmeter will show you exactly which one caused it.

Client connections monitoring

You’ll be aware which IPs created how many connections, and what states they are in. You’ll have a distinct understanding of how many transactions are actively executing queries, how many are idling, and whether some are waiting on locks.

Checkpointer & bgwriter monitoring

These are two crucial storage processes in Postgres that write changed data to disks. Its configuration not only defines disk IO load, but query processing times as well.

Autovacuum monitoring

Autovacuum is a critical Postgres process, designed to clean up unneeded data. It also updates query planner statistics and prevent data loss due to transaction ID wraparound. Be aware of autovacuum operation and its proper setup.

Replication monitoring

Postgresql streaming replications if widely used for fault tolerance and scaling, you wouldn’t want it to be in a bad condition. Okmeter will keep an eye to ensure it’s working well.

Hardware & OS monitoring

Internal Postgres operational metrics are not enough to get a full picture of what’s happening on the server. Okmeter has all the system metrics and monitors every process on the server. You’ll have preset dashboards and triggers on top of all that.

Learn more

About features or read detailed list of metrics

Oracle-to-PostgreSQL is a program to migrate Oracle databases to PostgreSQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of Oracle and PostgreSQL are supported
• Option to merge Oracle data into an existing PostgreSQL database
• Option to synchronize PostgreSQL database with Oracle data
• Option to filter data using SELECT-queries
• Converts foreign keys
• Option to convert individual tables
• Converts indexes with all necessary attributes
• Command line support
• Stores conversion settings into profile
• Support for multibyte character sets
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert views, stored procedures and triggers
• Demo version converts only 5 records per table and does not convert foreign keys

Requirements

• PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run Oracle-to-PostgreSQL from)
• Necessary privileges to write into the destination database

Open Source administration and management tools for the PostgreSQL database. Includes a graphical administration interface, an SQL query tool, a procedural code editor, ERD tool, Schema comparison, and much more.

pgAdmin is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases.

Runs as a desktop application on most common operating systems, or can be deployed as a multi-user web application on a server or in a container.

pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads.

Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security.

Major features include: multi-process backup and restore, local or remote operation, full/incremental/differential backups, backup resume, delta restore, asynchronous archiving, and much more.

PG Collector for PostgreSQL is a SQL script that gathers valuable database information and presents it in a consolidated HTML file which provides a convenient way to view and navigate between different sections of the report.

PG Collector is safe to run on production environments and does not create any database objects to produce the output.

NodeJS library to programmatically compare two different database, generate sql patches and migrate schema within a «team-based devops» migration strategy.

PostgreSQL Schema and Data compare.

CLI tool to make sql patches of differences between two database.

pgEdit is a high performance SQL editor and development environment designed specifically for PostgreSQL relational databases. pgEdit features include SQL syntax coloring, direct source code execution, PHP support, integrated documentation, and extensive customizable editing facilities.

pgEdit uses psql, the interactive terminal application included with every PostgreSQL installation. This makes it easy to develop with pgEdit and then transfer your work to any PostgreSQL installation for maintenance and production tasks.

pgEdit is a native application for both Macintosh and Windows. It does not use Java or require installation of external libraries. You have the option of using the version of psql included with pgEdit or a different version installed anywhere on your hard drive.

pgFormatter is a PostgreSQL SQL and PLPGSQL syntax beautifier that can work as a console program or as a CGI.

This SQL formatting/beautifier tool supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. May
works with any other databases too.

pgFormatter can work as a console program or as a CGI. It will automatically detect his environment and output as text or as HTML following the context. Keywords highlighting is only be available in CGI context.

On-line demo site at http://sqlformat.darold.net/

pgloader loads data from various sources into PostgreSQL. It can transform the data it reads on the fly and submit raw SQL before and after the loading. It uses the COPY PostgreSQL protocol to stream the data into the server, and manages errors by filling a pair of reject.dat and reject.log files.

Thanks to being able to load data directly from a database source, pgloader also supports from migrations from other productions to PostgreSQL. In this mode of operations, pgloader handles both the schema and data parts of the migration, in a single unmanned command, allowing to implement Continuous Migration.

Overview

pgMustard helps people quickly review PostgreSQL query plans (EXPLAIN ANALYZE output).

Key features

• Performance advice – scored by estimated time-saving potential
• Per-operation timings¹
• The number of rows¹ returned by each operation
• Timing bar – that pins to keep it in context
• Collapsible subtrees – with fast ones collapsed by default
• Descriptions of operations
• Links to blog posts for further reading

¹ Taking loops, threads, subplans, and CTEs into account.

Advice

The performance advice pgMustard can give includes:

• High index potential
• Poor index efficiency
• Operations on disk
• Poor row estimates
• Poor cache performance
• Excessive heap fetches
• Poor read efficiency (can be a sign of bloat)
• Lossy bitmap scans
• High index-only scan potential
• Late filters
• CTE scans used only once
• Slow counts
• Excessive planning time
• Trigger time dominated
• Poor read speed
• Scope for increased parallelism

Requirements

• JSON format query plans, from PostgreSQL 9.6 or newer
• The interface and advice are in English
• GitHub or Google authentication – no installation or database access required

Backup and Recovery tool for PostgreSQL databases.
Features :

Full HOT backups
Point-In-Time Recovery (PITR) by Date,Restore point and LSN
Provide a smart way to manage restore point
Manage Permanent or Temporary restore point (Prevent backups from deletion)
Optimize backup size by compression (libzip)
Remove indexes from the backup to reduce the backup size
Recreate indexes at recovery time
Granular restore at Database, Schema or Table level
Automatic WAL removal at backup time
Automatic Deletion of obsolete backups

PGSync is a middleware for syncing data from Postgres to Elasticsearch effortlessly. It allows you to keep Postgres as your source of truth data source and expose structured denormalized documents in Elasticsearch.

Changes to nested entities are propagated to Elasticsearch. PGSync’s advanced query builder then generates optimized SQL queries on the fly based on your schema. PGSync’s advisory model allows you to quickly move and transform large volumes of data quickly whilst maintaining relational integrity.

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies and hosting services.

Features

* Administer multiple servers
* Support for PostgreSQL 7.0.x, 7.1.x, 7.2.x, 7.3.x, 7.4.x, 8.0.x, 8.1.x, 8.2.x, 8.3.x
* Manage all aspects of:
      o Users & groups
      o Databases
      o Schemas
      o Tables, indexes, constraints, triggers, rules & privileges
      o Views, sequences & functions
      o Advanced objects
      o Reports
* Easy data manipulation:
      o Browse tables, views & reports
      o Execute arbitrary SQL
      o Select, insert, update and delete
* Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump
* Import SQL scripts, COPY data, XML, CSV and Tabbed
* Supports the Slony master-slave replication engine
* Excellent language support:
      o Available in 27 languages
      o No encoding conflicts. Edit Russian data using a Japanese interface!
* Easy to install and configure

Build professional web apps with little or no coding.

Build sophisticated web database applications to your customer’s exact needs with PHPRunner low-code platform. PHPRunner enables you to create robust, dynamic, and secure applications up to 20 times faster than traditional software coding.

Supports all versions of PostgreSQL.

More info

21-day trial version download

PostgresCompare automatically detects the changes made to your database schema and produces the SQL required to keep everything up to date. Increase visibility, reduce errors and save time deploying updates with Postgres Compare. Check it out at Postgres Compare

Postgres Enterprise Manager was designed for DBAs and large database installations. Its distributed architecture manages all your PostgreSQL instances on your in-house hardware, on-premise VMs, or in 3rd party cloud environments. Monitoring agents send host and Postgres data to a centralized enterprise management server that is accessible from multiple GUI Client consoles. Performance monitoring dashboards provide user customized metrics for your Server, Database, Memory, I/O, Storage, Object Activity, Operating System, and System Waits each with its own graphs, data, and accompanying alerts to exception conditions. The Capacity Manager answer questions like: How much storage will my database need six months from now?, How fast is my database growing?, What objects are responsible for the growth in my database?, Will my server be able to support another database instance?, Is the performance of my database getting better, staying the same, or getting worse? The SQL Profiler can trace and identify poorly-running SQL code in large and complex systems. You can then sort and filter the resulting statement statistics to quickly find your longest running SQL code and then optimize that code for better performance. You can even send the trace results to the Index Advisor and get index recommendations for any underlying tables to improve SQL response times. Finally, Enterprise Manager offers Postgres Expert, your DBA-in-a-box, to help enforce best practices for your database server configuration parameters, schemas, and security according to best practice guidelines written by the Postgres database specialists at EnterpriseDB.

PostgreSQL Database Modeler, or simply, pgModeler is an open source tool for modeling databases that merges the classical concepts of entity-relationship diagrams with specific features that only PostgreSQL implements. The pgModeler translates the models created by the user to SQL code and apply them onto database server (version 9.x).

PostgreSQL Data Wizard is a powerful Windows GUI utility for managing your PostgreSQL data.

PostgreSQL Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. PostgreSQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your PostgreSQL database, export data from PostgreSQL tables and queries to most popular formats, and import data into the tables.

PostgreSQL Maestro is a high-quality Windows GUI admin tool for PostgreSQL server management, control and development.

PostgreSQL Maestro allows you to create, edit, copy, extract and drop all the database objects such as schemas, tables, views, functions, domains, rules, sequences, languages, operators, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage PostgreSQL roles, users, groups and their privileges, and use a lot of other tools designed for the easiest and most efficient work with PostgreSQL Server.

PyGreSQL is an open-source Python module that interfaces to a PostgreSQL database. It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script.

Security scanner RedCheck is an easy-to-use and handy solution being a real godsend to assess protection maturity and manage information security.

In addition to other functionality, RedCheck allows to audit PostgreSQL configurations and contains security configuration for PostgreSQL.

A key feature of RedCheck is the work with OVALdb security information repository, which contains vulnerability definitions in the OVAL format, updates and other security content for PostgreSQL.

RHQ is an open source systems management solution that runs on PostgreSQL and which also features a plugin to manage and monitor PostgreSQL databases.

RHQ is written in Java and provides a central management UI plus a very flexible and extensible plugin architecture. This allows to easily extend RHQ to your specific needs.

RHQ is currently available in source form only.

SEQUEL

is actually a suite of applications designed to help database administrators, programmers, students or just anyone interested in SQL and DB management by giving a modern interface to interact with database servers. The application is utilising most innovative technologies and programming concepts in order to bring an easy to use tools for accomplishing daily tasks or design complex DB solutions. The main characteristics of SEQUEL are:

• Access to all database objects
• Extended information for every DB element
• Easily accessible documentation and help
• Innovative interface that helps work faster and gives instant access to most of the database elements parameters

Skyvia is a cloud service for data integration, management and backup. Using Skyvia, you can connect your PostgreSQL data both with cloud data sources (Salesforce, SugarCRM, Zoho CRM, Dynamics) and relational databases (SQL Server, MySQL, SQL Azure).

It provides quick and easy data integration with no coding, secure cloud data backup with one-click restore and online data management via SQL.

SQL Image Viewer allows you to retrieve, view, convert and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF.
It also allows you to export binary data, and recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2, GZ, RAR, ZIP, and has experimental support for DOC, PPT and XLS file types.

A command line version is also included to allow you to set up unattended scheduled exports of binary data.

SQLite-to-PostgreSQL is a tool to migrate SQLite databases to PostgreSQL or Heroku. The program has high performance due to direct connection to source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of Linux/Unix and Windows PostgreSQL servers are supported
• Option to customize resulting table structure
• Convert indexes and relationships between tables
• Stores conversion settings into profile
• Option to merge SQLite data into an existing PostgreSQL database
• Option to synchronize PostgreSQL database with SQLite data
• Support for Unicode
• Option to export SQLite database into PostgreSQL script file
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support

SQL Multi Select lets you run queries on multiple PostgreSQL databases in parallel, and consolidates the results in a single data set so you can quickly compares values from different databases.

For ad-hoc queries, simply select a pre-defined group of your servers, enter your query, and run it. This eliminates the tedious task of having to manually connect to each server, run the query, and trying to compare the results from different servers.

For regular queries or maintenance scripts, you can schedule your scripts to run periodically against your server group, and have the results automatically exported to text files. You then just need to review a single file to examine the results from 10 servers, 100 servers, or 1000s of servers.

Connect and manage MySQL, SQL Server, PostgreSQL, Sybase, and Oracle databases from your Android device.

SQLTool does NOT work with Oracle 11g. It will work with Oracle 10g and below.

Oracle, MySQL, Sybase, PostgreSQL, and SQL Server databases can be managed using the query editor or through a limited amount of built in shortcuts.

Features include:

• Export table row data to a CSV file
• Customize-able SQL queries using the query editor
• Full table listings of each database
• Quickly empty or drop tables from the SQL Server, MySQL, PostgreSQL, Sybase, or Oracle databases
• Blazing fast select, insert, and update database queries
• Different user interfaces for tablets and phones

Devart SSIS Data Flow Components for PostgreSQL allows you to integrate PostgreSQL data with other databases and cloud applications via SQL Server Integration Services (SSIS). They include optimized PostgreSQL Source, PostgreSQL Destination, and PostgreSQL Lookup components and provide their own PostgreSQL Connection Manager with lots of PostgreSQL-specific connectivity features.

With Devart SSIS Data Flow Components for PostgreSQL you can:

• quickly build SSIS-based integration solutions for PostgreSQL;

• automate PostgreSQL integration via SSIS Data Flow tasks;

• import and export CSV files to PostgreSQL;

• synchronize PostgreSQL with SQL Server or other data sources;

• and many more…

Supabase provides users with a managed PostgreSQL database that includes automated backups, a set of pre-installed extensions (PostGIS, pgaudit, plv8, plus many others), a visual table editor for non-technical users, a SQL editor, a REST API and Websocket API for building web applications. Supabase converts PostgreSQL into a full Back end as a Service experience, allowing users to set up a functional backend with a PostgreSQL database in less than 2 minutes.

Web interface for PostgreSQL.

Access your databases across the intranet/internet through a completely dynamic powerful Javascript/AJAX based web interface.

Some feature highlights:

• Powerful data navigation, one-click search, relationship navigation, filtering and more
• Database management, including database objects and tablespace management
• Graphical pgdump interface for import/export of individual database objects or entire databases
• Tabbed SQL editor with SQL auto-completion
• Favorites function for easy storing and sharing of SQL snippets and scripts
• Upload and download files directly to/from binary fields

Plus many more.

Toad Data Modeler enables developers, DBAs, and designers to create, maintain and document quality database designs and structures across various database platforms, including PostgreSQL 8.1, 8.2 and 8.3. Key features include entity relationship diagrams, reverse engineering, generation of SQL/DDL code, generation of HTML/RTF/PDF reports etc.

UI Bakery is a low code web app development platform that allows building internal tools on top of existing data sources in visual mode. Using UI Bakery it is possible to connect the platform to one or multiple PostgreSQL databases and build a UI that would display data from it, performs certain operations, and send it back to the database. The resulting app can then be published using a single click, and end-users can start using it upon invitation.

Besides PostgreSQL it is possible to use other data sources, like:

• other SQL and NoSQL databases
• REST APIs
• Spreadsheets
• etc.

This all makes UI Bakery a perfect tool when it’s required to quickly build an app that would allow non-technical users to make operations on some data without the risk that they break something in it.

Valentina Studio is a graphical front end for PostgreSQL with two versions: a free version which supports features offered only in paid for versions of competing products and a Pro version that adds advanced features.

Free Valentina Studio offers the following features:

• Natively available on macOS, Windows & Linux
• Feature rich, visual SQL Editor with powerful search functionality
• SQLDIFF
• Highly productive Data Editor
• Support for many data sources including PostgreSQL
• Visual Query Builder
• ODBC import
• Schema Editor with powerful visual diagramming features, Diagram Editor
• Report Viewer with printing, export to PDF and HTML (local reports and from Valentina Server)
• Forms Client for working with visual forms and MariaDB (locally and from Valentina Server)

Valentina Studio Pro offers additional features, including:

• Visual Report Designer, Report Objects Scripting
• Forward Engineering Diagramming
• Valentina Form Editor for User Interface Design
• Database Continuous Integration (CI) tools

Use the Valentina Studio FREE vs Valentina Studio PRO feature matrix to see which version is best for your needs or download to immediately evaluate.

Vertabelo is a visual database design tool available through a web browser. It supports the physical data modeling. Vertabelo offers SQL generation, team work support, public link to model, model versioning, and import/export in XML format.

WAL-G is an archival restoration tool for PostgreSQL(also for MySQL, MariaDB, SQL Server, FoundationDB, and MongoDB).

WaveMaker is a fast, easy way to build standards-based web apps for PostgreSQL. WaveMaker’s visual, WYSIWYG development studio enables visual development of web applications. In fact, the WaveMaker IDE was built using WaveMaker, so we eat our own dogfood. Available under an Apache license — join our 15,000 strong developer community at dev.wavemaker.com

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your
Oracle database, scan it automaticaly and extracts its structure or data, it then generates SQL scripts that you can
load into your PostgreSQL database.

Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate
some Oracle data into a PostgreSQL database. It is really easy to used and doesn’t need any Oracle database knowledge than
providing the parameters needed to connect to the Oracle database.

Web Application for Linux/Windows, requires Apache+PHP or Docker.

Abris Platform is an application development platform for creating Web-based front-ends for PostgreSQL databases. Can be used to quickly create applications with convenient forms via SQL declarative description.

Allows to create, alter and drop tables, views, foreign keys, triggers, login or group roles, RLS policies.

Can provide ready to use data visualization templates: detail forms, list forms, charts, tree view representations, maps.

Admin4 is a tool for server maintenance via several plugin modules, running on Windows, Mac OSX, Linux and many more platforms. Currently, plugins for BIND DNS, LDAP and PostgreSQL are included. It is designed as a framework, using Python for fast development of plugins and custom modifications.

AIPG is a high-performance utility for unloading PostgreSQL data.
AIPG enables to move data from PostgreSQL to any data repository in a fast, easy and smart way.

AIPG allows to:

• Unload PostgreSQL data to flat files, tape devices or named pipes.
• Create files for multiple targets, even if target files require different import or load file formats. AIPG supports multiple formats for output files (XML, JSON, Delimited, Non-delimited).
• Perform complete system migration from one PostgreSQL instance to another.
• Eliminate the need for specific data conversion applications. AIPG column function supports conversion to a wide range of data types with the SELECT statement.
• Employ powerful, easy-to-use, and familiar SELECT syntax to specify columns and rows to unload.
• Unload a PostgreSQL row sample with MAXROWS, SKIP, and INTERVAL keywords.

Visit our website for more information and to download a trial license: https://aipg.infotel.com/.

Build data entry forms using Airforms.

Lower software development costs by using Airforms instead of developing custom CRUD applications. Build forms using Airforms’s drag-and-drop interface. No coding skills necessary.

Airforms was built from the ground up to support relational databases. Joins and lookups, and query parameters including multi-valued and cascading parameters are supported.

Airforms also includes a graphical query builder, and tools for browsing database schema, relationships and data. An automatic database diagram generator is also included.

For more information visit Airforms — database form builder.

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python.

It allows an organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase.

Barman most wanted features include backup catalogs, retention policies, remote recovery, archiving and compression of WAL files and backups.

Barman is open source, and its code is distributed under GNU General Public License 3 terms.

For more information and downloads:

• Website
• Documentation
• Downloads

ByteDesigner is the emerging enterprise tool for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!

Its a powerful database design tool, with advanced SQL Editor, and support for all major RDBMS, that can design complex systems.

  Online documentation is found here: http://www.nipdata.com/faq/byte-designer-manual.html

Download a free version at: http://www.nipdata.com/demo

Severalnines’ ClusterControl platform helps deploy, monitor, manage and scale SQL and NoSQL open source databases. Automation and control of database infrastructure across mixed environments, usually the case in large enterprises, makes Severalnines the ideal polyglot persistence solution to support modern business mixed IT environments.

ClusterControl’s popularity provides full operational visibility and control for open source databases.

CopyCat Developer is a set of Delphi / C++Builder components providing customizable replication for PostgreSQL, Firebird, Interbase, Microsoft SQL Server, MySQL, NexusDB, SQLite and Oracle, including heterogeneous replication between different database types.

Cortex is the most sophisticated product in the market for highly automated migrations of Oracle databases to native PostgreSQL.
In fact, migrating the business logic and combining this with all its dependencies between the Data and Code Objects makes Cortex unique.
On average, Cortex is able to automatically migrate at least 80% of all the Oracle Code Objects to native PostgreSQL.
Because we believe in database freedom, we always migrate Oracle databases to native PostgreSQL to avoid any vendor lock-in and to deliver maximum freedom of deployment on-premise and/or in the Cloud.

Database structure modeling, generation and modification focused on PostgreSQL. Database Designer for PostgreSQL is an easy CASE tool with intuitive graphical interface allowing you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.

Database Lab Engine is an open-source (AGPLv3) technology that allows blazing-fast cloning of Postgres databases of any size in seconds. This helps solve many problems such as:

• help build dev/QA/staging environments involving full-size production-like databases,
• provide temporary full-size database clones for SQL query analysis optimization (see Joe bot),
• automatically verify database migrations (DB schema changes) and massive data operations to avoid downtime and performance bottlenecks.

As an example, cloning of 10 TiB PostgreSQL database can take just 2 seconds.

Links:

• Database Lab Engine repository, with the issue tracker
• Documentation
• Tutorial for Amazon RDS PostgreSQL users
• Tutorial for any PostgreSQL database
• Database Lab Engine configuration reference
• Resources (an interactive tutorial, case studies)

Database .NET is an innovative, powerful and intuitive multiple database
management tool, with it you can Browse objects, Design tables, Edit rows,
Export data and run Queries with a consistent interface.

Features:

• Browse Objects
• Table Editor
• Index Editor
• Data Editor
• SQL Editor
  • Multiple Query Tabs
  • Multiple Results
  • Find In Grid
• Data Visualization
• Database Diagram
• Generate scripts: DDL, INSERT
• Code Manager
• Connection Profile
• Connection Manager
• Export to CSV/XML/TXT/XLS/XLSX/SQL/HTM/JSON
• Print SQL statements and query results
• Unicode and MultiLingual Support
• … and much more.

Supported databases:

• PostgreSQL 8.x/9.x
• SQL Server 2000/2005/2008/2008R2/2012
• SQL Server CE 3.1/3.5/4.0 (*.sdf;*.*)
• SQL Server Express and LocalDB
• SQL Azure
• SQLite (*.db;*.db3;*.sqlite;*.*)
• MySQL
• Firebird Super/Classic/Embedded Server (*.gdb;*.fdb;*.*)
• Oracle
• IBM DB2
• IBM Informix
• Sybase ASE
• MS Access 97-2003 (*.mdb;*.mde;*.*)
• MS Access 2007-2013 (*.accdb;*.accde;*.*)
• MS Excel 97-2003 (*.xls;*.*)
• MS Excel 2007-2013 (*.xlsx;*.xlsm;*.xlsb;*.*)
• dBase IV (*.dbf)
• FoxPro (*.dbc)
• Data Sources (OLE DB) (*.udl;*.*)
• ODBC DSN (Data Source Name) (*.dsn;*.*)
• OData (Open Data Protocol)

Free, Portable, All-In-One, Easy to Use and Multi-language.

Supported Platforms: Windows All (x86/x64)

More Info: http://fishcodelib.com/Database.htm

Database Workbench is a complete database development environment offering you many features and helpful tools. The following database systems are supported: PostgreSQL, MySQL & MariaDB, SQL Server, Firebird, Oracle, NexusDB and InterBase.

It supports database specific and database agnostic visual design tools. With these tools, you can create a new database, even for multiple database systems from a single source, or generate a visual diagram from an existing database. Alternatively, you can design the database elsewhere and implement it using the visual editors or database script.

Via drag and drop editing, using SQL Insight, the Describe Companion and easy-to-use source code editors, you’ll be able to do your work in an efficient manner. Viewing object dependencies is easy and can be done in any object editor, as well as the database navigator.

A built-in Test Data Generator allows for volume testing.

The SQL Editor comes with a visual query plan analysis tool, query statistics and visual query builder, as well as an execution timer. All the tools you need to profile your database queries.

You can use it for debugging a stored procedure, function, trigger or package, as this is easy to do with the built in debugging tool.

Database Workbench is licenses in 3 different editions (Basic/Pro/Enterprise) and with a modular approach, you can purchase modules for each separate supported database.

DataFiller version 1.1.1

DataFiller generates random data from a database schema enriched with simple directives in SQL comments to drive eleven data generators which cover typical data types. Reasonable defaults are provided, especially based on key and type constraints, so that few directives should be necessary. The minimum setup is to specify the relative size of tables with directive mult so that the data generation can be scaled.

See the documentation or download. License is GPLv3.

Run with option —test=comics and look at the output for a didactic example.

Convert databases from MS Access to PostgreSQL/ Amazon RDS and vice versa rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

The tool provides the most efficient and easiest way of Access queries conversion to PostgreSQL views including the following types: simple queries of SELECT type, queries with MS Access standard functions (not including statistical with NZ prefix), crosstable queries. DBConvert for Access and PostgreSQL can convert SQL queries AUTOMATICALLY. No need to learn the differences in SQL dialects.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

DBConvert for Firebird & PostgreSQL is a robust cross-database migration and synchronization software that converts database structure and data between PostgreSQL, Firebird, and Interbase.

Use DBConvert and DBSync for Firebird and PostgreSQL to convert and synchronize data between the following databases in any direction:

• Firebird
• Interbase
• PostgreSQL
• Heroku Postgres
• Google Cloud SQL for PostgreSQL
• Amazon Aurora PostgreSQL
• Azure Database for PostgreSQL

DBConvert tools are useful for exporting an entire dataset from Firebird to PostgreSQL.

Or share some of your tables from the source database with the target database.

The type mapping matches Firebird data types with their closest Postgres equivalents.

Or, if you like, you can manually map data types for specific fields.

Convert databases between PostgreSQL, Amazon RDS , MS SQL Server and SQL Azure in any direction rapidly and reliably. Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 5-10 minutes to convert approximately 1 Million records.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Convert databases from MySQL to PostgreSQL/ Amazon RDS in any direction rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 3-5 minutes to convert approximately 1 Million records.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Convert databases from Oracle to PostgreSQL and vice versa rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 4-7 minutes to convert approximately 1 Million records in both directions.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

DBConvert Streams (DBS) is an event-driven data replication platform for database administrators who require zero downtime database migration and continuous data replication as workloads move to the clouds and more data needs to be transferred.

DBS source readers use Change Data Capture (CDC) technology to respond in real time to all data changes in a particular source table or the entire database.

Multiple instances of DBS target writers running in parallel speed up the whole process and improve overall performance.

DBConvert Streams can automatically convert DDL CREATE Table statements between MySQL and PostgreSQL. Thus, there is no need to worry about manual type conversion of MySQL and Postgres databases.

DBS Binaries are available for the following operating Systems and Architectures:

• Linux/ amd64,
• Linux/ arm64
• macOS/ amd64
• Windows/ amd64

Supported Databases:

• PostgreSQL,
• CockroachDB
• MySQL,
• MariaDB

It’s easy to install and run DBConvert Streams with the provided lightweight Docker containers and simple docker-compose configuration. So there is no need to scatter binaries and other artifacts around the host system.

DBConvert Studio is a robust cross-database migration and synchronization software that converts database structure and data between PostgreSQL and other database formats.
It combines mature, stable, battle-proven DBConvert and DBSync Cores with an improved modern UX design.

The following three scenarios of data migration are possible:

• Copy Data. The easiest way to copy data between various database types.
• Synchronization. One-way and Bidirectional synchronization scenarios help to keep databases in sync for all nodes.
• Data Distribution. A data distribution scenario helps to cover more complex cases where data from a source database is converted to multiple destinations.
  All database objects can be renamed during migration.

DBConvert Studio supports more than ten of the most popular on-premises databases, including

• PostgreSQL,
• SQL Server,
• MySQL,
• Oracle,
• Interbase,
• IBM DB2,
• and more.

DB Data Difftective is a utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly. Uses a native connection to PostgreSQL databases.

dbDeveloper is a visual development tool for exploration, creation and modification of multiple databases in a very easy way. It offers a variety of functions from development via tuning up to the deployment and data manipulation.

dbDeveloper supports most popular databases including PostgreSQL server. With the direct database connection and simple compact interface it can speed up your wark and make it more efficient. It is a great tool for every database developer but can also be very useful for administrators and for the end users thanks to its easy-to-use graphical interface.

Draw database diagrams easily with dbdiagram.io

• Write DSL code, get database diagram rendered immediately
• Export diagrams to SQL DDL and PDF
• Share with your colleagues and clients
• Import diagram from SQL dumps
• Use the popular DBML (database markup language)

Build a database wiki easily with dbdocs.io

• Write DBML code to represent your database structure
• Publish to dbdocs, and get a web-accessible wiki site for entire database
• Version control your database structure with Git

With dbdocs, you can:

• Explain complex schema with notes, references and relationships of each field.
• Easily hand over the project database structure in DBML for future maintenance.

dbForge Data Compare for PostgreSQL is a GUI tool for table data comparison and synchronization. This PostgreSQL compare tool helps to custom-tailor the detection of data differences between two PostgreSQL tables, and establish smart management, and safe deployment of table data inconsistencies. The PostgreSQL diff tool also delivers the generation of the PostgreSQL data synchronization scripts with multiple options to keep PostgreSQL data in sync.

Key Features:

• Save time comparing and synchronizing PostgreSQL database data.
• Generate SQL scripts to update one database with the contents of another.
• Copy lookup data from development databases to staging or production.
• Keep an accurate history of all previous PostgreSQL database records.
• Fix problems by restoring missing or damaged data to a single row.
• Automate synchronization tasks with help of command-line interface.
• Deploy to PostgreSQL from 9.5 to 13 as well as to Amazon Redshift.

dbForge Schema Compare for PostgreSQL is a tool for easy and effective comparison and deployment of Redshift database structure differences. The tool allows comparing two PostgreSQL database schemas, gives a comprehensive view of all differences in Amazon Redshift database schemas, and generates clear and accurate SQL synchronization scripts to update the database schemas.

Key features

• Diff and sync Redshift and PostgreSQL databases quickly and efficiently.
• Generate SQL scripts to update one database with the contents of another.
• Apply updates from development databases to staging or production.
• Sync tables between PostgreSQL and Redshift databases.
• Compare the structure of Amazon Redshift databases and fix the errors
• Migrate PostgreSQL schemas to Amazon Redshift
• Automate routine synchronization tasks with command-line interface

For more information and downloads:

• Website
• Documentation
• Download

dbForge Studio for PostgreSQL is a GUI client and universal tool for PostgreSQL database development and management. This PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface.

The PostgreSQL GUI frontend also provides functionality for PostgreSQL data reporting, data editing, data import and export, building pivot tables and master-detail relations.

Key Features:

• SQL Development Save your time and improve code quality when creating and editing queries with the following features: PostgreSQL Code Completion, SQL Code Formatting, SQL Syntax Check.

• Database Explorer — navigate through the object tree and find any PostgreSQL object you are interested in.

• Data Export / Import — support for 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios.

• Query Profiler — locate bottlenecks and tune the performance of slow SQL queries with neatly displayed profiling results.

• Data Reports and Analysis — provides powerful functionality for summarizing and filtering your data and then creating comprehensive and easy-to-read visual reports, allowing you to properly analyze it and share this information with others.

• Data Editor — manage settings of tables, сolor and format your rows and cells using a rich set of fonts and size.

• Pivot Table — advanced filtering, visual data presentation in a graph make your data easier to read, understand, and analyze.

• Master-Detail Browser — view data in related tables simultaneous for the express data analysis and locating specific records and logical errors in the database.

dbMigration .NET is a simple, easy and intuitive multiple database migration tool,
With it you can easily migrate schema and data between different databases without complicated procedure.
Supported databases: PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix,
HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro…etc.

Major features:

• Automatic column macthing
• SQL preview
• Filter source data
• Show target results
• Integrated with Database .NET
• BLOB type support
• Command-Line support

Free, All-In-One, Portable, and Single executable file.

Supported Platforms: Windows All (x86/x64)

More Info: http://fishcodelib.com/DBMigration.htm

DB Schema Difftective is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences, stored procedures, triggers and constraints between two databases. Generates PostgreSQL compatible alter database scripts.

Sync your data between MS Access and PostgreSQL/ Amazon RDS databases rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Synchronize PostgreSQL, Amazon RDS, MS SQL and SQL Azure databases in any direction rapidly and reliably! Operate with a whole database or select only needed dataset to proceed.

Update, Insert and Drop sync keep distributed databases in agreement.

Sync databases with identical or even with different structures! All customizations are organised on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Synchronize PostgreSQL, Amazon RDS and MySQL databases rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

As well, two PostgreSQL databases can be set up as source and destination.

Update, Insert and Drop sync allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Synchronize data between PostgreSQL, Amazon RDS and Oracle databases.
Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Sync databases with identical or even with different structures! All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

DBTransfer — versatile and fast database transfer tool

DBTransfer is a multi-platform Java tool that aims to replicate one database (JDBC or MS Access) to another (JDBC), using an one to one conversion..

It currently supports:

• PostgreSQL (tested)
• MSSQL (tested)
• MySQL/MariaDB/Percona (tested)
• Oracle (tested)
• DB2 (needs testing)
• Access (read only, tested).

With DBTransfer, you can:

• Copy data from one database type to another type. Example: you can migrate your MSSQL to PostgreSQL, without losing the structure, including not only the original schema, the constraints, and of course, the data it self, which is converted to respective data-type.
• Copy one database schema to another.
• Move data from one database to another.
• Compare two databases.

DbVisualizer is a feature rich, intuitive multi-database tool for developers, analysts and database administrators. With its easy-to-use and clean interface, DbVisualizer has proven to be one of the most cost effective database tools available, yet to mention that it runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. Supports many database systems including PostgreSQL.

Features:

• Free and Pro version available
• Runs on Windows, Linux, and macOS
• Flexible user interface in light and dark themes
• Simple navigation of database objects and their properties
• Visual rendering of primary/foreign keys
• Table data editing in spreadsheet
• Export and import database schema
• Query optimization with an explain plan feature
• Visual query builder using drag and drop
• Flexible SQL scripts execution with parameter support
• SQL formatting
• Command-line interface for headless execution

DeZign for Databases is an intuitive database design tool for database developers that can help you model, create and maintain PostgreSQL (and others) databases. It uses entity relationship diagrams to graphically design databases.

Our latest version also adds support for PostgreSQL data model comparisons. In additional to PostgreSQL 7, PostgreSQL 8 (including 8.1) is supported as well.

Invasive software composition platform for building business applications.

Domain model is declared using DSL based on Domain-Driven Design.
Postgres database is maintained from that model:

• tables, views, types, functions and other database objects are created, modified and recreated
• advanced migrations are supported: whenever possible data migration will be performed without data loss
• object oriented features are utilized: nested types as values, tables as entities, views as snowflakes and aggregates
• listen/notify for cache invalidation
• a lot of other boilerplate…

EMS Data Comparer for PostgreSQL is a powerful and easy-to-use tool for PostgreSQL data comparison and synchronization. Using this utility you can view all the differences in compared PostgreSQL tables and execute an automatically generated script to eliminate these differences. Flexible customization of the PostgreSQL comparison and synchronization process will enable you to select tables and fields for comparison, perform partial PostgreSQL data synchronization or data comparison for several tables at once and tune many other options to effectively compare PostgreSQL table data. Data Comparer for PostgreSQL includes a graphical wizard that will guide you through the PostgreSQL data comparison and synchronization process step by step, and a command-line utility for synchronizing PostgreSQL data in one-touch.

EMS Data Import for PostgreSQL is a powerful tool to import data to PostgreSQL tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination PostgreSQL data formats for the selected fields, commit options, number of records to skip, etc. Data Import for PostgreSQL includes a wizard, which allows you to set all the PostgreSQL import options for different files visually, and a command-line utility to execute import to PostgreSQL database in one-touch.

EMS Data Generator for PostgreSQL is an impressive tool for generating test data to PostgreSQL database tables with the possibility to save and edit scripts. The utility can help you to simulate the database production environment and allows you to populate several PostgreSQL database tables with test data simultaneously, define tables and fields for generating data, set value ranges, generate PostgreSQL char fields by mask, define lists of values manually or select them from SQL queries, set generation parameters for each field type and has many other features to generate PostgreSQL test data in a simple and direct way. Data Generator for PostgreSQL also provides a console application, which allows you to generate PostgreSQL test data in one-touch by using generation templates.

EMS Data Import for PostgreSQL is a powerful tool to import data to PostgreSQL tables from MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination PostgreSQL data formats for the selected fields, commit options, number of records to skip, etc. Data Import for PostgreSQL includes a wizard, which allows you to set all the PostgreSQL import options for different files visually, and a command-line utility to execute import to PostgreSQL database in one-touch.

EMS Data Pump for PostgreSQL is an excellent migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to PostgreSQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target PostgreSQL database and fully customize the import process. Data Pump for PostgreSQL has the ability to automate migration to PostgreSQL server task using the helpful console utility. With Data Pump for PostgreSQL database conversion and migration to PostgreSQL become as easy as possible!

EMS DB Comparer for PostgreSQL is an excellent tool for PostgreSQL database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to synchronize structure of PostgreSQL databases and eliminate all or selected differences. The program has the ability to automate PostgreSQL database schemas comparison and synchronization task using the helpful Console Application.

Having EMS DB Comparer for PostgreSQL you can work with several projects at once, define PostgreSQL comparison parameters, print difference reports, and alter modification scripts. Its user-friendly interface greatly simplifies discovering and eliminating differences in PostgreSQL database structure saving your time and therefore money.

EMS DB Extract for PostgreSQL is an impressive and easy-to-use tool for creating PostgreSQL database backups in a form of SQL scripts. This database script utility allows you to save metadata of all PostgreSQL database objects as well as PostgreSQL table data as database snapshot. DB Extract scripts PostgreSQL database objects in the correct order according to their dependencies. Flexible customization of the extract process enables you to select objects and data tables for PostgreSQL database dump and tune many other extract options. DB Extract for PostgreSQL includes a graphical wizard that will guide you through the PostgreSQL extract process step by step, and a command-line utility for creating PostgreSQL backups in one-touch.

EMS SQL Backup for PostgreSQL is an easy-to-use GUI tool to create backups for multiple PostgreSQL servers from a single console. You can use automatic backup tasks with advanced schedules and store them in local or remote folders or cloud storages. PRO, Standard and FREE versions available.

EMS SQL Management Studio for PostgreSQL is a complete solution for PostgreSQL database administration and development. With components that focus on all critical PostgreSQL database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering PostgreSQL databases, managing database schema and objects as well as for PostgreSQL database design, migration, extraction, PostgreSQL query building, data import, export and database comparison.

SQL Studio unites these database tools for PostgreSQL in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing PostgreSQL database administrators and PostgreSQL application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for PostgreSQL offers all essential PostgreSQL tools to make you more productive than ever before!

EMS SQL Manager for PostgreSQL is a high performance tool for PostgreSQL database administration and development. It works with any PostgreSQL versions up to the newest one and supports the latest PostgreSQL features including enumerated, text search, XML and UUID data types, PostgreSQL index key sorting order, arrays of composite types, and others. SQL Manager for PostgreSQL offers plenty of powerful database tools such as Visual Database Designer to create PostgreSQL database in few clicks, Visual Query Builder to build complicated PostgreSQL queries, powerful BLOB editor and many more useful features for efficient PostgreSQL administration. SQL Manager for PostgreSQL has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

EMS SQL Query for PostgreSQL is a useful tool that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual PostgreSQL query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to PostgreSQL databases, select tables and fields for a query to PostgreSQL server, set the selection criteria and much more. Using this query utility you can work with several PostgreSQL queries at once, edit query text in the powerful SQL editor, view the execution results in different modes, create PostgreSQL queries with unions and subqueries visually, build diagrams based on queries, view PostgreSQL query execution plans and perform any other operations you may need in your work with PostgreSQL database queries.

Entity Developer is a powerful ORM designer for ADO.NET Entity Framework, Entity Framework Core, NHibernate, LinqConnect, Telerik Data Access, and LINQ to SQL. It introduces new approaches for designing ORM models, boosts productivity, and facilitates the development of database applications.

Key Features

• Design your data access layer visually, via drag-n-drop, and then generate code automatically. Or simply generate a model from a database or vice versa in a couple of minutes.

• Automating data access layer generation helps you do less mistakes in your code.

• For Entity Framework v1 — v6 our designer offers much more design and code generation features than EDM designer.

• Seamless Visual Studio integration.

• Design Entity Framework Core models visually. Get model-first and database-first support with a lot of settings.

• Optimized work with large models.

IDE Compatibility

Entity Developer integrates with Visual Studio 2008, 2010, 2012, 2013, 2015, 2017 and 2019.

Learn more about Entity Developer features on Devart website.

ERBuilder Data Modeler allows to graphically design databases using Entity Relationship Diagrams to automatically generate the most popular SQL databases. Developers can view physical model structures to understand their databases, create new databases. ERBuilder is extremely easy to use and understand. It provides all the features you would expect from a professional database modeling and design tool.

Features

• Visual data modeling
• Creation of entities, attributes, relationships, views, domains, indexes, sequences, triggers and stored procedures
• Model checking
• Version management
• Generation of an SQL Data Definition Language (DDL) script
• Generation of databases
• Reverse engineering database
• Generation of navigable Database documentation
• Generation of Data Inserts

Enables you to transfer data between PostgreSQL and others database/file systems, e.g.: MySQL, Oracle, SQL Server, Microsoft Access/Excel, FireBIrd, SQLite, CSV etc.

With the step-by-step wizard GUI, everyone can easy transfer data from one to the others. Just select a data source and a target output format, ESF Database Convert can transfer table structure, data, indexes, primary keys, foreign keys and so on automation.

Also, this tool provides some advance options to custom converting process, e.g.: rename table/field name, change field data type/default value …

ETL Validator is a data testing tool that greatly simplifies the testing of Data Integration, Data Warehouse and Data Migration projects. It makes use of our patented ELV architecture to Extract, Load and Validate data from data sources such as databases, flat files, XML, Hadoop and Web Services. It has an inbuilt ETL engine capable of comparing millions of records.

ETL Validator uses PostgreSQL as the Repository & Workschema for storing the test cases and comparing the data.

Excel-to-PostgreSQL is a program to convert Microsoft Excel spreadsheets into PostgreSQL databases. Each worksheet becomes a table, each row becomes a record. Conversion performance is about 10,000 records per second on an average modern PC. Command line support allows automating, scripting and scheduling MS Excel to PostgreSQL conversion.

Features

• All versions of MS Excel are supported (including MS Excel 2016)
• All versions of PostgreSQL starting from v9.0 are supported
• Option to convert individual worksheets
• Option to merge MS Excel data into an existing PostgreSQL database
• Intelligent types mapping
• Stores conversion settings into profile
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

FoxPro-to-PostgreSQL is a program to migrate FoxPro databases to PostgreSQL server. Depending on your privileges on the target PostgreSQL server you can export DBF data into new database or overwrite the contents of an existing PostgreSQL database.

Features

• All formats of FoxPro data and MEMO files are supported
• All versions of PostgreSQL servers are supported
• Support for large .dbf files (4GB+)
• High performance due to direct connection to source and destination databases (the program does not use ODBC or any other middleware software)
• Option to merge DBF data into an existing PostgreSQL database
• All FoxPro code pages are supported
• Stores conversion settings into profile
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limbas is a flexible, free web-based database frontend based on PHP.
It includes functions like reporting, tabularys and base functions like DMS.
There are existing solutions for workflows, CRM, CMS, ticketsystems, webshop, product database, groupware, call center.

Create a webapp from an __existing database__ in 30 seconds!

Portofino is a free and open source web framework that helps developers create outstanding enterprise applications by addressing three specific needs: productivity, features and architecture.

Among its features: content management, CRUD, database connectivity, calendars, charts, security and easy customization using Groovy.

A wizard allows the developer to create a web application by connecting to an existing.database quickly and easily

Moon Modeler is an easy to use cross platform database modeling tool for PostgreSQL and other databases. It allows you to draw ER diagrams with nested JSON, reverse engineer existing database structures and generate SQL scripts.

Key features

• Database modeling
• Visualization of nested structures and JSON
• SQL script generation
• Reverse engineering
• Support for PostgreSQL specifics, modeling of composite types etc.
• GraphQL schema design

Moon Modeler is available for Windows, MacOS and Linux.

MSSQL-to-PostgreSQL is a program to migrate Microsoft SQL or SQL Azure databases to PostgreSQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of Microsoft SQL are supported (including SQL Azure)
• All versions of PostgreSQL are supported
• Tables, data, indexes, constraints, sequences and views are converted
• Option to merge and synchronize MS SQL data into an existing PostgreSQL database
• Option to filter data using SELECT-queries
• Command line support
• Stores conversion settings into profile
• Support for multibyte character sets
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert stored procedures, functions and triggers
• Demo version converts only 50 records per table
• Demo version does not convert views and foreign keys

Requirements

• PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run MSSQL-to-PostgreSQL from)
• Necessary privileges to write into the destination database

MSSQL-to-PostgreSQL Code Converter is a program to migrate stored procedures, functions and triggers from SQL Server to PostgreSQL.

Features

• Built-in functions are converted into PostgreSQL equivalents
• MS SQL types are mapped into PostgreSQL
• Intelligent handling of reserved words and identifiers
• Reading source code from live database or T-SQL script file
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Manual post-processing of the output code may be required
• Demo version converts only 5 stored procedures/functions

MySQL-to-PostgreSQL is a program to migrate PostgreSQL databases to MySQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of PostgreSQL are supported
• All versions of Unix and Windows MySQL are supported
• Fast conversion engine (about 10,000 records per second of average P-IV system)
• Option to merge PostgreSQL data into an existing MySQL database
• Option to convert individual tables
• Converts indexes with all necessary attributes
• Command line support
• Stores conversion settings into profile
• Support for multibyte character sets
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert foreign keys
• Does not convert views, stored procedures and triggers
• Demo version converts only 5 records per table

Requirements

• PostgreSQL environment (server or client components of PostgreSQL
  must be installed on the same machine where you run MySQL-to-PostgreSQL from)
• Necessary privileges to write into the destination database

Try before you buy

Still not sure the program fits your needs? Try free
demo version with limited features. It will allow you to convert only five records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results: http://www.convert-in.com/sql2pgs.htm

Navicat Data Modeler is a powerful and easy-to-use GUI tool for creating and manipulating PostgreSQL database models. It enables users to design PostgreSQL database structures, reverse engineer, forward engineer, generate SQL files and print models to files, etc.

Navicat Data Modeler is available on three platforms — Microsoft Windows, macOS and Linux. Here are some highlights of Navicat Data Modeler:

• Create and manipulate conceptual/logical/physical models.
• Support cloud databases like Amazon RDS, Amazon Redshift.
• Reverse engineer databases/schemas or tables/views to a model.
• Forward engineer a physical model to a SQL file or a database/schema.
• Create and edit table structures directly.

For details, please visit our website: https://www.navicat.com

Navicat™ is a powerful PostgreSQL database administration and development tool that are not only sophisticated enough for professional developers, but also easy to learn for new users. With an user-friendly GUI, Navicat™ lets you quickly and easily create, organize, access and share information in a secure and convenient way.

Navicat supports multiple PostgreSQL server connections which can be connected locally or remotely. Your remote PostgreSQL server can be running on Linux, Unix, Mac OS X or Windows platform.

NextTypes is a standards based information storage, processing and transmission system that integrates the characteristics of other systems such as databases, programming languages, communication protocols, file systems, document managers, operating systems, frameworks, file formats and hardware in a single tightly integrated system using a common data types system.

NextTypes uses PostgreSQL as its data store. Its advanced features as complete SQL support, transactional DDL, deferrable constraints, composite types and full-text search allow building a very complete data system with a high level of abstraction.

NextTypes is a relational/network/objects/files hybrid database system with high level SQL interface, extensive primitive types list, JSON/JSON-LD/XML/Smile/WebDAV/CalDAV/iCalendar/RSS data access, REST interface, customizable MVC architecture, optimistic concurrency control, HTML5/CSS3/SVG/Javascript responsive graphical interface, multilanguage, UTF-8 encoding, syntax highlighting or WYSIWYG editors, robots.txt and sitemap management, text extraction/fulltext search, document management, virus scanning, DoS/SQL injection/CSRF/XSS protection, passwords/X.509 certificates authentication, logging and backup system.

Nucleon Database Master is a modern, powerful, intuitive and easy to use database query, administration, and management software with a consistent and modern user interface. Database Master simplifies managing, monitoring, querying, editing, visualizing, designing relational and NoSQL DBMS.

Database Master allows you to execute extended SQL, JQL (NoSQL) and C# (LINQ) query scripts, provides all database objects such as tables, views, procedures, packages, columns, indexes, relationships (constraints), collections, triggers and other database objects.

Database Master supports more then 40 data sources including PostgreSQL.

Advanced multi-threaded PostgreSQL connection pooler and request router.

complete solution for PostgreSQL monitoring

Full operational data, collected automatically

Okmeter.io monitoring agent knows and collects thousands of real time Postgres metrics on it’s operation and functioning. It guarantees you will have everything need.

Dashboards & reports created by Postgres experts

Practical summaries and detailed views for every aspect of DB performance. You’ll see your DB through the eyes of professional DBAs.

Performance issues auto‑detection

Okmeter knows all potential problems with Postgres beforehand — common pitfalls, suboptimal settings. You’ll be prepared to all of them.

Detailed monitoring of all PostgresSQL subsystems

Query execution monitoring

Workload monitoring is the cornerstone of database performance analysis. You’ll know whenever a DB request generates overload on CPU or disks. Okmeter will show you exactly which one caused it.

Client connections monitoring

You’ll be aware which IPs created how many connections, and what states they are in. You’ll have a distinct understanding of how many transactions are actively executing queries, how many are idling, and whether some are waiting on locks.

Checkpointer & bgwriter monitoring

These are two crucial storage processes in Postgres that write changed data to disks. Its configuration not only defines disk IO load, but query processing times as well.

Autovacuum monitoring

Autovacuum is a critical Postgres process, designed to clean up unneeded data. It also updates query planner statistics and prevent data loss due to transaction ID wraparound. Be aware of autovacuum operation and its proper setup.

Replication monitoring

Postgresql streaming replications if widely used for fault tolerance and scaling, you wouldn’t want it to be in a bad condition. Okmeter will keep an eye to ensure it’s working well.

Hardware & OS monitoring

Internal Postgres operational metrics are not enough to get a full picture of what’s happening on the server. Okmeter has all the system metrics and monitors every process on the server. You’ll have preset dashboards and triggers on top of all that.

Learn more

About features or read detailed list of metrics

Oracle-to-PostgreSQL is a program to migrate Oracle databases to PostgreSQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of Oracle and PostgreSQL are supported
• Option to merge Oracle data into an existing PostgreSQL database
• Option to synchronize PostgreSQL database with Oracle data
• Option to filter data using SELECT-queries
• Converts foreign keys
• Option to convert individual tables
• Converts indexes with all necessary attributes
• Command line support
• Stores conversion settings into profile
• Support for multibyte character sets
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert views, stored procedures and triggers
• Demo version converts only 5 records per table and does not convert foreign keys

Requirements

• PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run Oracle-to-PostgreSQL from)
• Necessary privileges to write into the destination database

Open Source administration and management tools for the PostgreSQL database. Includes a graphical administration interface, an SQL query tool, a procedural code editor, ERD tool, Schema comparison, and much more.

pgAdmin is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases.

Runs as a desktop application on most common operating systems, or can be deployed as a multi-user web application on a server or in a container.

pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads.

Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security.

Major features include: multi-process backup and restore, local or remote operation, full/incremental/differential backups, backup resume, delta restore, asynchronous archiving, and much more.

PG Collector for PostgreSQL is a SQL script that gathers valuable database information and presents it in a consolidated HTML file which provides a convenient way to view and navigate between different sections of the report.

PG Collector is safe to run on production environments and does not create any database objects to produce the output.

NodeJS library to programmatically compare two different database, generate sql patches and migrate schema within a «team-based devops» migration strategy.

PostgreSQL Schema and Data compare.

CLI tool to make sql patches of differences between two database.

pgEdit is a high performance SQL editor and development environment designed specifically for PostgreSQL relational databases. pgEdit features include SQL syntax coloring, direct source code execution, PHP support, integrated documentation, and extensive customizable editing facilities.

pgEdit uses psql, the interactive terminal application included with every PostgreSQL installation. This makes it easy to develop with pgEdit and then transfer your work to any PostgreSQL installation for maintenance and production tasks.

pgEdit is a native application for both Macintosh and Windows. It does not use Java or require installation of external libraries. You have the option of using the version of psql included with pgEdit or a different version installed anywhere on your hard drive.

pgFormatter is a PostgreSQL SQL and PLPGSQL syntax beautifier that can work as a console program or as a CGI.

This SQL formatting/beautifier tool supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. May
works with any other databases too.

pgFormatter can work as a console program or as a CGI. It will automatically detect his environment and output as text or as HTML following the context. Keywords highlighting is only be available in CGI context.

On-line demo site at http://sqlformat.darold.net/

pgloader loads data from various sources into PostgreSQL. It can transform the data it reads on the fly and submit raw SQL before and after the loading. It uses the COPY PostgreSQL protocol to stream the data into the server, and manages errors by filling a pair of reject.dat and reject.log files.

Thanks to being able to load data directly from a database source, pgloader also supports from migrations from other productions to PostgreSQL. In this mode of operations, pgloader handles both the schema and data parts of the migration, in a single unmanned command, allowing to implement Continuous Migration.

Overview

pgMustard helps people quickly review PostgreSQL query plans (EXPLAIN ANALYZE output).

Key features

• Performance advice – scored by estimated time-saving potential
• Per-operation timings¹
• The number of rows¹ returned by each operation
• Timing bar – that pins to keep it in context
• Collapsible subtrees – with fast ones collapsed by default
• Descriptions of operations
• Links to blog posts for further reading

¹ Taking loops, threads, subplans, and CTEs into account.

Advice

The performance advice pgMustard can give includes:

• High index potential
• Poor index efficiency
• Operations on disk
• Poor row estimates
• Poor cache performance
• Excessive heap fetches
• Poor read efficiency (can be a sign of bloat)
• Lossy bitmap scans
• High index-only scan potential
• Late filters
• CTE scans used only once
• Slow counts
• Excessive planning time
• Trigger time dominated
• Poor read speed
• Scope for increased parallelism

Requirements

• JSON format query plans, from PostgreSQL 9.6 or newer
• The interface and advice are in English
• GitHub or Google authentication – no installation or database access required

Backup and Recovery tool for PostgreSQL databases.
Features :

Full HOT backups
Point-In-Time Recovery (PITR) by Date,Restore point and LSN
Provide a smart way to manage restore point
Manage Permanent or Temporary restore point (Prevent backups from deletion)
Optimize backup size by compression (libzip)
Remove indexes from the backup to reduce the backup size
Recreate indexes at recovery time
Granular restore at Database, Schema or Table level
Automatic WAL removal at backup time
Automatic Deletion of obsolete backups

PGSync is a middleware for syncing data from Postgres to Elasticsearch effortlessly. It allows you to keep Postgres as your source of truth data source and expose structured denormalized documents in Elasticsearch.

Changes to nested entities are propagated to Elasticsearch. PGSync’s advanced query builder then generates optimized SQL queries on the fly based on your schema. PGSync’s advisory model allows you to quickly move and transform large volumes of data quickly whilst maintaining relational integrity.

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies and hosting services.

Features

* Administer multiple servers
* Support for PostgreSQL 7.0.x, 7.1.x, 7.2.x, 7.3.x, 7.4.x, 8.0.x, 8.1.x, 8.2.x, 8.3.x
* Manage all aspects of:
      o Users & groups
      o Databases
      o Schemas
      o Tables, indexes, constraints, triggers, rules & privileges
      o Views, sequences & functions
      o Advanced objects
      o Reports
* Easy data manipulation:
      o Browse tables, views & reports
      o Execute arbitrary SQL
      o Select, insert, update and delete
* Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump
* Import SQL scripts, COPY data, XML, CSV and Tabbed
* Supports the Slony master-slave replication engine
* Excellent language support:
      o Available in 27 languages
      o No encoding conflicts. Edit Russian data using a Japanese interface!
* Easy to install and configure

Build professional web apps with little or no coding.

Build sophisticated web database applications to your customer’s exact needs with PHPRunner low-code platform. PHPRunner enables you to create robust, dynamic, and secure applications up to 20 times faster than traditional software coding.

Supports all versions of PostgreSQL.

More info

21-day trial version download

PostgresCompare automatically detects the changes made to your database schema and produces the SQL required to keep everything up to date. Increase visibility, reduce errors and save time deploying updates with Postgres Compare. Check it out at Postgres Compare

Postgres Enterprise Manager was designed for DBAs and large database installations. Its distributed architecture manages all your PostgreSQL instances on your in-house hardware, on-premise VMs, or in 3rd party cloud environments. Monitoring agents send host and Postgres data to a centralized enterprise management server that is accessible from multiple GUI Client consoles. Performance monitoring dashboards provide user customized metrics for your Server, Database, Memory, I/O, Storage, Object Activity, Operating System, and System Waits each with its own graphs, data, and accompanying alerts to exception conditions. The Capacity Manager answer questions like: How much storage will my database need six months from now?, How fast is my database growing?, What objects are responsible for the growth in my database?, Will my server be able to support another database instance?, Is the performance of my database getting better, staying the same, or getting worse? The SQL Profiler can trace and identify poorly-running SQL code in large and complex systems. You can then sort and filter the resulting statement statistics to quickly find your longest running SQL code and then optimize that code for better performance. You can even send the trace results to the Index Advisor and get index recommendations for any underlying tables to improve SQL response times. Finally, Enterprise Manager offers Postgres Expert, your DBA-in-a-box, to help enforce best practices for your database server configuration parameters, schemas, and security according to best practice guidelines written by the Postgres database specialists at EnterpriseDB.

PostgreSQL Database Modeler, or simply, pgModeler is an open source tool for modeling databases that merges the classical concepts of entity-relationship diagrams with specific features that only PostgreSQL implements. The pgModeler translates the models created by the user to SQL code and apply them onto database server (version 9.x).

PostgreSQL Data Wizard is a powerful Windows GUI utility for managing your PostgreSQL data.

PostgreSQL Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. PostgreSQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your PostgreSQL database, export data from PostgreSQL tables and queries to most popular formats, and import data into the tables.

PostgreSQL Maestro is a high-quality Windows GUI admin tool for PostgreSQL server management, control and development.

PostgreSQL Maestro allows you to create, edit, copy, extract and drop all the database objects such as schemas, tables, views, functions, domains, rules, sequences, languages, operators, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage PostgreSQL roles, users, groups and their privileges, and use a lot of other tools designed for the easiest and most efficient work with PostgreSQL Server.

PyGreSQL is an open-source Python module that interfaces to a PostgreSQL database. It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script.

Security scanner RedCheck is an easy-to-use and handy solution being a real godsend to assess protection maturity and manage information security.

In addition to other functionality, RedCheck allows to audit PostgreSQL configurations and contains security configuration for PostgreSQL.

A key feature of RedCheck is the work with OVALdb security information repository, which contains vulnerability definitions in the OVAL format, updates and other security content for PostgreSQL.

RHQ is an open source systems management solution that runs on PostgreSQL and which also features a plugin to manage and monitor PostgreSQL databases.

RHQ is written in Java and provides a central management UI plus a very flexible and extensible plugin architecture. This allows to easily extend RHQ to your specific needs.

RHQ is currently available in source form only.

SEQUEL

is actually a suite of applications designed to help database administrators, programmers, students or just anyone interested in SQL and DB management by giving a modern interface to interact with database servers. The application is utilising most innovative technologies and programming concepts in order to bring an easy to use tools for accomplishing daily tasks or design complex DB solutions. The main characteristics of SEQUEL are:

• Access to all database objects
• Extended information for every DB element
• Easily accessible documentation and help
• Innovative interface that helps work faster and gives instant access to most of the database elements parameters

Skyvia is a cloud service for data integration, management and backup. Using Skyvia, you can connect your PostgreSQL data both with cloud data sources (Salesforce, SugarCRM, Zoho CRM, Dynamics) and relational databases (SQL Server, MySQL, SQL Azure).

It provides quick and easy data integration with no coding, secure cloud data backup with one-click restore and online data management via SQL.

SQL Image Viewer allows you to retrieve, view, convert and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF.
It also allows you to export binary data, and recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2, GZ, RAR, ZIP, and has experimental support for DOC, PPT and XLS file types.

A command line version is also included to allow you to set up unattended scheduled exports of binary data.

SQLite-to-PostgreSQL is a tool to migrate SQLite databases to PostgreSQL or Heroku. The program has high performance due to direct connection to source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of Linux/Unix and Windows PostgreSQL servers are supported
• Option to customize resulting table structure
• Convert indexes and relationships between tables
• Stores conversion settings into profile
• Option to merge SQLite data into an existing PostgreSQL database
• Option to synchronize PostgreSQL database with SQLite data
• Support for Unicode
• Option to export SQLite database into PostgreSQL script file
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support

SQL Multi Select lets you run queries on multiple PostgreSQL databases in parallel, and consolidates the results in a single data set so you can quickly compares values from different databases.

For ad-hoc queries, simply select a pre-defined group of your servers, enter your query, and run it. This eliminates the tedious task of having to manually connect to each server, run the query, and trying to compare the results from different servers.

For regular queries or maintenance scripts, you can schedule your scripts to run periodically against your server group, and have the results automatically exported to text files. You then just need to review a single file to examine the results from 10 servers, 100 servers, or 1000s of servers.

Connect and manage MySQL, SQL Server, PostgreSQL, Sybase, and Oracle databases from your Android device.

SQLTool does NOT work with Oracle 11g. It will work with Oracle 10g and below.

Oracle, MySQL, Sybase, PostgreSQL, and SQL Server databases can be managed using the query editor or through a limited amount of built in shortcuts.

Features include:

• Export table row data to a CSV file
• Customize-able SQL queries using the query editor
• Full table listings of each database
• Quickly empty or drop tables from the SQL Server, MySQL, PostgreSQL, Sybase, or Oracle databases
• Blazing fast select, insert, and update database queries
• Different user interfaces for tablets and phones

Devart SSIS Data Flow Components for PostgreSQL allows you to integrate PostgreSQL data with other databases and cloud applications via SQL Server Integration Services (SSIS). They include optimized PostgreSQL Source, PostgreSQL Destination, and PostgreSQL Lookup components and provide their own PostgreSQL Connection Manager with lots of PostgreSQL-specific connectivity features.

With Devart SSIS Data Flow Components for PostgreSQL you can:

• quickly build SSIS-based integration solutions for PostgreSQL;

• automate PostgreSQL integration via SSIS Data Flow tasks;

• import and export CSV files to PostgreSQL;

• synchronize PostgreSQL with SQL Server or other data sources;

• and many more…

Supabase provides users with a managed PostgreSQL database that includes automated backups, a set of pre-installed extensions (PostGIS, pgaudit, plv8, plus many others), a visual table editor for non-technical users, a SQL editor, a REST API and Websocket API for building web applications. Supabase converts PostgreSQL into a full Back end as a Service experience, allowing users to set up a functional backend with a PostgreSQL database in less than 2 minutes.

Web interface for PostgreSQL.

Access your databases across the intranet/internet through a completely dynamic powerful Javascript/AJAX based web interface.

Some feature highlights:

• Powerful data navigation, one-click search, relationship navigation, filtering and more
• Database management, including database objects and tablespace management
• Graphical pgdump interface for import/export of individual database objects or entire databases
• Tabbed SQL editor with SQL auto-completion
• Favorites function for easy storing and sharing of SQL snippets and scripts
• Upload and download files directly to/from binary fields

Plus many more.

Toad Data Modeler enables developers, DBAs, and designers to create, maintain and document quality database designs and structures across various database platforms, including PostgreSQL 8.1, 8.2 and 8.3. Key features include entity relationship diagrams, reverse engineering, generation of SQL/DDL code, generation of HTML/RTF/PDF reports etc.

UI Bakery is a low code web app development platform that allows building internal tools on top of existing data sources in visual mode. Using UI Bakery it is possible to connect the platform to one or multiple PostgreSQL databases and build a UI that would display data from it, performs certain operations, and send it back to the database. The resulting app can then be published using a single click, and end-users can start using it upon invitation.

Besides PostgreSQL it is possible to use other data sources, like:

• other SQL and NoSQL databases
• REST APIs
• Spreadsheets
• etc.

This all makes UI Bakery a perfect tool when it’s required to quickly build an app that would allow non-technical users to make operations on some data without the risk that they break something in it.

Valentina Studio is a graphical front end for PostgreSQL with two versions: a free version which supports features offered only in paid for versions of competing products and a Pro version that adds advanced features.

Free Valentina Studio offers the following features:

• Natively available on macOS, Windows & Linux
• Feature rich, visual SQL Editor with powerful search functionality
• SQLDIFF
• Highly productive Data Editor
• Support for many data sources including PostgreSQL
• Visual Query Builder
• ODBC import
• Schema Editor with powerful visual diagramming features, Diagram Editor
• Report Viewer with printing, export to PDF and HTML (local reports and from Valentina Server)
• Forms Client for working with visual forms and MariaDB (locally and from Valentina Server)

Valentina Studio Pro offers additional features, including:

• Visual Report Designer, Report Objects Scripting
• Forward Engineering Diagramming
• Valentina Form Editor for User Interface Design
• Database Continuous Integration (CI) tools

Use the Valentina Studio FREE vs Valentina Studio PRO feature matrix to see which version is best for your needs or download to immediately evaluate.

Vertabelo is a visual database design tool available through a web browser. It supports the physical data modeling. Vertabelo offers SQL generation, team work support, public link to model, model versioning, and import/export in XML format.

WAL-G is an archival restoration tool for PostgreSQL(also for MySQL, MariaDB, SQL Server, FoundationDB, and MongoDB).

WaveMaker is a fast, easy way to build standards-based web apps for PostgreSQL. WaveMaker’s visual, WYSIWYG development studio enables visual development of web applications. In fact, the WaveMaker IDE was built using WaveMaker, so we eat our own dogfood. Available under an Apache license — join our 15,000 strong developer community at dev.wavemaker.com

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your
Oracle database, scan it automaticaly and extracts its structure or data, it then generates SQL scripts that you can
load into your PostgreSQL database.

Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate
some Oracle data into a PostgreSQL database. It is really easy to used and doesn’t need any Oracle database knowledge than
providing the parameters needed to connect to the Oracle database.

Web Application for Linux/Windows, requires Apache+PHP or Docker.

Abris Platform is an application development platform for creating Web-based front-ends for PostgreSQL databases. Can be used to quickly create applications with convenient forms via SQL declarative description.

Allows to create, alter and drop tables, views, foreign keys, triggers, login or group roles, RLS policies.

Can provide ready to use data visualization templates: detail forms, list forms, charts, tree view representations, maps.

Admin4 is a tool for server maintenance via several plugin modules, running on Windows, Mac OSX, Linux and many more platforms. Currently, plugins for BIND DNS, LDAP and PostgreSQL are included. It is designed as a framework, using Python for fast development of plugins and custom modifications.

AIPG is a high-performance utility for unloading PostgreSQL data.
AIPG enables to move data from PostgreSQL to any data repository in a fast, easy and smart way.

AIPG allows to:

• Unload PostgreSQL data to flat files, tape devices or named pipes.
• Create files for multiple targets, even if target files require different import or load file formats. AIPG supports multiple formats for output files (XML, JSON, Delimited, Non-delimited).
• Perform complete system migration from one PostgreSQL instance to another.
• Eliminate the need for specific data conversion applications. AIPG column function supports conversion to a wide range of data types with the SELECT statement.
• Employ powerful, easy-to-use, and familiar SELECT syntax to specify columns and rows to unload.
• Unload a PostgreSQL row sample with MAXROWS, SKIP, and INTERVAL keywords.

Visit our website for more information and to download a trial license: https://aipg.infotel.com/.

Build data entry forms using Airforms.

Lower software development costs by using Airforms instead of developing custom CRUD applications. Build forms using Airforms’s drag-and-drop interface. No coding skills necessary.

Airforms was built from the ground up to support relational databases. Joins and lookups, and query parameters including multi-valued and cascading parameters are supported.

Airforms also includes a graphical query builder, and tools for browsing database schema, relationships and data. An automatic database diagram generator is also included.

For more information visit Airforms — database form builder.

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python.

It allows an organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase.

Barman most wanted features include backup catalogs, retention policies, remote recovery, archiving and compression of WAL files and backups.

Barman is open source, and its code is distributed under GNU General Public License 3 terms.

For more information and downloads:

• Website
• Documentation
• Downloads

ByteDesigner is the emerging enterprise tool for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!

Its a powerful database design tool, with advanced SQL Editor, and support for all major RDBMS, that can design complex systems.

  Online documentation is found here: http://www.nipdata.com/faq/byte-designer-manual.html

Download a free version at: http://www.nipdata.com/demo

Severalnines’ ClusterControl platform helps deploy, monitor, manage and scale SQL and NoSQL open source databases. Automation and control of database infrastructure across mixed environments, usually the case in large enterprises, makes Severalnines the ideal polyglot persistence solution to support modern business mixed IT environments.

ClusterControl’s popularity provides full operational visibility and control for open source databases.

CopyCat Developer is a set of Delphi / C++Builder components providing customizable replication for PostgreSQL, Firebird, Interbase, Microsoft SQL Server, MySQL, NexusDB, SQLite and Oracle, including heterogeneous replication between different database types.

Cortex is the most sophisticated product in the market for highly automated migrations of Oracle databases to native PostgreSQL.
In fact, migrating the business logic and combining this with all its dependencies between the Data and Code Objects makes Cortex unique.
On average, Cortex is able to automatically migrate at least 80% of all the Oracle Code Objects to native PostgreSQL.
Because we believe in database freedom, we always migrate Oracle databases to native PostgreSQL to avoid any vendor lock-in and to deliver maximum freedom of deployment on-premise and/or in the Cloud.

Database structure modeling, generation and modification focused on PostgreSQL. Database Designer for PostgreSQL is an easy CASE tool with intuitive graphical interface allowing you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.

Database Lab Engine is an open-source (AGPLv3) technology that allows blazing-fast cloning of Postgres databases of any size in seconds. This helps solve many problems such as:

• help build dev/QA/staging environments involving full-size production-like databases,
• provide temporary full-size database clones for SQL query analysis optimization (see Joe bot),
• automatically verify database migrations (DB schema changes) and massive data operations to avoid downtime and performance bottlenecks.

As an example, cloning of 10 TiB PostgreSQL database can take just 2 seconds.

Links:

• Database Lab Engine repository, with the issue tracker
• Documentation
• Tutorial for Amazon RDS PostgreSQL users
• Tutorial for any PostgreSQL database
• Database Lab Engine configuration reference
• Resources (an interactive tutorial, case studies)

Database .NET is an innovative, powerful and intuitive multiple database
management tool, with it you can Browse objects, Design tables, Edit rows,
Export data and run Queries with a consistent interface.

Features:

• Browse Objects
• Table Editor
• Index Editor
• Data Editor
• SQL Editor
  • Multiple Query Tabs
  • Multiple Results
  • Find In Grid
• Data Visualization
• Database Diagram
• Generate scripts: DDL, INSERT
• Code Manager
• Connection Profile
• Connection Manager
• Export to CSV/XML/TXT/XLS/XLSX/SQL/HTM/JSON
• Print SQL statements and query results
• Unicode and MultiLingual Support
• … and much more.

Supported databases:

• PostgreSQL 8.x/9.x
• SQL Server 2000/2005/2008/2008R2/2012
• SQL Server CE 3.1/3.5/4.0 (*.sdf;*.*)
• SQL Server Express and LocalDB
• SQL Azure
• SQLite (*.db;*.db3;*.sqlite;*.*)
• MySQL
• Firebird Super/Classic/Embedded Server (*.gdb;*.fdb;*.*)
• Oracle
• IBM DB2
• IBM Informix
• Sybase ASE
• MS Access 97-2003 (*.mdb;*.mde;*.*)
• MS Access 2007-2013 (*.accdb;*.accde;*.*)
• MS Excel 97-2003 (*.xls;*.*)
• MS Excel 2007-2013 (*.xlsx;*.xlsm;*.xlsb;*.*)
• dBase IV (*.dbf)
• FoxPro (*.dbc)
• Data Sources (OLE DB) (*.udl;*.*)
• ODBC DSN (Data Source Name) (*.dsn;*.*)
• OData (Open Data Protocol)

Free, Portable, All-In-One, Easy to Use and Multi-language.

Supported Platforms: Windows All (x86/x64)

More Info: http://fishcodelib.com/Database.htm

Database Workbench is a complete database development environment offering you many features and helpful tools. The following database systems are supported: PostgreSQL, MySQL & MariaDB, SQL Server, Firebird, Oracle, NexusDB and InterBase.

It supports database specific and database agnostic visual design tools. With these tools, you can create a new database, even for multiple database systems from a single source, or generate a visual diagram from an existing database. Alternatively, you can design the database elsewhere and implement it using the visual editors or database script.

Via drag and drop editing, using SQL Insight, the Describe Companion and easy-to-use source code editors, you’ll be able to do your work in an efficient manner. Viewing object dependencies is easy and can be done in any object editor, as well as the database navigator.

A built-in Test Data Generator allows for volume testing.

The SQL Editor comes with a visual query plan analysis tool, query statistics and visual query builder, as well as an execution timer. All the tools you need to profile your database queries.

You can use it for debugging a stored procedure, function, trigger or package, as this is easy to do with the built in debugging tool.

Database Workbench is licenses in 3 different editions (Basic/Pro/Enterprise) and with a modular approach, you can purchase modules for each separate supported database.

DataFiller version 1.1.1

DataFiller generates random data from a database schema enriched with simple directives in SQL comments to drive eleven data generators which cover typical data types. Reasonable defaults are provided, especially based on key and type constraints, so that few directives should be necessary. The minimum setup is to specify the relative size of tables with directive mult so that the data generation can be scaled.

See the documentation or download. License is GPLv3.

Run with option —test=comics and look at the output for a didactic example.

Convert databases from MS Access to PostgreSQL/ Amazon RDS and vice versa rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

The tool provides the most efficient and easiest way of Access queries conversion to PostgreSQL views including the following types: simple queries of SELECT type, queries with MS Access standard functions (not including statistical with NZ prefix), crosstable queries. DBConvert for Access and PostgreSQL can convert SQL queries AUTOMATICALLY. No need to learn the differences in SQL dialects.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

DBConvert for Firebird & PostgreSQL is a robust cross-database migration and synchronization software that converts database structure and data between PostgreSQL, Firebird, and Interbase.

Use DBConvert and DBSync for Firebird and PostgreSQL to convert and synchronize data between the following databases in any direction:

• Firebird
• Interbase
• PostgreSQL
• Heroku Postgres
• Google Cloud SQL for PostgreSQL
• Amazon Aurora PostgreSQL
• Azure Database for PostgreSQL

DBConvert tools are useful for exporting an entire dataset from Firebird to PostgreSQL.

Or share some of your tables from the source database with the target database.

The type mapping matches Firebird data types with their closest Postgres equivalents.

Or, if you like, you can manually map data types for specific fields.

Convert databases between PostgreSQL, Amazon RDS , MS SQL Server and SQL Azure in any direction rapidly and reliably. Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 5-10 minutes to convert approximately 1 Million records.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Convert databases from MySQL to PostgreSQL/ Amazon RDS in any direction rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 3-5 minutes to convert approximately 1 Million records.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Convert databases from Oracle to PostgreSQL and vice versa rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 4-7 minutes to convert approximately 1 Million records in both directions.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

DBConvert Streams (DBS) is an event-driven data replication platform for database administrators who require zero downtime database migration and continuous data replication as workloads move to the clouds and more data needs to be transferred.

DBS source readers use Change Data Capture (CDC) technology to respond in real time to all data changes in a particular source table or the entire database.

Multiple instances of DBS target writers running in parallel speed up the whole process and improve overall performance.

DBConvert Streams can automatically convert DDL CREATE Table statements between MySQL and PostgreSQL. Thus, there is no need to worry about manual type conversion of MySQL and Postgres databases.

DBS Binaries are available for the following operating Systems and Architectures:

• Linux/ amd64,
• Linux/ arm64
• macOS/ amd64
• Windows/ amd64

Supported Databases:

• PostgreSQL,
• CockroachDB
• MySQL,
• MariaDB

It’s easy to install and run DBConvert Streams with the provided lightweight Docker containers and simple docker-compose configuration. So there is no need to scatter binaries and other artifacts around the host system.

DBConvert Studio is a robust cross-database migration and synchronization software that converts database structure and data between PostgreSQL and other database formats.
It combines mature, stable, battle-proven DBConvert and DBSync Cores with an improved modern UX design.

The following three scenarios of data migration are possible:

• Copy Data. The easiest way to copy data between various database types.
• Synchronization. One-way and Bidirectional synchronization scenarios help to keep databases in sync for all nodes.
• Data Distribution. A data distribution scenario helps to cover more complex cases where data from a source database is converted to multiple destinations.
  All database objects can be renamed during migration.

DBConvert Studio supports more than ten of the most popular on-premises databases, including

• PostgreSQL,
• SQL Server,
• MySQL,
• Oracle,
• Interbase,
• IBM DB2,
• and more.

DB Data Difftective is a utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly. Uses a native connection to PostgreSQL databases.

dbDeveloper is a visual development tool for exploration, creation and modification of multiple databases in a very easy way. It offers a variety of functions from development via tuning up to the deployment and data manipulation.

dbDeveloper supports most popular databases including PostgreSQL server. With the direct database connection and simple compact interface it can speed up your wark and make it more efficient. It is a great tool for every database developer but can also be very useful for administrators and for the end users thanks to its easy-to-use graphical interface.

Draw database diagrams easily with dbdiagram.io

• Write DSL code, get database diagram rendered immediately
• Export diagrams to SQL DDL and PDF
• Share with your colleagues and clients
• Import diagram from SQL dumps
• Use the popular DBML (database markup language)

Build a database wiki easily with dbdocs.io

• Write DBML code to represent your database structure
• Publish to dbdocs, and get a web-accessible wiki site for entire database
• Version control your database structure with Git

With dbdocs, you can:

• Explain complex schema with notes, references and relationships of each field.
• Easily hand over the project database structure in DBML for future maintenance.

dbForge Data Compare for PostgreSQL is a GUI tool for table data comparison and synchronization. This PostgreSQL compare tool helps to custom-tailor the detection of data differences between two PostgreSQL tables, and establish smart management, and safe deployment of table data inconsistencies. The PostgreSQL diff tool also delivers the generation of the PostgreSQL data synchronization scripts with multiple options to keep PostgreSQL data in sync.

Key Features:

• Save time comparing and synchronizing PostgreSQL database data.
• Generate SQL scripts to update one database with the contents of another.
• Copy lookup data from development databases to staging or production.
• Keep an accurate history of all previous PostgreSQL database records.
• Fix problems by restoring missing or damaged data to a single row.
• Automate synchronization tasks with help of command-line interface.
• Deploy to PostgreSQL from 9.5 to 13 as well as to Amazon Redshift.

dbForge Schema Compare for PostgreSQL is a tool for easy and effective comparison and deployment of Redshift database structure differences. The tool allows comparing two PostgreSQL database schemas, gives a comprehensive view of all differences in Amazon Redshift database schemas, and generates clear and accurate SQL synchronization scripts to update the database schemas.

Key features

• Diff and sync Redshift and PostgreSQL databases quickly and efficiently.
• Generate SQL scripts to update one database with the contents of another.
• Apply updates from development databases to staging or production.
• Sync tables between PostgreSQL and Redshift databases.
• Compare the structure of Amazon Redshift databases and fix the errors
• Migrate PostgreSQL schemas to Amazon Redshift
• Automate routine synchronization tasks with command-line interface

For more information and downloads:

• Website
• Documentation
• Download

dbForge Studio for PostgreSQL is a GUI client and universal tool for PostgreSQL database development and management. This PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface.

The PostgreSQL GUI frontend also provides functionality for PostgreSQL data reporting, data editing, data import and export, building pivot tables and master-detail relations.

Key Features:

• SQL Development Save your time and improve code quality when creating and editing queries with the following features: PostgreSQL Code Completion, SQL Code Formatting, SQL Syntax Check.

• Database Explorer — navigate through the object tree and find any PostgreSQL object you are interested in.

• Data Export / Import — support for 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios.

• Query Profiler — locate bottlenecks and tune the performance of slow SQL queries with neatly displayed profiling results.

• Data Reports and Analysis — provides powerful functionality for summarizing and filtering your data and then creating comprehensive and easy-to-read visual reports, allowing you to properly analyze it and share this information with others.

• Data Editor — manage settings of tables, сolor and format your rows and cells using a rich set of fonts and size.

• Pivot Table — advanced filtering, visual data presentation in a graph make your data easier to read, understand, and analyze.

• Master-Detail Browser — view data in related tables simultaneous for the express data analysis and locating specific records and logical errors in the database.

dbMigration .NET is a simple, easy and intuitive multiple database migration tool,
With it you can easily migrate schema and data between different databases without complicated procedure.
Supported databases: PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix,
HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro…etc.

Major features:

• Automatic column macthing
• SQL preview
• Filter source data
• Show target results
• Integrated with Database .NET
• BLOB type support
• Command-Line support

Free, All-In-One, Portable, and Single executable file.

Supported Platforms: Windows All (x86/x64)

More Info: http://fishcodelib.com/DBMigration.htm

DB Schema Difftective is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences, stored procedures, triggers and constraints between two databases. Generates PostgreSQL compatible alter database scripts.

Sync your data between MS Access and PostgreSQL/ Amazon RDS databases rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Synchronize PostgreSQL, Amazon RDS, MS SQL and SQL Azure databases in any direction rapidly and reliably! Operate with a whole database or select only needed dataset to proceed.

Update, Insert and Drop sync keep distributed databases in agreement.

Sync databases with identical or even with different structures! All customizations are organised on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Synchronize PostgreSQL, Amazon RDS and MySQL databases rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

As well, two PostgreSQL databases can be set up as source and destination.

Update, Insert and Drop sync allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Synchronize data between PostgreSQL, Amazon RDS and Oracle databases.
Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Sync databases with identical or even with different structures! All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

DBTransfer — versatile and fast database transfer tool

DBTransfer is a multi-platform Java tool that aims to replicate one database (JDBC or MS Access) to another (JDBC), using an one to one conversion..

It currently supports:

• PostgreSQL (tested)
• MSSQL (tested)
• MySQL/MariaDB/Percona (tested)
• Oracle (tested)
• DB2 (needs testing)
• Access (read only, tested).

With DBTransfer, you can:

• Copy data from one database type to another type. Example: you can migrate your MSSQL to PostgreSQL, without losing the structure, including not only the original schema, the constraints, and of course, the data it self, which is converted to respective data-type.
• Copy one database schema to another.
• Move data from one database to another.
• Compare two databases.

DbVisualizer is a feature rich, intuitive multi-database tool for developers, analysts and database administrators. With its easy-to-use and clean interface, DbVisualizer has proven to be one of the most cost effective database tools available, yet to mention that it runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. Supports many database systems including PostgreSQL.

Features:

• Free and Pro version available
• Runs on Windows, Linux, and macOS
• Flexible user interface in light and dark themes
• Simple navigation of database objects and their properties
• Visual rendering of primary/foreign keys
• Table data editing in spreadsheet
• Export and import database schema
• Query optimization with an explain plan feature
• Visual query builder using drag and drop
• Flexible SQL scripts execution with parameter support
• SQL formatting
• Command-line interface for headless execution

DeZign for Databases is an intuitive database design tool for database developers that can help you model, create and maintain PostgreSQL (and others) databases. It uses entity relationship diagrams to graphically design databases.

Our latest version also adds support for PostgreSQL data model comparisons. In additional to PostgreSQL 7, PostgreSQL 8 (including 8.1) is supported as well.

Invasive software composition platform for building business applications.

Domain model is declared using DSL based on Domain-Driven Design.
Postgres database is maintained from that model:

• tables, views, types, functions and other database objects are created, modified and recreated
• advanced migrations are supported: whenever possible data migration will be performed without data loss
• object oriented features are utilized: nested types as values, tables as entities, views as snowflakes and aggregates
• listen/notify for cache invalidation
• a lot of other boilerplate…

EMS Data Comparer for PostgreSQL is a powerful and easy-to-use tool for PostgreSQL data comparison and synchronization. Using this utility you can view all the differences in compared PostgreSQL tables and execute an automatically generated script to eliminate these differences. Flexible customization of the PostgreSQL comparison and synchronization process will enable you to select tables and fields for comparison, perform partial PostgreSQL data synchronization or data comparison for several tables at once and tune many other options to effectively compare PostgreSQL table data. Data Comparer for PostgreSQL includes a graphical wizard that will guide you through the PostgreSQL data comparison and synchronization process step by step, and a command-line utility for synchronizing PostgreSQL data in one-touch.

EMS Data Import for PostgreSQL is a powerful tool to import data to PostgreSQL tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination PostgreSQL data formats for the selected fields, commit options, number of records to skip, etc. Data Import for PostgreSQL includes a wizard, which allows you to set all the PostgreSQL import options for different files visually, and a command-line utility to execute import to PostgreSQL database in one-touch.

EMS Data Generator for PostgreSQL is an impressive tool for generating test data to PostgreSQL database tables with the possibility to save and edit scripts. The utility can help you to simulate the database production environment and allows you to populate several PostgreSQL database tables with test data simultaneously, define tables and fields for generating data, set value ranges, generate PostgreSQL char fields by mask, define lists of values manually or select them from SQL queries, set generation parameters for each field type and has many other features to generate PostgreSQL test data in a simple and direct way. Data Generator for PostgreSQL also provides a console application, which allows you to generate PostgreSQL test data in one-touch by using generation templates.

EMS Data Import for PostgreSQL is a powerful tool to import data to PostgreSQL tables from MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination PostgreSQL data formats for the selected fields, commit options, number of records to skip, etc. Data Import for PostgreSQL includes a wizard, which allows you to set all the PostgreSQL import options for different files visually, and a command-line utility to execute import to PostgreSQL database in one-touch.

EMS Data Pump for PostgreSQL is an excellent migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to PostgreSQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target PostgreSQL database and fully customize the import process. Data Pump for PostgreSQL has the ability to automate migration to PostgreSQL server task using the helpful console utility. With Data Pump for PostgreSQL database conversion and migration to PostgreSQL become as easy as possible!

EMS DB Comparer for PostgreSQL is an excellent tool for PostgreSQL database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to synchronize structure of PostgreSQL databases and eliminate all or selected differences. The program has the ability to automate PostgreSQL database schemas comparison and synchronization task using the helpful Console Application.

Having EMS DB Comparer for PostgreSQL you can work with several projects at once, define PostgreSQL comparison parameters, print difference reports, and alter modification scripts. Its user-friendly interface greatly simplifies discovering and eliminating differences in PostgreSQL database structure saving your time and therefore money.

EMS DB Extract for PostgreSQL is an impressive and easy-to-use tool for creating PostgreSQL database backups in a form of SQL scripts. This database script utility allows you to save metadata of all PostgreSQL database objects as well as PostgreSQL table data as database snapshot. DB Extract scripts PostgreSQL database objects in the correct order according to their dependencies. Flexible customization of the extract process enables you to select objects and data tables for PostgreSQL database dump and tune many other extract options. DB Extract for PostgreSQL includes a graphical wizard that will guide you through the PostgreSQL extract process step by step, and a command-line utility for creating PostgreSQL backups in one-touch.

EMS SQL Backup for PostgreSQL is an easy-to-use GUI tool to create backups for multiple PostgreSQL servers from a single console. You can use automatic backup tasks with advanced schedules and store them in local or remote folders or cloud storages. PRO, Standard and FREE versions available.

EMS SQL Management Studio for PostgreSQL is a complete solution for PostgreSQL database administration and development. With components that focus on all critical PostgreSQL database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering PostgreSQL databases, managing database schema and objects as well as for PostgreSQL database design, migration, extraction, PostgreSQL query building, data import, export and database comparison.

SQL Studio unites these database tools for PostgreSQL in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing PostgreSQL database administrators and PostgreSQL application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for PostgreSQL offers all essential PostgreSQL tools to make you more productive than ever before!

EMS SQL Manager for PostgreSQL is a high performance tool for PostgreSQL database administration and development. It works with any PostgreSQL versions up to the newest one and supports the latest PostgreSQL features including enumerated, text search, XML and UUID data types, PostgreSQL index key sorting order, arrays of composite types, and others. SQL Manager for PostgreSQL offers plenty of powerful database tools such as Visual Database Designer to create PostgreSQL database in few clicks, Visual Query Builder to build complicated PostgreSQL queries, powerful BLOB editor and many more useful features for efficient PostgreSQL administration. SQL Manager for PostgreSQL has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

EMS SQL Query for PostgreSQL is a useful tool that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual PostgreSQL query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to PostgreSQL databases, select tables and fields for a query to PostgreSQL server, set the selection criteria and much more. Using this query utility you can work with several PostgreSQL queries at once, edit query text in the powerful SQL editor, view the execution results in different modes, create PostgreSQL queries with unions and subqueries visually, build diagrams based on queries, view PostgreSQL query execution plans and perform any other operations you may need in your work with PostgreSQL database queries.

Entity Developer is a powerful ORM designer for ADO.NET Entity Framework, Entity Framework Core, NHibernate, LinqConnect, Telerik Data Access, and LINQ to SQL. It introduces new approaches for designing ORM models, boosts productivity, and facilitates the development of database applications.

Key Features

• Design your data access layer visually, via drag-n-drop, and then generate code automatically. Or simply generate a model from a database or vice versa in a couple of minutes.

• Automating data access layer generation helps you do less mistakes in your code.

• For Entity Framework v1 — v6 our designer offers much more design and code generation features than EDM designer.

• Seamless Visual Studio integration.

• Design Entity Framework Core models visually. Get model-first and database-first support with a lot of settings.

• Optimized work with large models.

IDE Compatibility

Entity Developer integrates with Visual Studio 2008, 2010, 2012, 2013, 2015, 2017 and 2019.

Learn more about Entity Developer features on Devart website.

ERBuilder Data Modeler allows to graphically design databases using Entity Relationship Diagrams to automatically generate the most popular SQL databases. Developers can view physical model structures to understand their databases, create new databases. ERBuilder is extremely easy to use and understand. It provides all the features you would expect from a professional database modeling and design tool.

Features

• Visual data modeling
• Creation of entities, attributes, relationships, views, domains, indexes, sequences, triggers and stored procedures
• Model checking
• Version management
• Generation of an SQL Data Definition Language (DDL) script
• Generation of databases
• Reverse engineering database
• Generation of navigable Database documentation
• Generation of Data Inserts

Enables you to transfer data between PostgreSQL and others database/file systems, e.g.: MySQL, Oracle, SQL Server, Microsoft Access/Excel, FireBIrd, SQLite, CSV etc.

With the step-by-step wizard GUI, everyone can easy transfer data from one to the others. Just select a data source and a target output format, ESF Database Convert can transfer table structure, data, indexes, primary keys, foreign keys and so on automation.

Also, this tool provides some advance options to custom converting process, e.g.: rename table/field name, change field data type/default value …

ETL Validator is a data testing tool that greatly simplifies the testing of Data Integration, Data Warehouse and Data Migration projects. It makes use of our patented ELV architecture to Extract, Load and Validate data from data sources such as databases, flat files, XML, Hadoop and Web Services. It has an inbuilt ETL engine capable of comparing millions of records.

ETL Validator uses PostgreSQL as the Repository & Workschema for storing the test cases and comparing the data.

Excel-to-PostgreSQL is a program to convert Microsoft Excel spreadsheets into PostgreSQL databases. Each worksheet becomes a table, each row becomes a record. Conversion performance is about 10,000 records per second on an average modern PC. Command line support allows automating, scripting and scheduling MS Excel to PostgreSQL conversion.

Features

• All versions of MS Excel are supported (including MS Excel 2016)
• All versions of PostgreSQL starting from v9.0 are supported
• Option to convert individual worksheets
• Option to merge MS Excel data into an existing PostgreSQL database
• Intelligent types mapping
• Stores conversion settings into profile
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

FoxPro-to-PostgreSQL is a program to migrate FoxPro databases to PostgreSQL server. Depending on your privileges on the target PostgreSQL server you can export DBF data into new database or overwrite the contents of an existing PostgreSQL database.

Features

• All formats of FoxPro data and MEMO files are supported
• All versions of PostgreSQL servers are supported
• Support for large .dbf files (4GB+)
• High performance due to direct connection to source and destination databases (the program does not use ODBC or any other middleware software)
• Option to merge DBF data into an existing PostgreSQL database
• All FoxPro code pages are supported
• Stores conversion settings into profile
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limbas is a flexible, free web-based database frontend based on PHP.
It includes functions like reporting, tabularys and base functions like DMS.
There are existing solutions for workflows, CRM, CMS, ticketsystems, webshop, product database, groupware, call center.

Create a webapp from an __existing database__ in 30 seconds!

Portofino is a free and open source web framework that helps developers create outstanding enterprise applications by addressing three specific needs: productivity, features and architecture.

Among its features: content management, CRUD, database connectivity, calendars, charts, security and easy customization using Groovy.

A wizard allows the developer to create a web application by connecting to an existing.database quickly and easily

Moon Modeler is an easy to use cross platform database modeling tool for PostgreSQL and other databases. It allows you to draw ER diagrams with nested JSON, reverse engineer existing database structures and generate SQL scripts.

Key features

• Database modeling
• Visualization of nested structures and JSON
• SQL script generation
• Reverse engineering
• Support for PostgreSQL specifics, modeling of composite types etc.
• GraphQL schema design

Moon Modeler is available for Windows, MacOS and Linux.

MSSQL-to-PostgreSQL is a program to migrate Microsoft SQL or SQL Azure databases to PostgreSQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of Microsoft SQL are supported (including SQL Azure)
• All versions of PostgreSQL are supported
• Tables, data, indexes, constraints, sequences and views are converted
• Option to merge and synchronize MS SQL data into an existing PostgreSQL database
• Option to filter data using SELECT-queries
• Command line support
• Stores conversion settings into profile
• Support for multibyte character sets
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert stored procedures, functions and triggers
• Demo version converts only 50 records per table
• Demo version does not convert views and foreign keys

Requirements

• PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run MSSQL-to-PostgreSQL from)
• Necessary privileges to write into the destination database

MSSQL-to-PostgreSQL Code Converter is a program to migrate stored procedures, functions and triggers from SQL Server to PostgreSQL.

Features

• Built-in functions are converted into PostgreSQL equivalents
• MS SQL types are mapped into PostgreSQL
• Intelligent handling of reserved words and identifiers
• Reading source code from live database or T-SQL script file
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Manual post-processing of the output code may be required
• Demo version converts only 5 stored procedures/functions

MySQL-to-PostgreSQL is a program to migrate PostgreSQL databases to MySQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of PostgreSQL are supported
• All versions of Unix and Windows MySQL are supported
• Fast conversion engine (about 10,000 records per second of average P-IV system)
• Option to merge PostgreSQL data into an existing MySQL database
• Option to convert individual tables
• Converts indexes with all necessary attributes
• Command line support
• Stores conversion settings into profile
• Support for multibyte character sets
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert foreign keys
• Does not convert views, stored procedures and triggers
• Demo version converts only 5 records per table

Requirements

• PostgreSQL environment (server or client components of PostgreSQL
  must be installed on the same machine where you run MySQL-to-PostgreSQL from)
• Necessary privileges to write into the destination database

Try before you buy

Still not sure the program fits your needs? Try free
demo version with limited features. It will allow you to convert only five records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results: http://www.convert-in.com/sql2pgs.htm

Navicat Data Modeler is a powerful and easy-to-use GUI tool for creating and manipulating PostgreSQL database models. It enables users to design PostgreSQL database structures, reverse engineer, forward engineer, generate SQL files and print models to files, etc.

Navicat Data Modeler is available on three platforms — Microsoft Windows, macOS and Linux. Here are some highlights of Navicat Data Modeler:

• Create and manipulate conceptual/logical/physical models.
• Support cloud databases like Amazon RDS, Amazon Redshift.
• Reverse engineer databases/schemas or tables/views to a model.
• Forward engineer a physical model to a SQL file or a database/schema.
• Create and edit table structures directly.

For details, please visit our website: https://www.navicat.com

Navicat™ is a powerful PostgreSQL database administration and development tool that are not only sophisticated enough for professional developers, but also easy to learn for new users. With an user-friendly GUI, Navicat™ lets you quickly and easily create, organize, access and share information in a secure and convenient way.

Navicat supports multiple PostgreSQL server connections which can be connected locally or remotely. Your remote PostgreSQL server can be running on Linux, Unix, Mac OS X or Windows platform.

NextTypes is a standards based information storage, processing and transmission system that integrates the characteristics of other systems such as databases, programming languages, communication protocols, file systems, document managers, operating systems, frameworks, file formats and hardware in a single tightly integrated system using a common data types system.

NextTypes uses PostgreSQL as its data store. Its advanced features as complete SQL support, transactional DDL, deferrable constraints, composite types and full-text search allow building a very complete data system with a high level of abstraction.

NextTypes is a relational/network/objects/files hybrid database system with high level SQL interface, extensive primitive types list, JSON/JSON-LD/XML/Smile/WebDAV/CalDAV/iCalendar/RSS data access, REST interface, customizable MVC architecture, optimistic concurrency control, HTML5/CSS3/SVG/Javascript responsive graphical interface, multilanguage, UTF-8 encoding, syntax highlighting or WYSIWYG editors, robots.txt and sitemap management, text extraction/fulltext search, document management, virus scanning, DoS/SQL injection/CSRF/XSS protection, passwords/X.509 certificates authentication, logging and backup system.

Nucleon Database Master is a modern, powerful, intuitive and easy to use database query, administration, and management software with a consistent and modern user interface. Database Master simplifies managing, monitoring, querying, editing, visualizing, designing relational and NoSQL DBMS.

Database Master allows you to execute extended SQL, JQL (NoSQL) and C# (LINQ) query scripts, provides all database objects such as tables, views, procedures, packages, columns, indexes, relationships (constraints), collections, triggers and other database objects.

Database Master supports more then 40 data sources including PostgreSQL.

Advanced multi-threaded PostgreSQL connection pooler and request router.

complete solution for PostgreSQL monitoring

Full operational data, collected automatically

Okmeter.io monitoring agent knows and collects thousands of real time Postgres metrics on it’s operation and functioning. It guarantees you will have everything need.

Dashboards & reports created by Postgres experts

Practical summaries and detailed views for every aspect of DB performance. You’ll see your DB through the eyes of professional DBAs.

Performance issues auto‑detection

Okmeter knows all potential problems with Postgres beforehand — common pitfalls, suboptimal settings. You’ll be prepared to all of them.

Detailed monitoring of all PostgresSQL subsystems

Query execution monitoring

Workload monitoring is the cornerstone of database performance analysis. You’ll know whenever a DB request generates overload on CPU or disks. Okmeter will show you exactly which one caused it.

Client connections monitoring

You’ll be aware which IPs created how many connections, and what states they are in. You’ll have a distinct understanding of how many transactions are actively executing queries, how many are idling, and whether some are waiting on locks.

Checkpointer & bgwriter monitoring

These are two crucial storage processes in Postgres that write changed data to disks. Its configuration not only defines disk IO load, but query processing times as well.

Autovacuum monitoring

Autovacuum is a critical Postgres process, designed to clean up unneeded data. It also updates query planner statistics and prevent data loss due to transaction ID wraparound. Be aware of autovacuum operation and its proper setup.

Replication monitoring

Postgresql streaming replications if widely used for fault tolerance and scaling, you wouldn’t want it to be in a bad condition. Okmeter will keep an eye to ensure it’s working well.

Hardware & OS monitoring

Internal Postgres operational metrics are not enough to get a full picture of what’s happening on the server. Okmeter has all the system metrics and monitors every process on the server. You’ll have preset dashboards and triggers on top of all that.

Learn more

About features or read detailed list of metrics

Oracle-to-PostgreSQL is a program to migrate Oracle databases to PostgreSQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of Oracle and PostgreSQL are supported
• Option to merge Oracle data into an existing PostgreSQL database
• Option to synchronize PostgreSQL database with Oracle data
• Option to filter data using SELECT-queries
• Converts foreign keys
• Option to convert individual tables
• Converts indexes with all necessary attributes
• Command line support
• Stores conversion settings into profile
• Support for multibyte character sets
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert views, stored procedures and triggers
• Demo version converts only 5 records per table and does not convert foreign keys

Requirements

• PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run Oracle-to-PostgreSQL from)
• Necessary privileges to write into the destination database

Open Source administration and management tools for the PostgreSQL database. Includes a graphical administration interface, an SQL query tool, a procedural code editor, ERD tool, Schema comparison, and much more.

pgAdmin is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases.

Runs as a desktop application on most common operating systems, or can be deployed as a multi-user web application on a server or in a container.

pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads.

Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security.

Major features include: multi-process backup and restore, local or remote operation, full/incremental/differential backups, backup resume, delta restore, asynchronous archiving, and much more.

PG Collector for PostgreSQL is a SQL script that gathers valuable database information and presents it in a consolidated HTML file which provides a convenient way to view and navigate between different sections of the report.

PG Collector is safe to run on production environments and does not create any database objects to produce the output.

NodeJS library to programmatically compare two different database, generate sql patches and migrate schema within a «team-based devops» migration strategy.

PostgreSQL Schema and Data compare.

CLI tool to make sql patches of differences between two database.

pgEdit is a high performance SQL editor and development environment designed specifically for PostgreSQL relational databases. pgEdit features include SQL syntax coloring, direct source code execution, PHP support, integrated documentation, and extensive customizable editing facilities.

pgEdit uses psql, the interactive terminal application included with every PostgreSQL installation. This makes it easy to develop with pgEdit and then transfer your work to any PostgreSQL installation for maintenance and production tasks.

pgEdit is a native application for both Macintosh and Windows. It does not use Java or require installation of external libraries. You have the option of using the version of psql included with pgEdit or a different version installed anywhere on your hard drive.

pgFormatter is a PostgreSQL SQL and PLPGSQL syntax beautifier that can work as a console program or as a CGI.

This SQL formatting/beautifier tool supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. May
works with any other databases too.

pgFormatter can work as a console program or as a CGI. It will automatically detect his environment and output as text or as HTML following the context. Keywords highlighting is only be available in CGI context.

On-line demo site at http://sqlformat.darold.net/

pgloader loads data from various sources into PostgreSQL. It can transform the data it reads on the fly and submit raw SQL before and after the loading. It uses the COPY PostgreSQL protocol to stream the data into the server, and manages errors by filling a pair of reject.dat and reject.log files.

Thanks to being able to load data directly from a database source, pgloader also supports from migrations from other productions to PostgreSQL. In this mode of operations, pgloader handles both the schema and data parts of the migration, in a single unmanned command, allowing to implement Continuous Migration.

Overview

pgMustard helps people quickly review PostgreSQL query plans (EXPLAIN ANALYZE output).

Key features

• Performance advice – scored by estimated time-saving potential
• Per-operation timings¹
• The number of rows¹ returned by each operation
• Timing bar – that pins to keep it in context
• Collapsible subtrees – with fast ones collapsed by default
• Descriptions of operations
• Links to blog posts for further reading

¹ Taking loops, threads, subplans, and CTEs into account.

Advice

The performance advice pgMustard can give includes:

• High index potential
• Poor index efficiency
• Operations on disk
• Poor row estimates
• Poor cache performance
• Excessive heap fetches
• Poor read efficiency (can be a sign of bloat)
• Lossy bitmap scans
• High index-only scan potential
• Late filters
• CTE scans used only once
• Slow counts
• Excessive planning time
• Trigger time dominated
• Poor read speed
• Scope for increased parallelism

Requirements

• JSON format query plans, from PostgreSQL 9.6 or newer
• The interface and advice are in English
• GitHub or Google authentication – no installation or database access required

Backup and Recovery tool for PostgreSQL databases.
Features :

Full HOT backups
Point-In-Time Recovery (PITR) by Date,Restore point and LSN
Provide a smart way to manage restore point
Manage Permanent or Temporary restore point (Prevent backups from deletion)
Optimize backup size by compression (libzip)
Remove indexes from the backup to reduce the backup size
Recreate indexes at recovery time
Granular restore at Database, Schema or Table level
Automatic WAL removal at backup time
Automatic Deletion of obsolete backups

PGSync is a middleware for syncing data from Postgres to Elasticsearch effortlessly. It allows you to keep Postgres as your source of truth data source and expose structured denormalized documents in Elasticsearch.

Changes to nested entities are propagated to Elasticsearch. PGSync’s advanced query builder then generates optimized SQL queries on the fly based on your schema. PGSync’s advisory model allows you to quickly move and transform large volumes of data quickly whilst maintaining relational integrity.

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies and hosting services.

Features

* Administer multiple servers
* Support for PostgreSQL 7.0.x, 7.1.x, 7.2.x, 7.3.x, 7.4.x, 8.0.x, 8.1.x, 8.2.x, 8.3.x
* Manage all aspects of:
      o Users & groups
      o Databases
      o Schemas
      o Tables, indexes, constraints, triggers, rules & privileges
      o Views, sequences & functions
      o Advanced objects
      o Reports
* Easy data manipulation:
      o Browse tables, views & reports
      o Execute arbitrary SQL
      o Select, insert, update and delete
* Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump
* Import SQL scripts, COPY data, XML, CSV and Tabbed
* Supports the Slony master-slave replication engine
* Excellent language support:
      o Available in 27 languages
      o No encoding conflicts. Edit Russian data using a Japanese interface!
* Easy to install and configure

Build professional web apps with little or no coding.

Build sophisticated web database applications to your customer’s exact needs with PHPRunner low-code platform. PHPRunner enables you to create robust, dynamic, and secure applications up to 20 times faster than traditional software coding.

Supports all versions of PostgreSQL.

More info

21-day trial version download

PostgresCompare automatically detects the changes made to your database schema and produces the SQL required to keep everything up to date. Increase visibility, reduce errors and save time deploying updates with Postgres Compare. Check it out at Postgres Compare

Postgres Enterprise Manager was designed for DBAs and large database installations. Its distributed architecture manages all your PostgreSQL instances on your in-house hardware, on-premise VMs, or in 3rd party cloud environments. Monitoring agents send host and Postgres data to a centralized enterprise management server that is accessible from multiple GUI Client consoles. Performance monitoring dashboards provide user customized metrics for your Server, Database, Memory, I/O, Storage, Object Activity, Operating System, and System Waits each with its own graphs, data, and accompanying alerts to exception conditions. The Capacity Manager answer questions like: How much storage will my database need six months from now?, How fast is my database growing?, What objects are responsible for the growth in my database?, Will my server be able to support another database instance?, Is the performance of my database getting better, staying the same, or getting worse? The SQL Profiler can trace and identify poorly-running SQL code in large and complex systems. You can then sort and filter the resulting statement statistics to quickly find your longest running SQL code and then optimize that code for better performance. You can even send the trace results to the Index Advisor and get index recommendations for any underlying tables to improve SQL response times. Finally, Enterprise Manager offers Postgres Expert, your DBA-in-a-box, to help enforce best practices for your database server configuration parameters, schemas, and security according to best practice guidelines written by the Postgres database specialists at EnterpriseDB.

PostgreSQL Database Modeler, or simply, pgModeler is an open source tool for modeling databases that merges the classical concepts of entity-relationship diagrams with specific features that only PostgreSQL implements. The pgModeler translates the models created by the user to SQL code and apply them onto database server (version 9.x).

PostgreSQL Data Wizard is a powerful Windows GUI utility for managing your PostgreSQL data.

PostgreSQL Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. PostgreSQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your PostgreSQL database, export data from PostgreSQL tables and queries to most popular formats, and import data into the tables.

PostgreSQL Maestro is a high-quality Windows GUI admin tool for PostgreSQL server management, control and development.

PostgreSQL Maestro allows you to create, edit, copy, extract and drop all the database objects such as schemas, tables, views, functions, domains, rules, sequences, languages, operators, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage PostgreSQL roles, users, groups and their privileges, and use a lot of other tools designed for the easiest and most efficient work with PostgreSQL Server.

PyGreSQL is an open-source Python module that interfaces to a PostgreSQL database. It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script.

Security scanner RedCheck is an easy-to-use and handy solution being a real godsend to assess protection maturity and manage information security.

In addition to other functionality, RedCheck allows to audit PostgreSQL configurations and contains security configuration for PostgreSQL.

A key feature of RedCheck is the work with OVALdb security information repository, which contains vulnerability definitions in the OVAL format, updates and other security content for PostgreSQL.

RHQ is an open source systems management solution that runs on PostgreSQL and which also features a plugin to manage and monitor PostgreSQL databases.

RHQ is written in Java and provides a central management UI plus a very flexible and extensible plugin architecture. This allows to easily extend RHQ to your specific needs.

RHQ is currently available in source form only.

SEQUEL

is actually a suite of applications designed to help database administrators, programmers, students or just anyone interested in SQL and DB management by giving a modern interface to interact with database servers. The application is utilising most innovative technologies and programming concepts in order to bring an easy to use tools for accomplishing daily tasks or design complex DB solutions. The main characteristics of SEQUEL are:

• Access to all database objects
• Extended information for every DB element
• Easily accessible documentation and help
• Innovative interface that helps work faster and gives instant access to most of the database elements parameters

Skyvia is a cloud service for data integration, management and backup. Using Skyvia, you can connect your PostgreSQL data both with cloud data sources (Salesforce, SugarCRM, Zoho CRM, Dynamics) and relational databases (SQL Server, MySQL, SQL Azure).

It provides quick and easy data integration with no coding, secure cloud data backup with one-click restore and online data management via SQL.

SQL Image Viewer allows you to retrieve, view, convert and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF.
It also allows you to export binary data, and recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2, GZ, RAR, ZIP, and has experimental support for DOC, PPT and XLS file types.

A command line version is also included to allow you to set up unattended scheduled exports of binary data.

SQLite-to-PostgreSQL is a tool to migrate SQLite databases to PostgreSQL or Heroku. The program has high performance due to direct connection to source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of Linux/Unix and Windows PostgreSQL servers are supported
• Option to customize resulting table structure
• Convert indexes and relationships between tables
• Stores conversion settings into profile
• Option to merge SQLite data into an existing PostgreSQL database
• Option to synchronize PostgreSQL database with SQLite data
• Support for Unicode
• Option to export SQLite database into PostgreSQL script file
• Command line support
• Easy-to-use wizard-style interface
• Full install/uninstall support