Feature matrix
- PostgreSQL
- MySQL
- MariaDB
- MongoDB
- Redis / Valkey
- Elasticsearch
- CLI
The tables below show which features each engine has. ✓ means the feature is available for that engine. — means it is not. Redis includes Valkey.
Connections
Section titled “Connections”| Feature | PostgreSQL | MySQL | MariaDB | MongoDB | Redis | Elasticsearch |
|---|---|---|---|---|---|---|
| Saved profiles, TLS modes, keychain passwords | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| SSH tunnels and SOCKS5 or HTTP proxies | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Every node of a topology reached through SSH | — | — | — | ✓ | ✓ | — |
| Stepwise Test Connection | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
For MongoDB this covers replica sets, for Redis Sentinel and Cluster. Elasticsearch reaches one node through an SSH tunnel or proxy.
Querying and browsing
Section titled “Querying and browsing”| Feature | PostgreSQL | MySQL | MariaDB | MongoDB | Redis | Elasticsearch |
|---|---|---|---|---|---|---|
| SQL | ✓ | ✓ | ✓ | ✓ | — | ✓ |
| Query editor with statement splitter and history | ✓ | ✓ | ✓ | — | — | — |
| mongosh scripts (IntelliShell) | — | — | — | ✓ | — | — |
| Visual explain | ✓ | ✓ | ✓ | ✓ | — | — |
| Visual query builder | ✓ | ✓ | ✓ | ✓ | — | ✓ |
| Autocomplete | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Objects tab with sizes and counts | ✓ | ✓ | ✓ | ✓ | — | — |
| Go to Table or Collection | ✓ | ✓ | ✓ | ✓ | — | — |
| ER diagrams, model editing and saved models | ✓ | ✓ | ✓ | — | — | — |
| Edit rows, documents or values | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Table designer | ✓ | ✓ | ✓ | — | — | — |
| Empty, truncate and duplicate tables | ✓ | ✓ | ✓ | — | — | — |
| Search indexes (RediSearch, valkey-search) | — | — | — | — | ✓ | — |
On MongoDB, SQL means the SQL tab, which translates a SELECT to find() or aggregate(). On
Elasticsearch it means SQL with Translate to DSL, next to ES|QL. The Elasticsearch query builder
works from the index mapping. Autocomplete on MongoDB is in IntelliShell, on Redis in its CLI, and
on Elasticsearch in the console.
Go to Table or Collection searches the tables, views and collections of your open connections.
Moving data
Section titled “Moving data”| Feature | PostgreSQL | MySQL | MariaDB | MongoDB | Redis | Elasticsearch |
|---|---|---|---|---|---|---|
| Structure sync | ✓ | ✓ | ✓ | ✓ | — | — |
| Data compare | ✓ | ✓ | ✓ | ✓ | — | — |
| Data transfer | ✓ | ✓ | ✓ | ✓ | ✓ | — |
| Import and export of files | ✓ | ✓ | ✓ | ✓ | — | — |
| Parquet import and export | ✓ | ✓ | ✓ | — | — | — |
| Run SQL File | ✓ | ✓ | ✓ | — | — | — |
Backup and restore (.qbak) |
✓ | ✓ | ✓ | ✓ | ✓ | — |
Backup with pg_dump or mysqldump |
✓ | ✓ | ✓ | — | — | — |
| Schedules | ✓ | ✓ | ✓ | ✓ | ✓ | — |
| Snapshots and restore | — | — | — | — | — | ✓ |
| Reschema, Data Masking, Data Generator | — | — | — | ✓ | — | — |
Data transfer runs SQL to SQL across the three SQL engines, SQL to MongoDB, MongoDB to SQL,
MongoDB to MongoDB, and Redis to Redis. Structure sync and data compare pair SQL engines with SQL
engines and MongoDB with MongoDB. On MongoDB, import and export read and write JSON, JSON Lines,
CSV and BSON files, and export SQL INSERT statements too. Schedules run backups on every engine
that has them, exports and saved comparisons on the SQL engines and MongoDB, and SQL files on the
SQL engines, while Querybara is open.
Administration
Section titled “Administration”| Feature | PostgreSQL | MySQL | MariaDB | MongoDB | Redis | Elasticsearch |
|---|---|---|---|---|---|---|
| Monitor, sessions and top queries | ✓ | ✓ | ✓ | ✓ | — | — |
| Users and roles | ✓ | ✓ | ✓ | ✓ | ✓ | — |
| Maintenance (VACUUM, OPTIMIZE, compact…) | ✓ | ✓ | ✓ | ✓ | — | — |
| Server settings or configuration | ✓ | ✓ | ✓ | ✓ | ✓ | — |
| INFO dashboard, slow log, clients, MONITOR | — | — | — | — | ✓ | — |
| Dump analysis of an RDB file, offline | — | — | — | — | ✓ | — |
| Cluster health, nodes, shards and tasks | — | — | — | — | — | ✓ |
| Index, alias, template, ILM and pipeline admin | — | — | — | — | — | ✓ |
Users and roles on Redis are ACL users. Server settings on Redis are the configuration editor. Dump analysis reads a dump file without a connection.
Command line
Section titled “Command line”| Command | PostgreSQL | MySQL | MariaDB | MongoDB | Redis | Elasticsearch |
|---|---|---|---|---|---|---|
test, query |
✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
compare, data-compare |
✓ | ✓ | ✓ | ✓ | — | — |
ddl |
✓ | ✓ | ✓ | — | — | — |
import, export, run-file |
✓ | ✓ | ✓ | — | — | — |
transfer |
✓ | ✓ | ✓ | ✓ | ✓ | — |
backup, restore |
✓ | ✓ | ✓ | ✓ | ✓ | — |
profiles |
✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
import and export read and write Parquet. Schedules, dump analysis and search indexes are in the
desktop app only.
Every engine
Section titled “Every engine”The command palette runs any command, and the Keyboard Shortcuts editor changes the key bindings. The connection toolbar under the title bar shows the essential tools of the connection in front, for every engine. The side bar searches and filters connections by engine, environment and state.
| Keys (Windows and Linux) | Keys (macOS) | Opens |
|---|---|---|
| Ctrl + Shift + P | ⌘ + Shift + P | The command palette |
| Ctrl + P | ⌘ + P | Go to Table or Collection |
| Ctrl + Alt + B | ⌘ + Option + B | Shows or hides the toolbar |
Related
Section titled “Related”Documents Querybara 0.1.19 · built from89dc752