The PostgreSQL Client package works on the client side to connect to servers, while the PostgreSQL Server package allows your system to set up and host your own databases. Oder mit apturl installieren, Link: apt://postgresql-client. Your home directory, so that you can use the postgresql-common tools without root privileges. Postico 1.3 – A modern PostgreSQL client. January 4, 2018. Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike. Postico will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views. Start with the basics and learn about. Not all client APIs support all the listed character sets.For example, the PostgreSQL JDBC driver does not support MULEINTERNAL, LATIN6, LATIN8, and LATIN10. The SQLASCII setting behaves considerably differently from the other settings. When the server character set is SQLASCII, the server interprets byte values 0–127 according to the ASCII standard, while byte values 128–255 are taken.
This page is a list of miscellaneous utilities that work with Postgres (ex: data loaders, comparators etc.). Things that don't do queries' 'enter SQL and get it back out again.'
If you'd like to find clients that allows you to 'enter SQL and get it back out again' see PostgreSQL Clients.
If you'd like to find DB visualization or design tools see Design Tools.
This is the list of 'open source and free' miscellaneous utilities:
Supports MySQL/MariaDB, Adabas D, MS Access and PostgreSQL, as well as other JDBC/ODBC databases.
Java (multi-platform).
Open-source software which provides graphical view of active session history and help you to answer questions like 'What wait events were taking most time?', 'Which sessions were taking most time?', 'Which queries were taking most time and what were they doing?'. It also supports Active Session History extension by pgsentinel. Does not do DB inserts, modifications, etc.
MacOS (based on Electron, so versions for other OS can be build from source code).
Open-source software which allows you to easily understand what can do (and what can't) a PostgreSQL user with a table's data. In other words, it's a viewer of results of GRANT commands and row-level security rules applied for a particular table and for a particular role. Only modifies user rights, no other capability.
Gnu/Linux Windows (Other OS can compile from source code).
Build a powerful database applications following few steps using Sohag Developer .Sohag Developer currently supports PostgreSQL database and has a set of CRUD generators that generates (Qt/C++ code and ui forms - PHP web applications uses web forms and bootstrap framework ) to manipulate the data in the database tables or views.
Beekeeper Studio is a modern cross-platform SQL editor and database manager available for Linux, Mac, and Windows. Some of its features include:
This is a list of 'closed source' projects, some might have some manner of free version.
Windows
Yes, you can use MS Access as a PostgreSQL database interface. Supports data access to PostgreSQL tables and views; many ODBC-based limitations and errors.
Microsoft Windows 2000/XP/2003/Vista and Windows 7, 8, 10

dbForge Studio for PostgreSQL by Devart is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface. The tool also provides functionality for PostgreSQL data reporting, data editing, data import and export, building pivot tables and master-detail relations.
Key features:
Microsoft Windows 2000/XP/2003/Vista and Windows 7, 8, 10
dbForge Data Compare for PostgreSQL by Devart is a tool for table data comparison and synchronization. When using PostgreSQL data compare tool developer can detect data differences in compared PostgreSQL tables; generate data synchronization script and execute it to eliminate all these differences.
Key features:
Microsoft Windows 2000/XP/2003/Vista and Windows 7, 8, 10
dbForge Schema Compare for Amazon Redshift and PostgreSQL is a tool for easy and effective comparison and deployment of Redshift database structure differences. The tool 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:
macOS, Windows, iOS
TablePlus is a modern, native tool with elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.
Windows, Macintosh, Linux
WaveMaker is an Ajax-based GUI design tool for Postgres. WaveMaker is built using itself! WaveMaker generates a standard Java WAR file based on Spring, Hibernate and Dojo. WaveMaker supports Postgres schema creation and import and includes a visual query editor.
Windows, Mac & Linux
A comprehensive tool for identifying the differences between databases and generating an update script to synchronize them. Postgres Compare reads the system catalogs to determine the structure of the database and compares it to another to find the changes. Generate SQL and deploy the alterations, save snapshots for later. Automate the process via the command line.
Database conversion and synchronization between PostgreSQL and Microsoft Access, dBase, FoxPro, Microsoft Excel, Firebird, Interbase, MySQL, Oracle, Paradox, Microsoft SQL Server, SQL Server, SQL Server Azure, SQL Server Compact(SQLCE), SQLite, Delimited text files (CSV), XML and many more via ODBC.
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.
Key features:
Replicator allows table data comparison and sync - even with heterogeneous databases. It is unique in the fact it can replicate changes only even if source is non-relational (CSV, DBF, Excel documents, Paradox...). Replicator has a built-in scheduler for easy periodic change replication.
Windows
Admin
Freeware, available for PostgreSQL and MySQL, allows managing all aspects of the database: db, table, triggers, functions, etc. Includes import/export wizards to migrate data and structure to/from other database engines. Developed by DBTools Software.
Windows
PostgreSQL PHP Generator is a freeware but powerful PostgreSQL GUI frontend that allows you to generate high-quality PHP scripts for the selected tables, views and queries for the further working with these objects through the web.
http://convertdb.com/postgresql has PostgreSQL export/ import tools
Windows
The software is able to connect to remote PostgreSQL 9.x/7.4 located on Linux, Solaris, Mac OS X, and Windows.
ConvertDB cross-database migration tools assist in data conversion and synchronization among PostgreSQL, MySQL, MS SQL Server, MS Windows SQL Azure, and MS Access databases
Windows
dotConnect for PostgreSQL, formerly known as PostgreSQLDirect .NET, is an enhanced ORM enabled data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.
Key features:
Windows
PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi, C++Builder, Lazarus (and Free Pascal) on Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms. PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries.
Native Connectivity to PostgreSQLPgDAC is a complete replacement for standard PostgreSQL connectivity solutions and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to PostgreSQL. It provides direct access to PostgreSQL without PostgreSQL Client.
Windows
Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from Windows, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes the interaction of your database applications with PostgreSQL fast, easy and extremely handy.
Windows
Devart Excel Add-in for PostgreSQL allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to PostgreSQL. It enables you to work with PostgreSQL data like with usual Excel worksheets, easily perform data cleansing and de-duplication, and apply all the Excel's powerful data processing and analysis capabilities to these data.
Windows
PostgreSQL Tools Products Family:
Windows
SQL Maestro Group offers a number of tools for PostgreSQL.
SQL Maestro Group also produces similar tools for MySQL, Oracle, MS SQL Server, SQLite, Firebird, DB2, SQL Anywhere, and MaxDB.
Windows
Datanamic DataDiff for PostgreSQL is a utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely. Flexible comparison and synchronization settings will enable you to set up a customized comparison key and to select tables and fields for comparison and for synchronization.DB Data Difftective can be used for data migrations, verification of (corrupt) data, data auditing etc.
Windows
Datanamic SchemaDiff for PostgreSQL is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences (generators), stored procedures, triggers and constraints between two databases.
Windows
DB MultiRun is a simple tool to execute multiple SQL scripts on multiple databases quickly.Define a list of databases, add SQL scripts to execute on these databases and click 'execute' to run those scripts on the databases in the list. The multi-threaded execution of the SQL scripts makes it complete the task fast. After execution of the scripts, you can examine the results of the executed scripts on each database.
Windows
DB Doc helps you document your database schema and generate shareable PDF, HTML, XML, and Microsoft Word document in only 5 steps. Furthermore, the layout of the generated documents are customizable.
Windows
SQL Blob Export exports unlimited images and files from your tables or queries in 5 simple steps.
Windows
SQL File Import allows you to upload files, images, and other data into your database, without having to write any SQL statements. SQL File Import supports PostgreSQL, Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL).
A scripting engine allows you to transform data before importing them into your database. A command line version is also included to allow you to perform unattended upload/import tasks.
Windows
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 perform unattended scheduled exports of binary data.
Windows
SQL Multi Select is a query tool that allows you to run multiple scripts on multiple servers with a single click. Result sets from different servers are consolidated into a single view, allowing for easy comparison and analysis.
Windows
Devart SSIS Data Flow Components for PostgreSQL allow you to integrate database and cloud data via SQL Server Integration Services (SSIS).
Devart SSIS Data Flow Components provide easy to set up cost-effective data integration using SSIS ETL engine. They provide high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.
Windows, Mac OS X, Linux
Postgres Enterprise Manager is the only solution available today that allows you to intelligently manage, monitor, and tune large scale Postgres installations from a single GUI console.
Monitoring features include: server auto-discovery, over 225 pre-configured ready to run probes, custom probes, alert management, personalized alerts, remote monitoring, versatile charting, custom dashboards and web client.
DBA tools include: database objects management, Postgres Expert (best practice configuration settings), Audit Manager, Log Manager, Log Analysis Expert, Capacity Manager and Team Support.
Developer tools include: Query Tool, Data Grid, SQL Profiler, SQL Debugger and Import tools.
Tuning tools include: At-A-Glance performance dashboards, Tuning Wizard, Performance Diagnostics and Index Advisor.
ClusterControl is an all-inclusive open source database management system that allows you to deplore, monitor, manage and scale your database environments. ClusterControl provides the basic functionality you need to get PostgreSQL up-and-running using our deployment wizard, monitoring and basic management abilities like automatic failover, backups, and restores.
Reportizer is a database reporting tool, which allows easy creating, modifying, and printing database reports from different types of databases, including PostgreSQL. Reports can be edited in convenient visual report builder or in text mode. It supports calculating fields, multi-column reports, expressions, grouping, displaying images etc. Reportizer can export reports to HTML, XLSX, image, or internal format. There is an ability to load and print reports from command line. Reportizer allows to manage report collections, which can be held either in files or in database tables.
Exportizer Enterprise is a database export tool, which can work with PostgreSQL database either as source or destination. It allows to export data to database, file, clipboard, or printer.
TiCodeX SQL Schema Compare is a tools that allows database administrators to compare multiple database schema in order to manage versioning.
The software runs on Windows, Linux and Mac and supports Microsoft SQL (MS-SQL), MySQL, PostgreSQL, Azure SQL and MS-SQL on Amazon RDS.
Key Features:
pgMustard is a performance tool for PostgreSQL that provides a user interface for your EXPLAIN ANALYSE output, as well as tips on what to do to speed up your query.
Features:
Requirements:
The CData ODBC Driver for PostgreSQL enables real-time access to PostgreSQL data, directly from any applications that support ODBC connectivity, the most widely supported interface for connecting applications with data. The driver wraps the complexity of accessing PostgreSQL data in a standard ODBC driver compliant with ODBC 3.8. The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
The CData JDBC Driver for PostgreSQL offers the most natural way to connect to PostgreSQL data from Java-based applications and developer technologies. The driver wraps the complexity of accessing PostgreSQL data in an easy-to-integrate, 100%-Java JDBC driver. The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

The CData ADO.NET Provider for PostgreSQL offers the most natural way to access PostgreSQL data from .NET applications. The provider wraps the complexity of accessing PostgreSQL data in an easy-to-integrate, fully managed ADO.NET Data Provider.The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
The CData Excel Add-In provides the easiest way to connect to PostgreSQL data from Excel. From the CData ribbon, you can select PostgreSQL data as tables and columns into the spreadsheet. The spreadsheet is then linked with the remote data. To update the data, edit the spreadsheet.
The CData SSIS Components for PostgreSQL enable you to connect SQL Server with PostgreSQL data through SSIS Workflows. The components wrap the complexity of accessing PostgreSQL data in standard SSIS data flow components. You can then connect and synchronize PostgreSQL tables with SQL Server tables.The components hide the complexity of accessing data and provide additional security features, smart caching, batching, socket management, and more.
The CData Power BI Connector for PostgreSQL offers self-service integration with Microsoft Power BI. The connector facilitates live access to PostgreSQL data in Power BI from the Get Data window. The connector also provides direct querying to visualize and analyze PostgreSQL data.
PostgreSQL Clients - list of UI's for accessing your db contents (enter sql, get back the results)
Design Tools - tools for designing and visualizing database schemas
Old possibly abandoned projects, see Community_Guide_to_PostgreSQL_Tools_Abandoned