Software Catalogue - Administration/development tools

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/.

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

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.

Discover the pinnacle of data conversion and synchronization using DBConvert and DBSync for DBF and PostgreSQL. Transform your data migration experience, adeptly managing MS FoxPro, dBase, Clipper, XBase, and FoxBase.

DBConvert's Potential:

Effortlessly import DBF to PostgreSQL, ensuring seamless compatibility and data integrity. Facilitate smooth migration from legacy systems or upgrade your database infrastructure.

Cross-Platform Migration:

Bid farewell to compatibility issues. DBConvert seamlessly supports migration between DBF and PostgreSQL, accommodating diverse file formats. Extend your reach to PostgreSQL-related databases, including cloud services like Amazon RDS, MS Azure, and Google Cloud SQL.

User-Friendly Interface:

No tech magic required. Empower users of all levels with an intuitive interface prioritizing simplicity without sacrificing functionality.

Harmony in Transition with DBSync:

DBSync elevates data synchronization, connecting and updating data between DBF and PostgreSQL databases for consistent platforms.

Flexible Configuration:

Tailor synchronization to your needs with DBSync, allowing customization of frequency and specific data elements to synchronize.

The Perfect Pair:

Combine the strengths of DBConvert and DBSync for a comprehensive data management solution. Effortlessly convert, migrate, and synchronize data, ensuring a harmonious transition between DBF and PostgreSQL.

Ready to revolutionize your database experience? Download DBConvert and DBSync now!

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.

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 15 as well as to Amazon Redshift.

More Info: https://www.devart.com/dbforge/postgresql/datacompare/

Download

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: Boost the speed and quality of your coding with context-aware autocompletion, formatting, and instant syntax check.

• Database comparison and synchronization: Compare the schemas and table data of your databases and generate synchronization scripts to deploy changes.

• Data management: View, edit, sort, group, filter, import, and export your data effortlessly.

• Test data generation: Generate meaningful test data and populate your databases with it in a matter of moments.

• Query profiling: Analyze your queries to locate and eliminate performance bottlenecks.

• Data analysis and reporting: Build pivot tables with your data, visualize data trends and dependencies, and generate comprehensive data reports.

• Availability: Use dbForge Studio on Windows, Linux, or macOS.

More Info: https://www.devart.com/dbforge/postgresql/studio/

Download

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.

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, 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

Greenmask is an open-source tool, crafted in Go, dedicated to enhancing data security through advanced obfuscation techniques. It streamlines data protection processes in PostgreSQL, ensuring sensitive data remains secure and private.

Key Features

• Open-Source: Fully written in Go, offering wide functionality for backup, anonymization, and masking.
• Deterministic transformers — deterministic approach to data transformation based on the hash functions. This ensures that the same input data will always produce the same output data. Almost each transformer supports either random or hash engine making it universal for any use case.
• Dynamic parameters — almost each transformer supports dynamic parameters, allowing to parametrize the transformer dynamically from the table column value. This is helpful for resolving the functional dependencies between columns and satisfying the constraints.
• Cross-platform - Can be easily built and executed on any platform, thanks to its Go-based architecture, which eliminates platform dependencies.
• Database type safe - Ensures data integrity by validating data and utilizing the database driver for encoding and decoding operations. This approach guarantees the preservation of data formats.
• Transformation validation and easy maintainable - During obfuscation development, Greenmask provides validation warnings and a transformation diff feature, allowing you to monitor and maintain transformations effectively throughout the software lifecycle.
• Partitioned tables transformation inheritance - Define transformation configurations once and apply them to all partitions within partitioned tables, simplifying the obfuscation process.
• Stateless - Greenmask operates as a logical dump and does not impact your existing database schema.
• Backward compatible - It fully supports the same features and protocols as existing vanilla PostgreSQL utilities. Dumps created by Greenmask can be successfully restored using the pg_restore utility.
• Extensible - Users have the flexibility to implement domain-based transformations in any programming language or use predefined templates.
• Declarative - Greenmask allows you to define configurations in a structured, easily parsed, and recognizable format.
• Integrable - Integrate Greenmask seamlessly into your CI/CD system for automated database obfuscation and restoration.
• Parallel execution - Take advantage of parallel dumping and restoration, significantly reducing the time required to deliver results.
• Provide variety of storages - Greenmask offers a variety of storage options for local and remote data storage, including directories and S3-like storage solutions.

Use Cases

• Routine logical backup dumping and restoring.
• Anonymization and masking of backups for staging and analytics.

PostgreSQL Compatibility

Compatible with PostgreSQL version 11 and higher.

Ispirer Toolkit performs automated migration of any popular RDBMS to PostgreSQL.

What you will get:

• Free proprietary tool for migration scope and complexity assessment;
• Assistance in Ispirer Toolkit configuration;
• Automated migration of the entire database schema, tables, SQL objects, business logic, and data;
• Prompt customizations of Ispirer Toolkit to maximize the automation level;
• Expert support during the entire project.

Whether your modernization challenge is small, complex, or mission critical, the Ispirer migration tool can help you overcome it at a reduced cost, risk, and effort.

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.

Luna Modeler is an easy to use cross platform database modeling tool for PostgreSQL and other relational databases. It allows you to draw ER diagrams, reverse engineer existing database structures and generate SQL scripts or interactive HTML reports.

Key features

• ER diagrams
• Database modeling
• SQL script generation
• Reverse engineering
• Support for PostgreSQL specifics, modeling of composite types etc.
• Conversion from SQL Server, MySQL, MariaDB and SQLite
• Project update
• HTML reports and export to PDF

Luna 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

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.

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.

pg_multibackup is an easy to use, centralized backup tool for PostgreSQL which supports both scheduled base backups and scheduled WAL retrieval using pg_receivewal.

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

pgSCV is a Prometheus-compatible monitoring agent and metrics exporter for PostgreSQL environment. The goal of the project is to provide a single tool (exporter) for collecting metrics from PostgreSQL and related services.

Features:

• Supported services: support collecting metrics of PostgreSQL, Pgbouncer and Patroni;
• OS metrics: support collecting metrics of operating system (Linux);
• TLS and authentication. /metrics endpoint could be protected with basic authentication and TLS;
• Collecting metrics from multiple services. pgSCV can collect metrics from many databases instances;
• User-defined metrics. pgSCV could be configured in a way to collect metrics defined by user;
• Collectors management. Collectors could be disabled if necessary;
• Collectors filters. Collectors could be adjusted to skip collecting metrics based on labels values, like block devices, network interfaces, filesystems, users, databases, etc;
• Support running in many different environment: bare metal server, VPS and using docker, k8s, helm chart;
• Grafana dashboards is ready to use;

More information on project page and wiki:

• pgSCV on Github
• pgSCV wiki
• pgSCV releases

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.

Regression testing tool for Postgres.

Inspired by pg_regress, pg_yregress provides a TAP-compatible test executor that allows for better test organization, easier instance management and so on.

Features

• TAP reporting
• Grouped & structured tests
• Single-file test/expectation management
• Built-in JSON handling
• Binary type encoding testing
• Transaction management
• Deep instance configurability

Use cases

• Testing Postgres extensions
• Verifying complex SQL queries or behaviors
• Stored function testing
• Data health checks

More

• Documentation

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

Battery-Included PostgreSQL Distro as a Free RDS Alternative, with:

• Extensible Postgres with 255 extensions available: PostGIS, Timescale, Citus, PGVector, AGE, PGML, ParadeDB, Hydra, DuckFDW, GraphQL, ……
• Reliable Infras: Create self-healing HA PostgreSQL clusters with pre-configured PITR, built-in ACL, & SSL, and secure your infra with local CA & best practices.
• Observable Graphics: Unparalleled monitoring best practices build upon the modern Prometheus & Grafana stack. Reuse them to monitor existing DBs & cloud RDS. Check our Gallery & Demo
• High-Available Service: Deliver auto-routed, high-performance, pooled, reliable, flexible database Services Access via Pgbouncer DNSMasq, Keepalived, vip-manager, and HAProxy.
• Maintainable Toolbox: Infra as Code, Declarative API & Idempotent Playbooks, Vagrant sandbox & Terraform IaaS provisioning specs. Local repo, offline package, delivered without Internet access.
• Composable Modules: Modular design, flexible arch with many bonus features. Redis, MinIO, ETCD, FerretDB, DuckDB, Supabase, and Docker compose templates for software that uses Postgres.
• Painless Experience: Easy to use: Download, Install, and Configure in one command. Built-in configuration templates for different scenarios, auto-tuned params, admin SOP, and zero-downtime blue-green migration plans.
• Compatible Distros: Run on base OS without containerization support: EL 7, 8, 9 and Rocky, Alma, CentOS, OracleLinux,… and Ubuntu 20.04 / 22.04 and Debian 11 / 12 Support.
• Open-Source RDS: Free software open-sourced under the AGPLv3 license, a free RDS for PostgreSQL alternative.

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

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.

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.

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 Assistant is a multi-database development and administration platform supporting PostgreSQL versions 9.0 and up.

Key features
* Advanced development IDE featuring 6 generation SQL intellisense, interactive code snippets and generators, code refactoring, and many other functions
* Graphical schema management
* Graphical database modeling
* Performance monitoring and code profiling tools
* Data analytics and reporting
* ETL and data automation for schema and data migrations between different database types
* Visual database documenter
* Advanced schema comparison and cloning
* Multi-database code deployment
* Data obfuscation and sanitation
* Database benchmarking and unit testing
...

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.

The TDK provides a secure, privacy-preserving, tailored version of production data that can be used for many purposes, including creating a privacy-complaint replica of production data for development, testing, and data engineering, and generating large amounts of data for performance testing and load testing.

Designed for DBAs, productivity and engineering teams, it gives users the ability to generate structured production-like data at the database level, replicating database structures and maintaining key features like referential integrity while also preserving data privacy.

Key features

• Data generation, if you do not have enough production data in the test environment - this will allow you to test your applications, including functional and loading tests
• Subsetting - creating a small slice of data from a large production database while preserving all data relations and properties
• Masking - allows you to test, analyze, and share your production data securely

Try it

You can try TDK for free by downloading the tool from this page. Follow the instructions for Installation and Getting started. Additionally, there are other installation and usage options for TDK:

• Docker image
• Helm chart
• Amazon Web Services
• Google Cloud Platform

Demo projects

We have various demo projects with different levels of complexity to provide a simpler way to start using TDK in your environments:

• tdk-demo-postgres - Try TDK in action with legendary Pagila sample database
• tdk-demo-vault - The simple demo with Hashicorp Vault as a secret manager to store and manage database credentials
• tdk-demo-oracle - Masking data in an Oracle database and converting it to a PostgreSQL database
• springjdbc-tc-tdk - The simple Java application with TDK and Test Containers for integration testing
• flyway-spawn-demo - Testing Flyway database migrations
• tdk-microservices-demo - The example of using TDK in a distributed SOA application

Contacts and Feedback

If you have any issues, feature requests, or would like to purchase a license, please email us at support@synthesized.io

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.

Build data entry forms and sheets using Visual DB.

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

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

Visual DB 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 Visual DB — database form builder.

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