dbForge Studio for MySQL vs pgquarrel
dbForge Studio for MySQL
devart.compgquarrel
github.comSide by side
| Figure | dbForge Studio for MySQL | pgquarrel |
|---|---|---|
| Price from | $8.33/mo | Free |
| Free plan | Yes | Yes |
| Free trial | Yes | — |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | — |
| Linux | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 10 | 1 |
| Spec score · Database Schema Comparison Tools | 8.2 (#7) | 7.7 (#12) |
| Platforms | Windows, macOS and Linux | The README says it was tested on Linux, FreeBSD, and Windows, and provides installation instructions for UNIX based operating systems and Windows. |
Plans
dbForge Studio for MySQL
- ExpressPriced on request
- Standard$9.95 a month
- ProfessionalPriced on request
- EnterprisePriced on request
- ExpressFree
- Professional$19.95 a month
- Enterprise$24.95 a month
- Standard$99.95 a year
- Professional$179.95 a year
- Enterprise$229.95 a year
In their own words
dbForge Studio for MySQL
dbForge Studio for MySQL is a desktop database tool for MySQL, MariaDB, Percona, and HeatWave. It runs on Windows, macOS, and Linux and provides data editing, visual data and object editors, a database designer, visual query building, SSH tunneling, and query history. Query results can be exported to HTML, Text, XLS, XLSX, Google Spreadsheet, MS Access, RTF, PDF, JSON, XML, CSV, ODBC, DBF, and SQL. The Express plan lists formatting, visual editors, design, import and export, and security and session managers. Standard adds debugging, query profiling, backup and recovery, database search, and SQL refactoring for $9.95 a month, billed monthly. Professional lists schema and data comparison and synchronization, command-line automation, database projects, pivot tables, and reports. Enterprise lists source control, data generation, documentation, database copying, invalid-object finding, and script-folder comparisons. A free plan is available, while paid access starts at $9.95 per user per month. Devart was founded in 1997.
pgquarrel
pgquarrel compares PostgreSQL database schemas and produces SQL commands to bring a target schema in line with a source. It connects to PostgreSQL servers and reads catalog metadata directly, rather than depending on tools such as pg_dump. The project describes deploying schema changes to testing, staging, or production as its main use. Filters can narrow comparisons to selected object types or include and exclude schemas by pattern. Output goes to stdout by default, with options to save it to a file, print a summary, or place changes in one transaction. pgquarrel does not manipulate table data with INSERT, UPDATE, DELETE, or COPY. Its documented object coverage includes both complete and partial support; inheritance and roles are noted absences, and not all PostgreSQL objects are supported. Output may not work as expected when the source PostgreSQL version is newer than the target. The software is free under the BSD-3-Clause license, distributed as source through GitHub or a Git clone, and the listed latest release is 0.7.0.