Postico Alternatives

The software pgAdmin is the most popular free and open-source administration panel for PostgreSQL. With pgAdmin developers can manage their database and also use it as a tool that is part of the development process. The software is released under the PostgreSQL/Artistic licence and can be used on macOS, Linux, Unix and Windows to manage PostgreSQL 9.2 and above.

DataGrip is a commercial IDE for databases and SQL developed by JetBrains. With DataGrip users can write SQL code faster and safer due to context-sensitive code completion that is aware of tables structure, foreign keys and pivot tables. DataGrip PostgreSQL, MySQL, Oracle Database, SQL Server, Azure, Amazon Redshift, SQLite, MariaDB, MongoDB, Cassandra, Apache Hive and many more databases.

Beekeeper Studio is a well-designed and easy to use SQL client for MySQL, PostgreSQL, SQLite, SQL Server, and a variety of other relational database management systems. The software allows you to connect to databases normally or encrypted with SSL, or tunnel through SSH to ensure maximum security while still providing choices. With Beekeeper Studio, you can manage multiple tabs and multitask across operations, while providing auto-complete suggestions for tables and queries. Commonly used queries can be saved and orginized into workspaces, that can be used across connections and projects. Beekeeper Studio is both free and open source and released under the MIT License.

MySQL Workbench is a free and commercial open-source tool for managing MySQL databases visually through a GUI. MySQL Workbench provides features like data modeling, sql development, and comprehensive administration tools. MySQL Workbench is developed by Oracle Corporation and is a successor to DBDesigner 4. The community edition of MySQL Workbench is released under the GNU General Public License, while the enterprise edition is released as a commercial proprietary software.

HeidiSQL is a free and open-source GUI for MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite databases. With HeidiSQL, you can spectate and edit data and structure of your database in an intuitive interface. The software allows you to connect to your database via SSH tunnel or with SSL, and connect to multiple servers simultaneously, while also being able to monitor and kill client process in real-time.

With phpMyAdmin you can manage MySQL and MariaDB via a user interface. phpMyAdmin is free and open-source portable web application written primarily in PHP. It supports wide range of native MySQL and MariaDB database operations including maniging tables, columns, relations, indexes, users, permissions and more.

PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly. PSequel PostgreSQL GUI tool specifically developed for macOS. While offical tools like pgAdmin are great and provide a wide range of features, they lack the simplicity of PSequel.

Adminer provides administrators, developers and website maintainers with a full-featured database management tool written in PHP. With Adminer you can to a database servers with username and password. List fields, indexes, foreign keys and triggers of table. Change name, engine, collation, auto_increment and comment of table. Alter name, type, collation, comment and default values of columns. Create, alter and drop indexes, foreign keys, select form view and call stored procedures and functions. The software is distributed under the Apache License which makes it free and open-source. Adminer supports a wide variety of relational and NoSQL databases including MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.

Valentina Studio is a data management tool for database administrators. With Valentina Studio you can manage MySQL, MariaDB, SQL Server, PostgreSQL, SQLite and Valentina DB on macOS, Linux and Windows. For enterprise features a Valentina Studio PRO license is required.

With Navicat you can explore and manage MySQL, MariaDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server databases through a GUI. Navicat is a commercial-grade, graphical database management that meets the demands of database administrators, developers and company executives.

TablePlus is a modern, native database client with intuitive GUI tools to create, access, query and edit multiple relational databases. The client supports MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Sqlite, Redis, Cassandra, MongoDB and CockroachDB. TablePlus is available for macOS and Windows, and beta versions available for iOS and Linux.

DbVisualizer is a database tool for developers, analysts and database administrators. DbVisualizer is avalible on all major operating systems and connects to all major databases.