Alternatives to pgAdmin
Compare pgAdmin alternatives for your business or organization using the curated list below. SourceForge ranks the best alternatives to pgAdmin in 2024. Compare features, ratings, user reviews, pricing, and more from pgAdmin competitors and alternatives in order to make an informed decision for your business.
-
1
DbVisualizer
DbVisualizer
DbVisualizer is one of the world’s most popular database editors. Developers, analysts, and DBAs use it to elevate their SQL experience with modern tools to visualize and manage their databases, schemas, objects, and table data, and to auto-generate, write and optimize queries. And so much more. It connects to all popular databases (e.g. MySQL, PostgreSQL, SQL Server, Oracle, Cassandra, Snowflake, SQLite, BigQuery, and 20+ more) and runs on all popular OSes (Windows, macOS, and Linux). With almost 6 million downloads and Pro-users in 145 countries around the world, it won’t let you down. Free and Pro versions are available. -
2
ScaleGrid
ScaleGrid
ScaleGrid is a fully managed Database-as-a-Service (DBaaS) platform that helps you automate your time-consuming database administration tasks both in the cloud and on-premises. Easily provision, monitor, backup and scale your open source databases with high availability, advanced security, full superuser and SSH access, query analysis, and troubleshooting support to improve the performance of your deployments. Supported databases include: - MySQL - PostgreSQL - Redis™ - MongoDB® database - Greenplum™ (coming soon) The ScaleGrid platform supports both public and private clouds, including AWS, Azure, Google Cloud Platform (GCP), DigitalOcean, Linode, Oracle Cloud Infrastructure (OCI), VMware and OpenStack. Used by thousands of developers, startups, and enterprise customers including Atlassian, Meteor, and Accenture, ScaleGrid handles all your database operations at any scale so you can focus on your application performance.Starting Price: $8 per month -
3
SolarWinds Database Performance Monitor
SolarWinds
Easily assess how much effort you need to put into scaling your database infrastructure. SolarWinds® Database Performance Monitor (DPM) is a SaaS-based platform that helps increase system performance, team efficiency, and infrastructure cost savings by offering full visibility into major open-source databases including MySQL, PostgreSQL, MongoDB, Amazon Aurora, and Redis. Deploy code and compare query and system performance with before and after charts, and quickly search for newly introduced queries. Visualize and correlate query behavior to system metrics to help troubleshoot performance issues and impact. -
4
TablePlus
TablePlus InC
Modern, native client with intuitive GUI tools to create, access, query & edit multiple databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Cassandra, Snowflake, Oracle, Redis.Starting Price: $59.00 -
5
DBeaver
DBeaver
Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc. Copy As: format configuration editor was added. Extra configuration for filter dialog (performance). Sort by column as fixed (for small fetch sizes). Case-insensitive filters support was added. Plaintext view now support top/bottom dividers. Data editor was fixed (when column name conflicts with alias name). Duplicate row(s) command was fixed for multiple selected rows. Edit sub-menu was returned to the context menu. Columns auto-size configuration was added. Dictionary viewer was fixed (for read-only connections). Current/selected row highlighting support was added (configurable). -
6
Adminer
Adminer
Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security. Security is #1 priority in development of Adminer. Adminer does not allow connecting to databases without a password and it rate-limits the connection attempts to protect against brute-force attacks. Still, consider making Adminer inaccessible to public by whitelisting IP addresses allowed to connect to it, password-protecting the access in your web server, enabling security plugins (e.g. to require an OTP) or by customizing the login method. You can also delete Adminer if not needed anymore, it is just one file which is easy to upload in the future. Adminer had some security bugs in the past so update whenever Adminer tells you there is a new version available (ask your administrator if you could not update yourself). Connect to a database server with username and password. /Select an existing database or create a new one. -
7
dbForge Studio for PostgreSQL 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 your requirements in a convenient and user-friendly interface. The tool provides a data editing tool to customize your queries and property window so that users can view all the required information of PostgreSQL database objects they are interested in. Key features: *SQL Development. Save your time and improve code quality when creating and editing queries. *Explorer. Navigate through the object tree and find any PostgreSQL object you want. *Data Editor. Users can manage the settings of tables. *Data Export and Data Import. Supports 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios. *Query Profiler. *Data and Schema Compare. *Data Generator. *Pivot Table.Starting Price: $89.95
-
8
Valentina Studio
Paradigma Software
Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE. Design business reports running in Valentina Studio Pro, on Valentina Server or in an application with an Application Developer Kit. Backward Engineering in Standard with forwarding Engineering in Valentina Studio Pro. Reverse engineering and create diagrams for existing databases. Add new objects to diagrams. Write SQL queries with auto-completion, color syntax. Define, manage, save favorite queries; access recent queries. Function browser dictionary of each function. Consoles for errors, warnings, and performance. Search, Export result records into CSV, JSON, Excel. Edit properties of multiple objects at the same time. Drill down to tables and fields; incredible fast searching. Reverse engineering and create diagrams for existing databases. Add new objects to diagrams. Add/drop users, and groups, and manage privileges. -
9
Azure Data Studio
Microsoft
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It's engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards. Use Azure Data Studio to query, design, and manage your databases and data warehouses wherever they are, on your local computer or in the cloud. We recommend the user installer, which simplifies installations and updates and doesn't require Administrator privileges. -
10
Beekeeper Studio
Beekeeper Studio
Encrypt your connection with SSL, or tunnel through SSH. Save a connection password and Beekeeper Studio will encrypt it. Our built-in editor provides syntax highlighting and auto-complete suggestions for your tables so you can work quickly and easily. Open dozens of tabs so you can work quickly without having to switch windows. Table DDL and data views get their own tabs too! Easily save and organize commonly used queries so you can use them again and again across all your connections. Beekeeper's SQL table creator lets you create, edit, and delete table columns in just a few clicks. Export a table to CSV, JSON, JSONL, or SQL with just a few clicks. Optionally apply filters to export only the data you need.Starting Price: $7 per month -
11
HeidiSQL
HeidiSQL
HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide. Free for everyone, OpenSource. Connect to multiple servers in one window. Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite. Connect to servers via commandline. Connect via SSH tunnel, or pass SSL settings. Create and edit tables, views, stored routines, triggers and scheduled events. Generate nice SQL-exports, compress these afterwards, or put them on the clipboard. Export from one server/database directly to another server/database. Manage user-privileges, import text-files, export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array. Browse and edit table-data using a comfortable grid.Starting Price: 0 -
12
Navicat Premium
Navicat
Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud and MongoDB Atlas. You can quickly and easily build, manage and maintain your databases. Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across various DBMS. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.Starting Price: $64.99 per month -
13
Postbird
Paxa
Postbird is a cross-platform PostgreSQL GUI client, written in JavaScript, and runs with Electron. Supports views, material views, foreign tables, constraints, and schemas, and connects to Heroku's Postgres. Can manage extensions, procedures, users, filter tables, edit values, and import & export tables or databases. Have comfortable query editing with saving the last query, syntax highlighting, keyboard shortcuts, search, snippets, query history, viewing large results, explaining formatting, and saving results as CSV.Starting Price: Free -
14
Postico
Postico
Postico is a database client. Postico can connect to a local PostgreSQL server running on your Mac, or to remote servers running on a different computer. If you want to install a local PostgreSQL server on your Mac, I recommend Postgres.app. Postgres.app starts a PostgreSQL server running locally on your Mac. The first time it starts it will automatically create a new data directory and set up an empty database. After a few moments, the server will be running and waiting for connections. Postgres.app can't start when another PostgreSQL server is already running on your computer. If you run into problems, make sure to deactivate or uninstall other PostgreSQL installations. Reboot your computer after uninstalling! To connect to a PostgreSQL server with Postico, you must first create a favorite. A favorite contains parameters for connecting to a server. Some connection parameters are optional. -
15
PSequel
PSequel
PostgreSQL GUI tool for macOS. PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly. pgAdmin is great for its feature-richness. However, its UI is clumsy and complicated. There is a list of PostgreSQL GUI Tools. However, they are either web-based, Java-based or don't support the features some want. In the good old MySQL world, the best client is Sequel Pro, but its support for PostgreSQL doesn't seem to be happening. So, we decided to make one. PSequel is written from scratch in Swift 2, although PSequel's UI is highly inspired by Sequel Pro. PSequel is being developed in our spare time. By supporting macOS 10.10+ only, the codebase can be kept simpler and save time by not testing it in older versions of macOS. And, less code, less bugs. PSequel is still in its early stage. -
16
DBHawk
Datasparc
Using DBHawk, our customers were able to comply with GDPR, HIPAA, SOX, GLBA, and other regulations and were able to implement SOD. Self-Service BI & Ad-Hoc Reporting Tool with feature to define Data Access Policy, Connect to multiple Data sources, Build Powerful SQL Charts and data Dashboards. DBHawk SQL editor is an advanced editor that allows users to build, edit, and run database queries with a web-based interface. DBHawk Query Builder is supported with all major databases such as Oracle, Microsoft SQL Server, PostgreSQL, Greenplum, MySQL, DB2, Amazon Redshift, Hive, Amazon Athena. Database SQL tasks and batch job automation with a web-based centralized tool. Secure access to SQL, NoSQL and Cloud databases with our all-in-one data platform. Trusted by our customers to protect and access their data. Centralized Security, Auditing and insights about your user’s activities.Starting Price: $99.00/month/user -
17
dbForge Studio (Edge)
Devart
dbForge Edge is the newest Devart product - the multidatabase software solution covers all database-related jobs, allowing its users to accelerate the tasks' completion, save costs, and improve overall productivity. A set of powerful features applies to all most popular database management systems - MySQL and MariaDB, SQL Server, Oracle, and PostgreSQL. Notice the most helpful features of dbForge Edge: Database design & development. Convert ER diagrams to actual databases or reverse-engineer databases. SQL coding assistance. Visual query building. Query profiling. Database comparison & synchronization. Deploy changes to the target databases on different platforms. Data management. Data import/export. Data analysis and reporting. Database administration.Starting Price: $99.95 -
18
JackDB
JackDB
Write and execute queries in a fully interactive SQL editor. JackDB has everything you'd want in a database client, including: syntax highlighting, code formatting, and intelligent autocompletion. Snippets allow your most useful SQL queries to be saved and shared. Simply write and save any query in JackDB, and share the snippet publicly with your team. Whenever anyone updates a snippet, everyone gets access to its latest version. Security is our highest priority at JackDB. Roles are a very convenient and secure way to restrict database access to authorized users and provision new users with access to data sources. Explore everything in your database, not just tables and views. View your indexes, schemas, and other important system details such as tablespaces and user sessions.Starting Price: $49 per user per month -
19
SQLGate
CHEQUER
SQLGate is a simple but powerful IDE for multiple SQL databases. As an integrated database management and development solution, it simplifies the construction and operation of databases. It is customized for seven different databases that make up 83.2% of the DBMS market. These include Oracle, SQL Server, MySQL, MariaDB, Tibero, and PostgreSQL. SQLGate makes it easier and quicker to deal with databases holding large amounts of data. Multiple Languages available: Korean, English, Spanish, French, Japanese, etc..Starting Price: Free -
20
DbSchema
Wise Coders Solutions
DbSchema is for visual designing the schema in a team, deploy and document the schema. Other integrated features like data explorer, visual query editor, data generator, etc., makes DbSchema an every-day tool for everybody who interacts with databases. DbSchema supports all relational and No-SQL databases, including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, Google and more. DbSchema is reverse-engineering the database schema from the database and visualize it as diagrams. You will interact with the database using diagrams and visual tools. DbSchema model is using its copy of schema structure, independent from the database. This allows the schema deployment on multiple databases, save the design model to file, store it in GIT and design the schema in a team, design the schema without database connectivity, compare different versions of the schema and generate SQL migration scripts.Starting Price: $63 one time payment -
21
Aqua Data Studio
AquaFold, an Idera, Inc. company
Aqua Data Studio is a multiple-platform, integrated development environment (IDE) for data. It provides benefits to a variety of data-centric roles, allowing them to manage a wide range of data sources. Aqua Data Studio provides scalable, cross-platform data management, supporting IT and data-centric specialists, including developers, database administrators, as well as data analysts, data modelers, and data architects. Simplifies tedious tasks involving SQL queries, data, result sets, schema, data models, files, instances, servers, as well as automation. Aqua Data Studio can be installed on the three popular operating systems: Microsoft Windows, Apple macOS, and Linux. The graphical user interface can display the nine of the most widely spoken languages: English, Spanish, French, German, Korean, Portuguese, Japanese, and Chinese. Aqua Data Studio supports over 40 of the most popular data source platforms, including relational, NoSQL, as well as managed cloud data sourceStarting Price: $499 per user per year -
22
RazorSQL
RazorSQL
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC. Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures, functions, and more. Visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more. Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more. Import data from various formats such as delimited files, Excel spreadsheets, and fixed-width files. Includes a robust relational database (HSQLDB) that is up and running with no manual configuration out of the box.Starting Price: $99.95 one-time payment -
23
Toad Edge
Quest
If yours is one of the majority of organizations migrating your existing commercial database to open sources, such as MySQL or PostgreSQL, or if you’re building new in-house applications on open-source database management systems (OSDBMS), then you know that commercial tooling for these databases falls short. What if you could save money by implementing OSDBMS and ramp up quickly by working with a familiar toolset? You can with Toad Edge®. It’s a lightweight, reliable desktop toolset that simplifies development and management tasks for open-source databases. Using Toad for MySQL and PostgreSQL management makes it easier to master new database platforms quickly. If you’re taking on MariaDB, Amazon Redshift, or EDB Postgres Advanced Server, Toad Edge will simplify your work on those platforms as well. Toad Edge supports coding, editing, schema compare and sync, and DevOps CI processes, so you can manage your open-source databases easily and confidently. -
24
EMS SQL Management Studio
EMS Software
EMS SQL Management Studio for PostgreSQL is a complete solution for PostgreSQL database administration and development. The single workbench provides you with must-have tools for managing PostgreSQL databases and objects, as well as for database design, migration, extraction, query building, data import and export, database comparison, and running service tasks. Get access to all databases and their objects from a single console and manage them with a user-friendly interface. You can create and modify all server and database objects, set necessary properties, and view detailed info in advanced visual editors. Transfer structure changes from development to production database automatically with Compare databases tool. Create ER diagrams for newly developed databases to quickly deploy them. Create database maintenance tasks with advanced options and let SQL Studio run them on a regular basis.Starting Price: $260 one-time payment -
25
Sqlectron
Sqlectron
A simple and lightweight SQL client desktop/terminal with cross-database and platform support. A desktop application with a simple interface. Sign and notarize builds for macOS. Supports PostgreSQL and MySQL. Sqlectronhas also has a GUI interface called sqlectron-gui. Most of the time you should not worry about files, because Sqlectron will manage the configuration for you. The paging is not done in SQL query, instead, it is done during the results rendering. Supports PostgreSQL, Redshift, MySQL, MariaDB, Microsoft SQL Server, Cassandra, and SQLite.Although it is possible to change files manually, it is usually better to just use the UI since it allows you to change any of the settings from there.Starting Price: Free -
26
PostgreSQL Maestro
SQL Maestro
Complete and powerful database management, admin, and development tool for PostgreSQL. Browse, create, edit, duplicate, rename, and drop all schema objects like tables, views, functions, or triggers in the simplest way possible. Simplify your data modeling tasks. Create tables and relations in a few mouse clicks. Print diagrams or export them to a number of graphical file formats. Browse, edit, print, sort, group, and filter your data using a wide spectrum of available tools including master-detail views. Build graphical diagrams and OLAP cubes. Enjoy a feature-rich SQL Editor with code completion, code folding, and SQL formatted, or build your queries visually. Export your data to as many as 20 most popular file formats or import data from Excel, CSV, XML and other files. Make your server safe and secure with powerful tools provided by PostgreSQL Maestro. Split denormalized tables, generate DML procedures or updatable views, and check nullable columns with a few mouse clicks.Starting Price: $99 one-time payment -
27
DataGrip
JetBrains
Meet DataGrip, our new database IDE that is tailored to suit the specific needs of professional SQL developers. Allows you to execute queries in different modes and provides a local history that keeps track of all your activity and protects you from losing your work. Lets you jump to any table, view, or procedure by its name via the corresponding action, or directly from its usages in the SQL code. Gives you an extended insight into how your queries work and into the database engine behavior, so you can make your queries more efficient. DataGrip provides context-sensitive code completion, helping you to write SQL code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in code you're editing. DataGrip detects probable bugs in your code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, using keywords as identifiers and always offers a way to fix the problems.Starting Price: $199 per year -
28
KS DB Merge Tools
KS DB Merge Tools
KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of particular object type (table definitions, views, etc.), and then down to definition of particular object. Data changes can be retrieved as a high-level list of changes totals across all tables in the database, each total row count can be observed as a side-by-side list of rows for the given table, each changed row can be analyzed for changes in each column. Various diff results provide quick filters to show only new/changed/new+changed items (schema objects or table data rows), ability to select required changed items and generate scripts to apply these changes to the other side database. This script can be executed immediately or saved for future use.Starting Price: $50/user, volume discounts -
29
Visual Expert
Novalys
Visual Expert is a static code analyzer for Oracle PL/SQL, SQL Server T-SQL, and PowerBuilder. Identify code dependencies to modify your code without breaking your application. Scan your code to improve the security, performance, and quality. Perform Impact analysis to Identify breaking changes. Automatically scan your code to detect and fix security vulnerabilities, bugs and maintenance Issues. Implement continuous code inspection Understand the inner workings of your code with call graphs, code diagrams, CRUD Matrix and Object Dependency Matrix (ODM). Automatically generate an HTML Source Code documentation. Explore your code exploration with hyperlinks Compare applications, databases or pieces of code. Improve maintainability. Clean up code. Comply with dev standards. Analyze and Improve DB code performance: Find slow objects and SQL queries, Optimize a slow object, a Chain of calls a slow SQL, Get a query Execution Plan. And much more.Starting Price: $495 per year -
30
AnySQL Maestro
SQL Maestro Group
AnySQL Maestro is the premier multi-purpose admin tool for database management, control and development. SQL Maestro Group offers complete database management and web development solutions for all the most popular database servers providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Support of any database engine (SQL Server, MySQL, Access, etc.) Database designer, data management, editing, grouping, sorting and filtering abilities. Handy SQL Editor with code folding and multi-threading. Visual query builder, data export/import to/from the most popular formats. Powerful BLOB viewer/editor. The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more. High-quality DB2 tools which are as easy in use as Windows explorer.Starting Price: $79 one-time payment -
31
Text2SQL.AI
Text2SQL.AI
Generate SQL with AI in seconds. Turn your thoughts into complex SQL queries using natural language. Text2SQL.AI uses theOpenAI GPT-3 Codexmodel which can translate English prompts to SQL queries, and SQL queries to English text. It is currently the most advanced Natural Language Processing tool available, and this is the exact same model which used by Github Copilot. The app currently supports: SQL generation from English textual instructions. Supports SELECT, UPDATE, DELETE queries, CREATE and ALTER TABLE requests, constraints, window functions, and literally everything! SQL query explanation to plain English Your custom database schema (tables, fields, types) connection (with history) SQL dialects for MySQL, PostgreSQL, Snowflake, BigQuery, MS SQL Server... If you have any other feature request, please let us know. -
32
SQL Workbench
SQL Workbench
SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. Graphical query building or more advanced DBA tasks are not the focus and are not planned. Powerful export command to write text files (aka "CSV"), XML, HTML or SQL (including BLOB data). All user tables can be exported into a directory with a single command. Export files can be compressed "on-the-fly". Powerful text, XML and spreadsheet import. A set of files (including compressed files) can be imported from a directory with a single command. Foreign key constraints are detected to insert the data in the correct order. Compare two database schemas for differences. The XML output can be transformed into the approriate SQL ALTER statements using XSLT. -
33
WinSQL
Synametrics Technologies
WinSQL is a powerful universal database management tool that is used by 90 percent of Fortune 500 companies and more than a million programmers and DBAs around the globe. WinSQL is a generic querying tool that connects to any relational database (RDBMS) for which an Open Database Connectivity (ODBC) driver is available, virtually all RDBMS on the market today. Connect to a variety of databases, including: heavy duty vendors Oracle, MS SQL Server, DB2, Sybase, Informix to lightweight backends like MS Access, DBase, and Text File. Generate royalty-free executables that can be used by your business users to run queries. These can be either static or dynamic queries that pull fresh data from the back-end. Export or simply open any query results into MS Excel with just a click of your mouse. You can even import an existing Excel spreadsheet to a database table by simply dragging an *.XSL file in the catalog tree.Starting Price: $99.00/year/user -
34
Toad
Quest
Toad Software is a database management toolset from Quest that database developers, database administrators and data analysts use to manage both relational and non-relational databases using SQL. Take a proactive approach to database management. Re-focus your teams on more strategic initiatives, and move your business forward in today’s data-driven economy. Toad solutions enable you to maximize your investment in data technology by empowering data professionals to automate processes, minimize risks and cut project delivery timelines by nearly half. Lower the total cost of ownership for new applications by reducing the impact of inefficient code on productivity, future development cycles, performance and availability. See why millions of users trust Toad for their most critical systems and data environments. It’s time to gain the competitive edge. Work smarter and meet the demands of today’s database environments. -
35
Datazenit
Datazenit
Modern database administration tool. Cross-platform MySQL and PostgreSQL GUI with data grid, schema builder, and interactive charts. Datazenit is a web-based database administration tool. It features a smart data grid, query builder, schema editor, live charts, and raw query editor with auto-complete. The goal is to build a modern and intelligent database tool that would increase productivity. The schema editor has been designed with developer productivity in mind. It is equipped with intelligent features similar to the ones you could find in an IDE. Users can choose to query data via a graphical user interface instead of a classic raw query editor. Query builder supports multiple conditions, sorting and more. Various chart styles can be used to create effective visualizations, like scatter, line, area, bar, and pie chart. Best of all, they can be shared or embedded. Enjoy an advanced data grid with different editors like text area, dropdown, checkbox, and a calendar.Starting Price: $49 one-time payment -
36
Kangaroo
Kangaroo
SQL client and admin tool for popular databases. A simple and Intuitive GUI helps you focus on data and finish your work quickly. Focus on the experience of editing, and make you feel smooth when working with it. GTK and Adwaita with Vala-based native application, focus on performance, focus on responsible. MySQL/PostgreSQL connection is more complicated because it supports multi-authentication methods, so you should prepare material before making a connection. Your connection could be through the private network over SSH(and over proxy), the built-in SSH client could help you do it. Drag and drop an SQLite database file from the file manager into the connection home page, the connection is created quickly. Create an empty file with SQLite file extension, then drag and drop it on the connection home page to create a connection. GTK4 has HiDPI support on all platforms, all GTK4 apps will scale with the system scale setting automatically.Starting Price: Free -
37
Navicat for PostgreSQL
Navicat
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development. From writing simple SQL queries to developing complex databases, Navicat for PostgreSQL is designed to accommodate a wide range of users, from PostgreSQL beginners to seasoned developers. Connect to local/remote PostgreSQL servers and compatible with cloud databases like Amazon Redshift, Amazon Aurora, Amazon RDS, Google Cloud and Microsoft Azure, and all PostgreSQL database objects. Navicat provides users with our Navicat Cloud service. Sync your connection settings and queries to the cloud so you can get real-time queries and connections anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Navicat allows you to establish secure SSH sessions through SSH Tunneling, ensuring strong authentication and secure encryption between two hosts. The authentication method can use a password or a public/private key pair.Starting Price: $17.99 per month -
38
Fujitsu Enterprise Postgres
Fujitsu
Fujitsu Enterprise Postgres is an exceptionally reliable and robust relational database, created for organizations that require strong query performance and high availability. It is based on the world-renowned open-source system — PostgreSQL, with additional enterprise-grade features for enhanced security and better performance. Fujitsu Enterprise Postgres is installed and operated by Fujitsu’s database experts who can also assist with the migration of data from your existing database. Based on PostgreSQL, FEP is highly compatible with other systems and applications. The simple, clean graphic user interface improves the experience for DBAs executing core database functions, such as running queries, scanning, and back-up, making your data and reporting more accessible. -
39
Retool
Retool
Retool is an application development platform that enables developers to combine the benefits of traditional software development with a drag-and-drop UI editor and AI to build internal tools radically faster. Building in Retool fits with how you develop software today—deploy it anywhere, connect to any internal service, import your libraries, debug with your toolchain, and share it securely to users—ensuring good and well-governed software by default. Retool is used by industry leaders such as Amazon, American Express, DoorDash, OpenAI, and Mercedes Benz for mission critical custom software across operations, billing, and customer support.Starting Price: $10 per user per month -
40
SQLPro
SQLPro
Native and ready for Big Sur. Using the latest features of macOS, but still supporting Catalina and Mojave. Coming from Microsoft SQL Management Studio? Our interface and workflow is similar to what you are used to with a few of our own improvements. Working with Amazon or Azure relational database service? No problem, SQLPro for MySQL supports MySQL 5.0 and above, including cloud instances. Need to see the results for multiple tables at once? You can execute multiple queries and have the results for each displayed at the same time, including any errors and messages.Starting Price: $6.37 per month -
41
Gogs
Gogs
The Gogs project aims to build a simple, stable, and extensible self-hosted Git service that can be set up in the most painless way. With Go, this can be done with an independent binary distribution across all platforms that Go supports. Simply run the binary for your platform. Or ship Gogs with Docker or Vagrant, or get it packaged. Gogs runs anywhere Go can compile for Windows, Mac, Linux, ARM, etc. Gogs has low minimal requirements and can run on an inexpensive Raspberry Pi. Some users even run Gogs instances on their NAS devices. Gogs is 100% open source and free of charge. All source code is available under the MIT License on GitHub. User dashboard, user profile, and activity timeline. Access repositories via SSH, HTTP, and HTTPS protocols. User, organization, and repository management. Repository and organization webhooks, including Slack, Discord, and Dingtalk. Repository Git hooks, deploy keys, and Git LFS. Repository issues, pull requests, wiki, and protected branches.Starting Price: Free -
42
Percona Distribution for PostgreSQL is a single source which provides an enterprise-grade, open source installation of PostgreSQL Core Distribution, plus critical additional enterprise components. PostgreSQL Core Distribution is an ACID-compliant relational database management system, supporting a wide range of data types and user-defined objects. A stable and secure open source product, PostgreSQL Core Distribution is relied upon by multiple organizations. You no longer need to find solutions for common requirements, like high availability and backup, on your own. When you install Percona Distribution for PostgreSQL, you get everything you need to be up and running with PostgreSQL, including PostgreSQL Core Distribution, pg_repack, pgaudit, pgBackRest, and Patroni. Percona Distribution for PostgreSQL delivers all of this in a single installation. The components are tested to work together and, along with the PostgreSQL Core Distribution, they are updated as required.Starting Price: Free
-
43
Plastic SCM
Codice Software
Unity Plastic SCM is a version control and source code management tool built to improve team collaboration and scalability with any engine. It offers optimized workflows for artists and programmers, as well as superior speed in working with large files and binaries. Plastic SCM offers tons and tons of features that make a developer's life much easier. Good branching and merging is key for "task-driven development" , feature branches, and good release management. Using Plastic, you'll branch fast even with huge code bases. You'll be able to diff refactored code with the new built-in semantic diff plus the "analyze refactors" feature. It can find refactored code across files for C#/Vb.net, Java, and C. The built-in 3-way merge tool Xdiff/Xmerge lets you resolve even the most complex merge conflicts since it features language-agnostic refactoring support. Plastic includes our SemanticMerge product.Starting Price: $6.95 per month -
44
phpMyAdmin
phpMyAdmin
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement. phpMyAdmin comes with a wide range of documentation and users are welcome to update our wiki pages to share ideas and howtos for various operations. The phpMyAdmin team will try to help you if you face any problem; you can use a variety of support channels to get help. To ease usage to a wide range of people, phpMyAdmin is being translated into 72 languages and supports both LTR and RTL languages. Browse and drop databases, tables, views, fields and indexes. Create, copy, drop, rename and alter databases, tables, fields and indexes. -
45
SQL Server Data Tools (SSDT)
Microsoft
SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. You can work with a database project, or directly with a connected database instance on or off-premise. Developers can use familiar Visual Studio tools for database development. Tools such as: code navigation, IntelliSense, language support that parallels what is available for C# and Visual Basic, platform-specific validation, debugging, and declarative editing in the Transact-SQL editor. SSDT also provides a visual Table Designer for creating and editing tables in either database projects or connected database instances. While you are working on your database projects in a team-based environment, you can use version control for all the files. -
46
SQLyog
Webyog
A Powerful MySQL Development and Administration Solution. SQLyog Ultimate enables database developers, administrators, and architects to visually compare, optimize, and document schemas. SQLyog Ultimate includes a power tool to automate and schedule the synchronization of data between two MySQL hosts. Create the job definition file using the interactive wizard. The tool does not require any installation on the MySQL hosts. You can use any host to run the tool. SQLyog Ultimate includes a power tool to interactively synchronize data. Run the tool in attended mode to compare data from source and target before taking action. Using the intuitive display, compare data on source and target for every row to decide whether it should be synchronized in which direction. SQLyog Ultimate includes a power tool to interactively compare and synchronize schema. View the differences between tables, indexes, columns, and routines of two databases. -
47
Database Tour Pro
Vitaliy Levchenko Software
Here are some areas where Database Tour has competitive advantages among database tools in the marketplace. Preparing database queries in SQL editors with syntax highlighting, code completion, and Ctrl+clickable objects. Multiple windows with separate transactions. There is a possibility to execute multi-statement SQL scripts. Collecting SQL execution statistics for each query window. Performing useful operations with databases, such as searching and replacing text, batch data processing etc. Database Tour data grids give you the ability to view CLOB/MEMO (large text) and graphic data, expand rows, use autoscrolling, sorting, selecting group of records, copying data etc. Data in tables can be highlighted depending on its content (so called conditional formatting). There is a tool for working with BLOB fields, such as large text and graphics. -
48
Altova DatabaseSpy
Altova
The DatabaseSpy SQL editor features customizable SQL auto-completion to accelerate SQL query development. Execute queries and see immediate results in one or more windows that may be tabbed or stacked. DatabaseSpy supports asynchronous query execution, allowing multiple SQL queries to be processed in different windows at the same time, either queries to different servers or even multiple queries against the same server. DatabaseSpy includes support for SQL queries that contain parameters, also known as SQL Templates. Parameters can make a query much more flexible, for instance allowing users to easily test complex join statements with multiple values. The DatabaseSpy SQL Editor and result windows at the top left below show a query to report all orders of a specific product by a specific customer.Starting Price: €109 one-time payment -
49
Arctype
Arctype
Write queries fast, generate, format, and autocomplete SQL. Visualize anything, and build beautiful charts in 2 clicks. Combine multiple charts in a dashboard. Share and control access. Bring your team in on the action with links to charts and queries. With your queries and dashboards at your fingertips, use cmd + k to find anything in your workspace. Edit tables like a spreadsheet, and select any cell to edit. Delete rows and view JSON. If you are working with a PostgreSQL database as part of your project, you’ll probably need to add or edit data. We recommend using an SQL client to do so. In this guide, we’ll walk you through how to connect to your Postgres database using an SQL client. Create the smallest EC2 instance available. Take note of the Virtual Private Cloud (VPC) network it is created in. Arctype is a fast, beautiful database GUI for developers and teams. With SQL autocomplete, spreadsheet-style editing, one-click visualizations, and collaboration.Starting Price: Free -
50
SQL Server Management Studio (SSMS)
Microsoft
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud.