DbGate vs SQLPad
DbGate
dbgate.ioSQLPad
sqlpad.github.ioSide by side
| Figure | DbGate | SQLPad |
|---|---|---|
| Price from | $3.90/mo | — |
| Free plan | Yes | — |
| Free trial | Yes | — |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | Yes |
| API | — | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 8 | 0 |
| Spec score · Database Client Software | 8.5 (#9) | 7.2 (#38) |
| Database support | The site lists MySQL, PostgreSQL, Oracle, SQL Server, SQLite, MongoDB and Redis among supported databases. | It supports PostgreSQL, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, SAP HANA, Cassandra, BigQuery, SQLite, TiDB, and other databases through ODBC. |
| Deployment | The maker lists desktop editions for Windows, macOS and Linux, plus web deployment through Docker, Amazon and Azure. | SQLPad can be built from source or run as a Docker image; the Docker image listens on port 3000 by default. |
Plans
DbGate
- Academic editionFree
- CommunityFree
- DbGate Shopify App$3.90 a month
- Premium$12 a month
- DbGate Central$15 a month
- Team Premium$15 a month
- Premium$120 a year
- Team Premium$150 a year
In their own words
DbGate
DbGate is a manager and client for SQL and NoSQL databases, offered as desktop software and through web deployment. Its listed database support includes MySQL, PostgreSQL, Oracle, SQL Server, SQLite, MongoDB and Redis. The data browser supports filtering, related-table navigation, master-detail views, foreign-key lookups, batch updates and macros. The query editor includes parameterized queries, history and autocomplete suggestions. Import and export formats include SQL, CSV, JSON, XML, NDJSON, Excel, DBF and YAML. Visualization tools include a query designer, ER diagrams, charts, geographic map display and HTML export. Database Chat can interpret database schema and data, and execute SQL when the user explicitly permits it. DbGate Central connects to GraphQL, Shopify and oData endpoints. Desktop editions are listed for Windows, macOS and Linux, while web deployment options include Docker, Amazon and Azure. Community costs nothing for one user, with DbGate Cloud capped at five connections and five SQL files. Premium is $12 a month; Team Premium is $15 a month.