Postgres client for windows

Interactive installer by EDB

Download the installer
certified by EDB for all supported Postgres versions.

Note! This installer is hosted by EDB and not on the PostgreSQL community servers.
If you have issues with the website it’s hosted on, please contact
webmaster@enterprisedb.com.

This installer includes:

• The PostgreSQL server
• pgAdmin, a graphical tool for managing and developing your databases
• StackBuilder, a package manager for downloading and installing
  additional PostgreSQL tools and drivers. Stackbuilder includes management,
  integration, migration, replication, geospatial, connectors and other tools.

This installer can run in graphical or silent install modes.

The Windows installer is designed to be a straightforward, fast way to get up and running with
Postgres. In the unlikely event that you have issues with the installer,
please report them on the
installer Github page. Issues with the installed packages should be reported to the
appropriate project directly.

Advanced users can also download a
zip archive
of the binaries, without the installer.
This download is intended for users who wish to include Postgres as part of another application installer.

Platform support

The installers are tested by EDB on the following platforms.
They can generally be expected to run on other comparable versions,
for example, desktop releases of Windows:

This page is a partial list of interactive SQL clients (GUI or otherwise) — that doesn’t include reporting engines, ETL data loaders, or visual design tools, just interactive clients that you can type SQL in to and get results from them. This includes web based or desktop apps.

If you are looking for language interfaces / drivers, please see List of drivers.

Cross-platform GUI Clients

Open Source

These clients are both «free» and «open source»

Beekeeper Studio

https://beekeeperstudio.io/

Beekeeper Studio is a modern cross-platform SQL editor and database manager available for Linux, Mac, and Windows. Some of its features include:

• Clean, smooth, usable UI with dark and light themes
• Tabbed Interface
• Multiple connections at the same time
• Saved queries and run history
• Auto-complete

pgAdmin 4

http://www.pgadmin.org/

pgAdmin 4 is a ground-up rewrite of pgAdmin 3. Rather than being a native application it’s primarily a web application that’s also packaged as desktop web shell. But runs locally.

Postbird

Open source, desktop application to manage your local or remote PostgreSQL databases.

https://github.com/paxa/postbird

Sqlectron

windows/linux/OS X

A simple and lightweight SQL client desktop/terminal
with cross database and platform support. GUI or term.

https://sqlectron.github.io/

SQuirrel

http://www.squirrelsql.org/

Platforms that support Java

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. The minimum version of Java supported is 1.8.x as of SQuirreL version 3.8.1.

Commentor 1: If it doesn’t start in OS X (like nothing appears) see https://sourceforge.net/p/squirrel-sql/bugs/1398/

pgAdmin 3

http://www.pgadmin.org/

Windows, Linux, FreeBSD, macOS, OpenBSD, Solaris

For many years the «standard» freely available GUI client for Postgresql, and so is bundled in many packaged installers. It provides a SQL query tool, an editor for procedural languages and a CRUD interface. It’s also one of the few clients to provide a GUI front end to the plpgsql debugger.

Free Administration Centre for the PostgreSQL database. Includes a graphical administration interface, an SQL query tool, a procedural code editor and much more. pgAdmin III is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. Available in more than 30 languages and for several operating systems.

pgAdmin III is an Open Source management tool for PostgreSQL databases. Features full Unicode support, fast, multithreaded query and data editing tools and support for all PostgreSQL object types.

pgAdmin III is bundled with the Windows installer on older versions of Postgres, and you can use that as a client to administer a remote server on another OS. Note that binary packages for platforms like RPM don’t show up in every point release, you currently have to go back to v1.8.0 to get the last full set of packages.

Development has been discontinued by pgadmin.org, but is still being maintained by BigSQL who are doing basic maintenance to support newer versions of PostgreSQL and packaging it for current OS releases [here].

Tora

http://tora.sf.net/

Linux, Windows, macOS

Oracle, MySQL, and PostgreSQL, as well as limited support for ODBC targets. Inspired by the proprietary Toad client.

SQL Workbench/J

http://www.sql-workbench.net

Java

An OpenSource (though it prohibits usage by government agencies from USA, UK, Canada, China, Russia, North Korea, Syria, Saudi Arabia, Turkey and the Chechen Republic) SQL GUI tool similar to Squirrel. Data can be edited directly in the result set. It has strong support for exporting and importing data between databases using its own SQL command extension. It can be used in GUI mode or as a console application. All SQL Workbench specific commands can also be run in batch mode to automate export and import task. It supports schema comparison («diff») and copying data between databases.

It has some restrictions on use by government employees.

DBeaver

DBeaver

Java

Supports many SQL databases from different vendors, as well as few NoSQL ones (Cassandra, etc).
Good query editor with syntax highlighting, completion and autosave.
Editing of query results. SSH tunneling support. Tons of other cool features.
Quite good, but not 100% perfect PostgreSQL support (yet?).

Has a free community and also «pro» version available.

PgManage

https://github.com/commandprompt/pgmanage

Modern multi-platform database administration tool/database client primarily focused on PostgreSQL

Supported platforms: Linux X86_64; Windows 10 X86_64; Mac OS X

PgManage features:

• Multi-workspace, multi-tabbed user interface
• SQL code auto-completion and formatting
• Database Entity-relationship Diagrams
• Postgres back-up/restore, configuration management, role management, performance metric dashboards etc
• Query history
• Reusable code snippets
• SSH connection tunneling
• PSQL-like Database console
• and more

Proprietary

These are «closed source» apps, some offer free demo’s.

dbForge Edge

https://www.devart.com/dbforge/edge/

Microsoft Windows, Linux, macOS

dbForge Edge is a multidatabase solution supporting PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, and a wide range of cloud services. It covers a variety of database development, design, management, and administration tasks with a rich set of features:

• Database Development: SQL code completion, debugging, and schema design for various database systems
• Data Management: Viewing, editing, import, export, and migration of data between databases and cloud platforms
• Database Operations: Comparison, analysis of differences, and synchronization of database schemas and table data
• Reporting and Data Analysis: Generation of detailed data reports, analysis of data trends, and aggregation of data in pivot tables
• Automation: CLI-powered automation of backup, synchronization, and migration operations

DBX

https://getdbx.com

MacOS, Linux, Windows (Coming Soon)

DBX is a lightweight database client with the following features:

• AI Chat (BYO API Keys)
• Query Editor
• Schema Visualisation
• Table Viewer
• Command Palette + Hotkeys

DbVisualizer

https://www.dbvis.com/

PostgreSQL

Windows, MacOS, Linux, Unix

DbVisualizer is the a universal database tool that connects to all major databases and JDBC drivers including PostgreSQL. It has the highest user satisfaction on G2.com. It provides features to write SQL to query and visualize your data, design and development features to manage your databases, tables, relations, indexes, triggers, users and much more. Free and Pro edition available.

• High user satsifaction on G2
• Visual query builder using drag and drop
• Query optimization with an explain plan feature
• Table data editing in spreadsheet
• Visual rendering of primary/foreign keys
• Simple navigation of database objects and their properties
• Flexible user interface in light and dark themes
• SQL formatting
• Command-line interface for headless execution
• Flexible SQL scripts execution with parameter support
• and more…

Zing Data

https://www.getzingdata.com/

iOS, Android, Web

A native mobile app to visually query PostgreSQL databases (without having to write SQL), visualize results, view data tables, and collaborate with team mates using mentions and shared questions.
Supports:

• SmartGraphs which automatically apply a visualization based on your query result (or can be changed)
• Exporting graphs and CSVs of data tables on a mobile device
• Collaboration tools, such as chat, @mentions, and shared dashboards
• Support for long-running queries, where a user will get a push notification when the query is complete
• Multiple data sources at one

Zing Data is available for free for the first ten users in an organization.

PgManager

http://www.ems-hitech.com/pgmanager

Windows, Linux

Basically a proprietary, more powerful version of PGAdmin II or PGAccess. Adds support for trigger and constraint editing, metadata logging, and query monitoring. Also includes multiple-format data import/export tools, which are also available on their own for Linux. Developed by EMS Hitech. (JMB 4.2003).

Valentina Studio (Free)

Windows/OS X/Linux/

Valentina Studio is a powerful PostgreSQL Database Server administration and development tool. It offers for free many advanced editors:

• Schema Editor with Tree and Column views
• Diagram Editor with reverse engineering
• SQL Editor with auto-completion, syntax-highlighting, recent and favorite queries, templates of commands, many result tab-panels, …
• Data Editor with easy sorting and filtering of records without SQL, in-cell editing.
• Related Data Editor that allow s you to learn related records in different modes.
• Import/Export
• SQL dumps
• and so on …

Valentina Studio PRO — adds additional advanced features as:

• Report Editor to developer reports based on Valentina Report Engine with datasources from PostgreSQL and other databases.
• Diagrams forward engineering
• SQL DIFF
• Data Transfer

RazorSQL

http://www.razorsql.com/

Macintosh/Windows/Linux/Solaris

RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool that supports PostgreSQL and any other JDBC or ODBC compliant database. Some of the major features are tools for creating, dropping, and altering objects such as tables, views, indexes, triggers, functions, users, and databases; a programming editor that supports 20 different programming languages; import and export tools; auto column and table lookup; and a query builder, query scheduler, and SQL formatter.

JetBrains IDEs — DataGrip, IntelliJ IDEA, PHPStorm, PyCharm, RubyMine, etc …

http://www.jetbrains.com/

Windows, Mac OS X, Linux

JetBrains has a dedicated SQL IDE — DataGrip which can connect to PostgreSQL as well. It provides code completion, multi cursors, local query history, navigation, refactorings and language injection support.
https://www.jetbrains.com/datagrip/

Other JetBrains Products, for example, PHPStorm, IDEA, have built-in database plugin, and it has the same functionality as DataGrip.

After you configured the data sources of your project, you can easily create tables, foreign keys, indexes much easier than usual, because the IDE is very smart; for example by foreign keys it automatically sets the name of the key and the related columns. For me, it is so far the best experience by creating a basic database schema. Even with editable EER models was it slower…
By the settings of your data source you can configure the SQL dialect of your database. After that, if you want to add stored procedures or triggers, you will have code completion which is favorable too. So I think JetBrains products speed up your work if you exactly know what you want, and how can you make it.

For any JetBrains IDE, there is a free license for open source projects. For enterprise usage there is a 30 days trial, after that, you can buy a personal or proprietary license which is very cheap compared to other products.

Aqua Data Studio

https://www.aquafold.com/aquadatastudio

Java: Windows/Linux/macOS/Solaris

Aqua Data Studio is a management tool for the PostgreSQL relational database w/ administration capabilities and a database query tool. The visual administration features provide users the ability to browse and modify database structures, including schema objects, database storage and maintain database security. An integrated query tool allows users to quickly create, edit and execute SQL queries and scripts. Aqua Data Studio also provides an import and export tool to allow users to easily move data in and out of the PostgreSQL database in and from different data formats.

Navicat

https://www.navicat.com/en/products/navicat-for-postgresql

Windows, macOS, iOS, Linux

Navicat is a powerful PostgreSQL Database Server administration and development tool. It works with PostgreSQL 8.0 version or above and supports most of the PostgreSQL features including Trigger, Function, View, Manage User, and so on. It is also not only sophisticated enough for professional developers, but also easy to learn for new users. With its well-designed GUI, Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way.

Version 15 introduces Smart Charts, a more powerful Data Transfer, Query Builder, New Data Modeling Tool, Dark Mode, and Native Linux support.

Datazenit

https://datazenit.com/

Windows, Mac OS X, Linux

Datazenit is a cross-platform PostgreSQL and MySQL GUI with data grid, schema builder and interactive charts.
It also has query builder, raw query editor with auto-complete, team collaboration features like connection, query and chart sharing among team members.

Available packaged as a desktop app.

Quest Toad Edge

https://www.quest.com/products/toad-edge/

Windows & Mac OS X

PostgreSQL, MySQL and MariaDB support.

• Object and user management
• Code quality checks
• Database devops: Jenkins plug-in
• SQL query monitor
• Shema compare and sync
• Advanced JSON editor
• SQL worksheet
• Import/Export
• Database snapshot
• 24/7 support

Kangaroo

https://dbkangaroo.github.io/

Supports SQLite 3.x, MySQL 8.0, MariaDB 10, PostgreSQL 11.
Query, Editing, Designer, Export+Import = Full support. Hint, modeling and DB sync are on the roadmap.
Windows, Linux, MacOS X

DbSchema

https://www.dbschema.com/

windows/linux/OS X

A visual PostgreSQL designer and GUI client, featuring diagrams, schema design in a team, deployment on multiple databases, HTML5 documentation, and more.

• The schema structure is saved to a model file, which can be deployed on other databases or shared in a team
• HTML5 documentation with the diagram vector image
• Relational Data Explorer, with related data views from multiple tables
• Visual Query Builder
• Virtual foreign keys
• SQL Editor featuring text-autocompletion
• Random Data Generator, Data Loader, CSV Editor
• Support for multiple databases

DbSchema has a free and Pro version, which you can evaluate for 30 days.

WebDB (free)

https://webdb.app

Free and efficient database IDE built with exclusive features like

• Easy Server Connection
• ERD Generator
• Intelligent data generator
• IA integration
• NoSQL structure inferring/editor

And Other features at the top of the market

• Many databases supported (MySQL, Postgre, MongoDB, etc)
• Powerful queries editor

Available on docker and all popular platform/arch

macOS GUI Clients

Clients compatible with only OS X.

Open Source and Completely Free Software

(empty list)

Proprietary

Some of these have a «free» tier (typically somewhat crippled). Some are fully free.

SQLPro for Postgres

http://www.macpostgresclient.com/SQLProPostgres

macOS 10.8 and above

Features:

• 100% native OS X app with a clean and simple to use interface.
• Query editor with syntax highlighting and autocomplete.
• Support for multiple result set execution.
• History feature, displaying your last ten executed queries.
• Primary key detection for inline result set modifications.
• Custom theme support allowing developers to work with style.

TablePlus

https://tableplus.com/

A modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases, including PostgreSQL. Available on macOS, Windows, and iOS.

• True native built.

• Workspace supports multiple tabs, multiple windows

• Powerful SQL editor with full features: auto syntax highlight, auto-suggestion, split pane, favorite and history.

• Data Filter & Sorting, import & export

• Full-dark theme & modern shortcut

With plugin system, you can be able to write your own new features to work with database per your needs (export charts, pretty json…).

Postico

https://eggerapps.at/postico/

A nice native client by the developers of Postgres.app. A free «demo» version of an inexpensive proprietary app, but it has very reasonable limits («only one tab») and no time limit.

Postico is a fully native Mac app for connecting to your PostgreSQL server. It supports encrypted connections via SSL and SSH to PostgreSQL 8.0 and later, including Amazon Redshift.

Postico has a powerful table content editor with in-cell editing and form-based row editing in a sidebar. You can quickly filter tables by keywords or even complex SQL expressions.

There’s also a table structure editor for editing columns, types, default values, foreign keys, check constraints etc.

Finally, there’s a convenient SQL Query Editor with support for query history and syntax highlighting. It also has convenience features like auto-indent and shortcuts for comment line etc.

PSequel (free)

http://www.psequel.com/

OS X Yosemite+, free not crippled. Last update: 2018. Seems abandoned. Native OS X

SEQUEL for PostgreSQL

http://www.sequel.tech

SEQUEL for PostgreSQL is a professional DB administration and management tool, with extremely intuitive and feature-rich GUI that makes it the best assistant tool for developers and admins. SEQUEL is lightweight, fast and powerful that it can significantly simplify the DB management process. For those who cannot live without a CLI, SEQUEL offers a powerful Query Editor with syntax highlight, autocomplete and a Console log view that is always visible, so you can monitor the communication with your databases. It includes:

• Database management forms for Schema, Table, Index, Foreign key, Trigger, Rule, Sequence, Collation, Domain, Enum type, Tablespace and Language objects with full parameters support
• Assistant info views for Object information, Actions, Help, and Documentation
• Jump bar for quick objects selection and navigation
• Taskbar with multi-task monitoring support
• Console log view
• Syntax highlight, autocomplete, current and selection query execution and explain, line numbering and working statement detection
• Direct editing in the results view, query results explanation
• Powerful Field editor
• Transaction based database updates
• Code preview and Content editing

Windows GUI Clients

Clients compatible with only windows.

Open Source / Free Software

HeidiSQL

https://www.heidisql.com/
https://github.com/HeidiSQL/HeidiSQL

HeidiSQL is a lightweight Windows desktop application with support for PostgreSQL since 2015. Also supports MySQL, MariaDB, MS SQL Server and SQLite. HeidiSQL focuses on simple structure editing and grid based data editing, but also has some advanced features:

• Session management with folder support
• Multiple connections per window
• Browse through databases and tables, views, procedures and triggers
• Edit columns, indexes and foreign keys of tables
• Provides special editors for fields with various data types: text, date/time, enum, set, binary.
• Query tabs for running custom queries
• Completion proposal
• Displays multiple results per tab
• Keeps a history of executed queries
• SQL export directly to .sql file, another database, or to a different server
• Quick grid export for Excel, CSV, HTML, XML, LaTeX, Wiki markup, PHP, Markdown, JSON
• Search for text in a database, or on a whole server
• Import textfiles
• Reformat custom SQL queries

Proprietary

dbForge Studio for PostgreSQL

https://www.devart.com/dbforge/postgresql/studio/download.html

dbForge Studio for PostgreSQL is all-in-one IDE designed for effective database development and management. The tasks that can be handled with its help include completion-aided SQL coding, comparison and synchronization of databases, data management, data analysis and reporting, query optimization, and test data generation.

Key features:

• SQL Development: Increase the speed and quality of your coding with context-aware SQL completion, formatting, and syntax validation.

• Database Comparison: Compare database structures and table data; generate scripts to synchronize source and target databases.

• Data Management: View, edit, group, sort, filter, import, and export your data with convenience.

• Test Data Generation: Populate your databases with newly generated test data in a matter of moments.

• Query Profiling: Identify and eliminate performance bottlenecks in slow queries.

• Data Analysis & Reporting: Create pivot tables, visualize data trends and dependencies, and generate visual data reports.

• Availability: Run dbForge Studio on Windows, Linux, or macOS (the latter two options are enabled via a compatibility solution called CodeWeavers CrossOver).

Database Tour Pro

https://www.databasetour.net

Database Tour Pro is a database tool with built-in report builder for Windows. It works with different types of relational databases including PostgreSQL.

Key features:

• Creating tables.
• Viewing and editing data.
• Several ways to print data.
• Built-in report engine and visual report designer with templates, expressions, preview etc.
• Expression builder for report and export expressions.
• Building and executing SQL queries. Support for execution of multi statement SQL scripts. Syntax highlighting in SQL editor. Support for parameterized SQL queries.
• Enhanced database grids, which allow to view and manipulate the data in the most convenient way, including sorting by clicking column header, changing row heights, resizing columns etc.
• Command line support for executing queries, opening tables, export-import operations, loading reports etc. with logging the performed operations.
• Searching and replacing text in database with ability to choose fields, record range etc.
• Importing data to table from another table or a query.
• Exporting data from open table or query to file(s) like text, CSV, HTML, XLSX, XML, RTF, DBF or to another relational database of any supported type (i.e. ODBC, PostgreSQL, Oracle, SQL Server, dBase, Interbase, SQLite, MS Access, Firebird etc).
• Copying data to clipboard.
• Viewing and editing Blob data, such as large text and graphics.
• Tools for editing text fields (trimming, changing case of symbols, replacing text).
• Customized data view (font, background).
• Conditional formatting data in database grids and reports.
• Ability to control transactions.

SQLGate

https://www.sqlgate.com/product/download

Windows

SQLGate is a simple but powerful IDE for multiple Database including PostgreSQL.

• Powerful Data Grid and ERD
• Multiple SQL Execution
• Auto-Complete
• Intuitive UI/UX
• Multiple Themes
• Fast processing speed

Use SQLGate to maximize your productivity!

Datazenit

https://datazenit.com/

Java

Datazenit is a cross-platform PostgreSQL and MySQL GUI with data grid, schema builder and interactive charts.
It also has query builder, raw query editor with auto-complete, team collaboration features like connection, query and chart sharing among team members.

Web-based, but available packaged as a desktop app (linux, Mac, windows)

EMS SQL Manager for PostgreSQL Freeware

http://www.sqlmanager.net/en/tools/free

EMS SQL Manager for PostgreSQL Freeware (EMS SQL Manager Lite for PostgreSQL) is an excellent and easy-to-use freeware graphical tool for PostgreSQL database administration. It has the minimal required set of tools for those users who are new to PostgreSQL server and need only its basic functionality.
EMS SQL Manager for PostgreSQL Freeware allows you to work with servers, databases and schemas, view, edit, search, group, sort and filter any data stored in a database, create and execute SQL queries with powerful SQL editor, handle multiple selected objects at a time and much more.

There is a proprietary version available with significantly more functionality.

PostgreSQL Maestro

https://www.sqlmaestro.com/products/postgresql/maestro/

Allows you to create, edit, copy, drop and dump database objects easy and fast. You can also design your database as ER diagram, build queries visually, execute SQL queries and scripts, debug PL/pgSQL functions, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), manage PostgreSQL roles, users, groups and privileges, and use a lot of other admin tools designed for making your work with PostgreSQL database server comfortable and efficient.

Nucleon Database Master

Database Master

Nucleon Database Master is a modern, powerful, intuitive, easy to use and all in one PostgreSQL MongoDB, Oracle, DB2, Informix, Ingres, SQL Server, SQL Azure, MySQL, FireBird, SQLite client application with a consistent interface that simplifies managing, querying, editing, visualizing, designing and reporting relational and schema-free (NoSQL) database systems. You can connect any database system via ODBC and OleDB connections.Using Database Master, you can execute SQL, LINQ, JSON queries or you can create, edit and delete all database objects such as tables, views, procedures, columns, indexes, collections, and triggers. You can execute SQL queries and scripts, view and edit table data including BLOBs (Image, Text or any file), represent tables and its relations as an ER(Entity Relationship) diagram.

SQLPro

http://www.vive.net/products/sqlpro.htm

SqlPro is an easy to use database GUI tool for six popular databases (Oracle, MySQL, PostgreSQL, SQL Server, SQLite, and Access). One IDE makes database administration and development faster and error free.
SQLPro Key Features: color-coding of the SQL, drag-and-drop of objects into the editor pane to save you from typing their names, retrieval of SQL code for things like stored procedures and triggers from the underlying database, and one-click creation of SELECT and INSERT statements. You can open, save and print SQL scripts.
SQLPro uses native drivers to connect to the databases (no ODBC or third party engines to install).

SQL Data Analysis

https://www.yohz.com/sda_details.htm

Windows

SQL Data Analysis is a business intelligence tool that helps you see and understand your PostgreSQL data.

• Connect to your PostgreSQL database, run your query, and visualize your data in seconds.
• Analyze your data with intuitive drag & drop interface. No programming, just insights.
• Cross database queries allow you to join a PostgreSQL data set with another database’s data set (SQL Server, Oracle, MySQL, etc).
• Flexible layouts allow you to combine multiple data views to best visualize your data.
• Share and export your discoveries and insights to PDF, Excel, and HTML files.
• Multi database engine support — connect to SQL Server, Oracle, MySQL, MariaDB, SQLite, Access, and any ODBC-supported database

SQL Data Analysis helps you transform data into actionable insights. Free trial available at https://www.yohz.com/sda_details.htm

Web Clients

Web clients run as a server on your desktop and you connect to them via a web browser. This also allows things like coworkers to connect as well. You can run SQL against servers and back the results (in your browser).

Open Source

These are open source and free:

phpPgAdmin

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

http://phppgadmin.sourceforge.net/doku.php

franchise

https://franchise.cloud/

Web client, either hosted (free) or running locally, connects to a local postgresql instance via a small bridge application.

Can share the interface with others, rather like sqlfiddle.com, but accessing your database.

pgAdmin 4

http://www.pgadmin.org/

pgAdmin 4 is a ground-up rewrite of pgAdmin 3. Rather than being a native application it’s primarily a web application that’s also packaged as desktop web shell.

Adminer

http://www.adminer.org

PHP

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. A single PHP file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.

OmniDB

https://github.com/OmniDB/OmniDB

Django/Python on Linux, Windows and macOS.

Open source full-featured tool for database management. Currently supports PostgreSQL (9.3 — 13), Oracle (11g — 18c), MySQL (5.6 — 8.0) and MariaDB (10.1 — 10.3). More RDBMS support coming soon, including the ability of converting databases from any supported RDBMS to PostgreSQL and back.

SIDU

http://topnew.net/sidu/

PHP

Schema and data browser and editor.

Hisha

https://github.com/xshogi/hisha

Node.js

Hisha is cross-platform and web-based Postgre SQL Database client inspired by Adminium. You can edit and save result by clicking the cell you want and press enter when you finish.

Tadpole DB Hub

https://github.com/hangum/TadpoleForDBTools/wiki

Tadpole DB Hub is Unified infrastructure tool, a various environment based interface for managing Apache Hive, Amazon RDS, CUBRID, MariaDB, MySQL, Oracle, SQLite, MSSQL, PostgreSQL and MongoDB databases. It enables you to handle typical DB over the World Wide Web.

Features:

• Intuitive web interface (Safari, Chrome, IE 10, Firefox)
• User Management (Admin, Manager, User)
• Select, Insert, Update, Delete
• Download query result
• SQL Syntax Highlighting
• SQL Formatting
• SQL Statement <-> Java, PHP String Literal Each Convert
• SQL Assist
• Execute SQL Statement
• SQL Result Set to CSV
• SQL History And Export text
• Generate SQL Statement (Select, Insert, Update, Delete, Table, View, Index, Procedure, Function, Trigger)
• Generate ER Diagram (Auto Layout)

Proprietary

Some may be pay, some may have free demo.

Five

Home

Rapidly develop and deliver modern business software to internal or external users.

Five is free to use. Develop and test applications locally free of charge. Only subscribe when you build something production worthy.

Features:

• Store, retrieve and process data from any data source (such as a PostgreSQL DB)
• Rapidly implement business logic using SQL, JavaScript or TypeScript
• Cut down the time you spent on front-end development
• Scalable, secure and affordable: deploy apps in one click
• Keep your data secure on Five’s managed infrastructure
• Build password-protected multi-user applications
• Useful developer tools to accelerate your development

Free download available for Windows & MacOS

TeamPostgreSQL

http://www.teampostgresql.com

browser-based, webserver included

AJAX/JavaScript-powered web interface for PostgreSQL administration. Browse, maintain and create data and database objects from anywhere, in the web browser. Supports SSH for both the web interface and the database connections. Rich interface with tabbed SQL editor with auto-completion, inline row-editing widgets, click-through foreign key navigation between rows and tables, ‘favorites’ management for commonly used scripts, and more.

Installers available for Windows, Mac and Linux, alternatively download a simple cross-platform archive that runs anywhere with simple script.
Wasn’t clear where source code is.

JackDB

http://www.jackdb.com/

Html5 Web Browser (Linux/Mac OS X/Windows)

JackDB is a database client that runs entirely in your web browser. There’s no software to install locally so you can use it on Mac OS X, Linux, and Windows and it works on all major modern browsers (eg. Chrome, Firefox, IE, Safari, and Opera). It supports connecting to PostgreSQL, as well as MySQL, Oracle, and SQL Server databases.

Features:

• Html5 interface with no client installation
• Query editor with syntax highlighting
• Scrolling result sets
• Schema/Object browser
• SSL connections with certificate pinning
• Eliminates password sharing
• Two-factor authentication
• BLOB display (images and Html5 audio/video)

DBHawk

http://www.datasparc.com/

Web Browser (Linux/Mac OS X/Windows)

DBHawk is a web based SQL tool and reporting software designed for PostgreSQL, Oracle, SQL Server and other databases. Its easy to deploy and use.

Features:

• Web based interface with no client installation
• Advanced Query editor with syntax highlighting and multi tabs results
• Online visual query builder
• Online SQL Report Builder
• Online SQL Job Scheduler
• Export results to html, csv, pdf, google docs, amazon s3
• SQL Auditing and Security
• Schema/Object browser
• SQL and data snippet sharing
• Blob data viewer and editor

Datazenit

https://datazenit.com/

Datazenit is a cross-platform PostgreSQL and MySQL GUI with data grid, schema builder and interactive charts.
It also has query builder, raw query editor with auto-complete, team collaboration features like connection, query and chart sharing among team members.

Web-based, but available packaged as a desktop app (linux, Mac, windows)

CLI Clients

Open Source / Free Software

psql

https://www.postgresql.org/docs/current/static/app-psql.html

The standard command line client, maintained by the postgresql development group and typically distributed as part of the server installation.

pgcli

https://www.pgcli.com

A command line client with syntax highlighting and pop-up command completion.

jaqy

https://teradata.github.io/jaqy/

A universal JDBC command line client with lots of features. It is not specific to PostgreSQL, but it is pre-configured to handle PostgreSQL servers. Requires PostgreSQL JDBC driver.

Other Resources

Community Guide to PostgreSQL GUI Tools — Includes many miscellaneous non-client tools, such as bulk loaders, schema diff, schema design, etc.

Design Tools — tools for designing database schemas

List of drivers

Old possibly abandoned projects, see Community_Guide_to_PostgreSQL_Tools_Abandoned

Перевод публикуется с сокращениями, автор оригинальной
статьи Ilon Adams.

PostgreSQL – это
передовая открытая система управления объектно-реляционными базами данных.
В основном она используется на предприятиях и поддерживает запросы SQL и JSON.

У пользователя, есть два
способа администрирования СУБД:

• писать запросы через CLI (не всем это нравится);
• использовать графический пользовательский интерфейс (GUI) Postgres.

Второй вариант намного удобнее, т. к. он позволяет повысить производительность. Давайте рассмотрим
наиболее используемые инструменты GUI.

Графический интерфейс
PostgreSQL – это инструмент управления базами данных PostgreSQL. Он позволяет любому пользователю запрашивать и визуализировать данные, а также манипулировать данными и анализировать их. Вы можете получать доступ к серверам баз данных и
перемещаться по ним с помощью графического интерфейса.

Основные причины, по
которым пользователи предпочитают графический интерфейс:

• длинная кривая обучения работе с CLI и сложная адаптация;
• не очень приятный в использовании интерфейс командной строки;
• недостаток информации, которую консоль предоставляет за один раз;
• трудности при просмотре и мониторинге базы данных с помощью консоли.

Использование GUI дает следующие преимущества:

• ярлыки, которые можно использовать для быстрого доступа к данным;
• широкие возможности визуализации данных;
• удаленный доступ к серверу;
• легкий доступ к операционной системе.

Лучшее программное обеспечение с графическим интерфейсом

Прежде всего есть низкоуровневый
конструктор внутренних инструментов UI Bakery. Изначально он не был создан
для управления Postgres, однако с его помощью вы можете подключить
несколько источников данных (базы данных, сторонние приложения, REST API) в одном UI. Bakery обладает
широкими возможностями визуализации данных для отображения PostgreSQL, MongoDB,
MySQL, Microsoft SQL, Redis и т.д.

Подход с низкоуровневым
кодом к управлению базами данных гораздо более экономичен и гибок, чем использование
традиционных графических инструментов. Тем не менее, давайте
рассмотрим и другие продукты.

1. pgAdmin

Картинка с сайта: proglib.io

pgAdmin – кроссплатформенный графический инструмент с открытым исходным кодом.

Плюсы:

• совместим с Linux, Windows, macOS;
• позволяет работать с несколькими серверами одновременно;
• экспорт в CSV;
• планирование запросов;
• возможность отслеживать ваши сеансы, блокировки БД с помощью панели мониторинга;
• ярлыки в редакторе SQL для более удобной работы;
• встроенный отладчик процедурного языка;
• тщательная документация и активное сообщество.

Минусы:

• медленный и не всегда интуитивно понятный пользовательский интерфейс по сравнению с платными конкурентами;
• тяжелый;
• высокий порог вхождения;
• для работы с несколькими базами данных одновременно потребуются продвинутые навыки.

2. DBeaver

Картинка с сайта: proglib.io

DBeaver – инструмент управления PostgreSQL с открытым
исходным кодом, поддерживающий коннект к нескольким базам данных.

Плюсы:

• кроссплатформенность;
• поддержка более 80 баз данных;
• визуальный конструктор, позволяющий добавлять запросы без навыков работы с SQL;
• несколько представлений данных;
• импорт/экспорт данных в CSV, HTML, XML, JSON, XLS, XLSX;
• повышенная безопасность данных;
• полнотекстовый поиск данных и возможность отображения результатов в виде таблиц/представлений;
• доступен бесплатный тарифный план.

Минусы:

• низкая производительность по сравнению с конкурентами;
• слишком частые обновления, что раздражает;
• после некоторого времени бездействия DBeaver отключается от базы данных.

3. Navicat

Картинка с сайта: proglib.io

Интуитивно понятный (с
недавнего времени проприетарный) GUI для Postgres.

Плюсы:

• простая и быстрая установка;
• поддержка Windows, Linux, iOS;
• удобный визуальный конструктор SQL;
• автодополнение кода;
• инструмент моделирования данных: управление объектами базы данных, схемами проектирования;
• планировщик заданий: запускайте задания, получайте уведомления о завершении задания;
• синхронизация источников данных;
• импорт/экспорт данных в Excel, Access, CSV и другие форматы;
• защита данных с помощью SSH и SSL;
• использование облачных сервисов Amazon, Google и др.

Минусы:

• низкая производительность GUI;
• высокая цена по сравнению с конкурентами;
• одна лицензия ограничена одной платформой (вам понадобятся 2 отдельные лицензии для PostgreSQL и MySQL);
• множество дополнительных возможностей, требующих времени для изучения.

Navicat

4. DataGrip

Картинка с сайта: proglib.io

Продвинутая IDE для работы с несколькими базами данных, созданная в JetBrains.

Плюсы:

• кроссплатформенность (поддержка Windows, macOS, Linux);
• простая навигация по схеме;
• настраиваемый UI с консолью для обеспечения безопасности выполняемой работы;
• быстрое обнаружение ошибок;
• встроенная система контроля версий;
• поддержка MySQL, SQLite, MariaDB, Cassandra и других;
• отчеты с возможностью их интеграции с диаграммами и графиками;
• автодополнение кода.

Минусы:

• высокая цена;
• высокое потребление оперативной памяти;
• сложный процесс отладки ошибок;
• длинная кривая обучения;
• не предназначен для использования в качестве облачного веб-приложения;
• не подходит для одновременного управления несколькими базами данных.

DataGrip

5. HeidiSQL

Картинка с сайта: proglib.io

Инструмент с GUI и открытым исходным кодом для Postgres (и не только). Пока поддерживается только Windows.

Плюсы:

• простая установка, легковесная по сравнению с конкурентами;
• поддержка PostgreSQL, MySQL, Microsoft SQL Server, MariaDB;
• возможность подключения и управления несколькими серверами баз данных в одном окне;
• прямой экспорт SQL из одной базы данных в другую;
• массовый просмотр и редактирование таблиц;
• автодополнение кода и подсветка синтаксиса;
• сообщество с активной поддержкой и регулярные обновы;
• экспорт таблиц и данных в Excel, HTML, JSON, PHP;
• зашифрованное соединение.

Минусы:

• не кроссплатформенное приложение;
• частые проблемы со стабильностью;
• нет отладчика процедурного языка.

HeidiSql

6. TablePlus

Картинка с сайта: proglib.io

Программное обеспечение с графическим интерфейсом для управления базами данных SQL и NoSQL. С закрытым исходным кодом.

Плюсы:

• высокая производительность;
• настраиваемый UI;
• подсветка синтаксиса;
• высокий уровень безопасности данных обеспечивается за счет сквозного шифрования в соединении.

Минусы:

• часто возникают проблемы с UX при работе с другими базами данных, кроме PostgreSQL;
• недешево, а пробная версия предлагает ограниченную функциональность;
• поддержка клиентов оставляет желать лучшего.

TablePlus

7. OmniDB

Картинка с сайта: proglib.io

Простой открытый инструмент с GUI для PostgreSQL.

Плюсы:

• кроссплатформенность (поддержка Windows, Linux, macOS);
• поддержка PostgreSQL, Oracle, MySQL, MariaDB;
• очень отзывчивый и легкий по сравнению с некоторыми альтернативами;
• автозаполнение SQL;
• подсветка синтаксиса;
• возможность создания настраиваемых диаграммы для отображения релевантных метрик БД;
• встроенная отладка.

Минусы:

• не самый лучший вариант, если вы работаете с несколькими базами одновременно;
• отсутствие поддержки и документации.

OmniDB

Заключение: UI Bakery – неочевидный, но мощный вариант

Когда вы выбираете программное обеспечение с GUI, основывайте окончательное решение на нескольких
аспектах:

• размер команды;
• используемые ОС;
• тип СУБД;
• количество баз данных, с которыми вы планируете работать.

DBeaver, DataGrip и HeidiSQL больше подходят для одного человека,
работающего с одной базой. Navicat – выбор для команды благодаря возможности совместной работы. Почти все упомянутые инструменты
являются кроссплатформенными за исключением HeidiSQL, который поддерживает
только Windows.

Похоже, что pgAdmin и
другое классическое ПО теряет популярность. Низкоуровневый подход к управлению базами данных позволяет получать гораздо лучшие результаты за меньшее время.

Дополнительные материалы:

• 5 лучших материалов по PostgreSQL
• Работа с PostgreSQL: от полного нуля до полного просветления
• О языке SQL на примере SQLite, MySQL и PostgreSQL
• Как оптимизировать производительность запросов в PostgreSQL
• NoSQL базы данных: хранилища и доступность данных

1. Overview of the Postgres Client

2. Describe Working of Postgres Client

3. Postgres Clients for Windows

Картинка с сайта: www.delftstack.com

Postgres clients can be incredibly beneficial, but finding one that works for you might be difficult. Today’s article describes everything you need to know and will help you find the best Postgres clients available for Windows users.

Overview of the Postgres Client

More often than not, we require some medium to connect our codes to an interface. Here, we need something that allows a database server to connect via the OS interface.

Although this can always be done using many commands, utilities, or third-party tools, it is much easier to use a client application that does everything quickly.

As a result, a Postgres client application can allow you to connect to the database server in a user-friendly and quick way.

Describe Working of Postgres Client

Postgres Client works very straightforwardly. The architecture is divided into the client, the command execution environment, and the server.

The client uses libraries to communicate with the database server. For Postgres, libpq is often used. The client sends a request to a database server through the client utility, followed by the query or code.

Once authentication is successful, the server responds to the client’s request. This way, multiple clients can communicate with a server to process a request.

Postgres Clients for Windows

If you use the Windows device, there are multiple Postgres clients that you can use with no issues at all. However, you must ensure that it supports your version of Windows while picking a client, or it might not work well if it does at all.

Some of the more widespread options are listed below:

Postgres Clients for Windows — PgAdmin

PgAdmin might be an older Windows client, but it has majorly progressed over the years. It is one of the primary reasons it is the most popular open-source administration and development with many features.

When writing this article, the latest release is pgAdmin 4 v6.12; it is one of those platforms that is incredibly user-friendly and easy to figure out.

It allows database visualization, and one of the much-appreciated features is how a user can navigate between local and live servers and between databases. Note that the PgAdmin is free to use, and anyone can install and start using it.

Postgres Clients for Windows — Postgres Maestro

Postgresql Maestro has a range of functionalities that include the following:

• Easy database object management
• Designing databases
• Data analysis and management tools
• Postgres editor, debugger, and visual query builder
• Data import and export from and to any system
• Security management
• Schema refactoring and BLOB management tools
• Multiple options for customization

These functionalities and its simplistic user interface collectively enable PostgreSQL Maestro to be a favorite. Most users believe it is straightforward to build even complex queries, and it’s pretty fast. However, it is not free or open source.

Postgres Clients for Windows — dbVisualizer

Although dbVisualizer, or simply dbVib, is most popular amongst mac users, their Windows version performs well too. This client is created so anyone with anything to do with databases can use it easily.

So, whether you’re a developer, analyst, or even a DBA, dbVib can help you meet your database needs. One of the best things about this Postgres client is the multitude of databases that it supports.

Therefore, whether you were working with Oracle or even Azure SQL database, dbVisualizer can help you get connected.

Postgres Clients for Windows — EMS's SQL Manager

SQL Manager comes with a series of options, including a client specifically for PostgreSQL.

It comes with a high-quality management system that provides effective data management for the visualization of the database itself or even the creation of different types of reports.

It has effective security management, advanced data manipulation tools, a powerful visual database designer, and more. Each of these features collectively formulates a great Postgres client for Windows.

It is important to note that the free version limits you to about five database connections.

Postgres Clients for Windows — Navicat

Navicat is a relatively newer PostgreSQL client for Windows, but its effectiveness is not compromised.

The GUI is one of the best and is pretty similar to an explorer, which is probably one of the many reasons it is currently being used by over 50% of Fortune 500 companies.

It also uploads all of a user’s data to its cloud, so you will always be able to save and access your data as needed, regardless of whether your database is remote or local.

Although you won’t be able to get Navicat for free, they offer a trial with all of the features for 14 days which is more than enough to verify whether this Postgres Windows client is the one for you.

Postgres Clients for Windows — TeamPostgreSQL

If you’re on the hunt for a web-enabled client and most of your use will revolve around this feature, TeamPostgreSQL might be the one you need.

Moreover, it allows shared access between all company members, whether the developer, tester, manager, or support staff, but only with the security settings you picked.

Overall, it is a great AJAX web-supported client for Postgres on a Windows system. That concludes some of the most popular and best Windows Postgres clients.

We’re sure you can now easily pick the client best suited for your needs by comparing your shortlisted ones.

PostgreSQL is a powerful, open-source relational database management system that is widely used by developers around the world. If you’re working with PostgreSQL, you’ll need a good GUI to help you manage your databases efficiently.

Available for Windows, MacOS, and Linux — download here

Картинка с сайта: www.beekeeperstudio.io

Beekeeper Studio’s strong focus on usability and design is unique among open source database GUIs and makes it an excellent Postgresql GUI client. I’m obviously biased, but this is backed by over 1,250,000 downloads, and great customer reviews, like the one below, from Andrew.

Download Beekeeper Studio

Beekeeper Studio supports multiple databases including MySQL, PostgreSQL, SQLite, SQL Server, and more. What sets Beekeeper Studio apart is its clean, intuitive interface combined with powerful features like auto-complete, query formatting, native-tabs, and a privacy-first policy with no telemetry or tracking.

Best Database GUI for Students and Hobbyists

I made Beekeeper Studio free and open source because when I was a broke student I couldn’t understand how to use many of the Java-based GUIs, and I couldn’t afford to pay for a ‘good’ database GUI either. I think many folks are in this situation, so I created Beekeeper Studio – an easy to use and streamlined PostgreSQL GUI that everyone can enjoy. Download here

Best Database GUI for Professionals

Beekeeper Studio also has a commercial ‘ultimate’ edition with more features like full import/export, backup & restore, and support for enterprise databases like Oracle and Cassandra. Thousands of professional developers use Beekeeper Studio every day. I think you’ll like it too. Download the Ultimate edition here

Plus — All of Beekeeper Studio’s code is made available through the GPLv3 license, so it’s truly free (libre) and free (gratis).

Beekeeper Studio Links

• Compare Beekeeper Studio and DBeaver
• Download the free community edition
• Download the ultimate edition
• Source code on Github

PGAdmin

Available for Windows, MacOS, and Linux

Картинка с сайта: www.beekeeperstudio.io

pgAdmin is designed specifically for PostgreSQL, offering comprehensive features for database administration, query analysis, and server monitoring. However, this specialization comes at the cost of a steeper learning curve and a more cumbersome user interface, which can be overwhelming for everyday development tasks.

pgAdmin is the OG Postgres GUI, and it’s a solid choice for database administrators who need detailed insights and control over their PostgreSQL servers.

However, it only supports PostgreSQL, and if you need to manage multiple types of databases pgAdmin won’t work for you.

pgAdmin Links

• Download pgAdmin
• Official Website
• Github Repository

DBeaver

Available for Windows, MacOS, and Linux

Картинка с сайта: www.beekeeperstudio.io

Started in 2010, DBeaver is a popular database GUI due to its extensive database support and robust feature set, but it’s not for everyone. DBeaver is a great choice if you value features over usability, as it does a great job packing in a ton of features.

DBeaver is Java-based, which can make it feel a bit sluggish compared to more modern apps like Beekeeper Studio, and it looks a little out of place on any OS, but the benefit of Java is the wide range of databases it supports.

DBeaver Links

• Download DBeaver
• Official Website
• GitHub Repository

HeidiSQL

Windows Only

Картинка с сайта: www.beekeeperstudio.io

Created in 2002, HeidiSQL is a well respected and mature GUI for managing MySQL, MariaDB, Microsoft SQL, and PostgreSQL databases on Microsoft Windows. It offers a robust set of features including a graphical interface for managing databases and data visually.

HeidiSQL has a lot of great database management features, but it’s Windows only, so if you’re on MacOS or Linux you’re out of luck, although it does run on Wine, it looks terrible on HiDPI screens.

HeidiSQL is unique in that it is built in Pascal (!), which I think is pretty cool, but it does limit the number of developers who can contribute to the project, and the number of newer databases it can support.

HeidiSQL Links

• HeidiSQL Download
• Github Repository

Adminer

Web based

Картинка с сайта: www.beekeeperstudio.io

Adminer is unique among the database GUIs listed here in that it is a single PHP file that you can drop into your web server and use to manage your databases. This makes it a great choice for shared hosting environments where you can’t install software.

Adminer is pretty simple to set up, but does require you to know how to set up PHP and a web server, and it’s not as feature rich as the other GUIs listed here. Obviously being a web-based app it’s not as fast as a native app like Beekeeper Studio, but it’s a great choice if you need to manage your databases from a web browser.

Adminer Links

• Adminer Download
• Github Repository

Wrap up

Whichever app you decide to use, there are plenty of great open source SQL apps. I hope you find the one that works best for you. If you have any questions or need help, feel free to reach out to me on Twitter / X.