Feature matrix

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

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

Feature	PostgreSQL	MySQL	MariaDB	MongoDB	Redis	Elasticsearch
SQL	✓	✓	✓	✓	—	✓
Query editor with statement splitter and history	✓	✓	✓	—	—	—
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	✓	✓	✓	—	—	—
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 Redis is 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

Feature	PostgreSQL	MySQL	MariaDB	MongoDB	Redis	Elasticsearch
Structure sync	✓	✓	✓	—	—	—
Data compare	✓	✓	✓	—	—	—
Data transfer	✓	✓	✓	✓	✓	—
Import and export wizards	✓	✓	✓	—	—	—
Parquet import and export	✓	✓	✓	—	—	—
Run SQL File	✓	✓	✓	—	—	—
Backup and restore (.qbak)	✓	✓	✓	✓	✓	—
Backup with pg_dump or mysqldump	✓	✓	✓	—	—	—
Schedules	✓	✓	✓	✓	✓	—
Snapshots and restore	—	—	—	—	—	✓

Data transfer runs SQL to SQL across the three SQL engines, SQL to MongoDB, MongoDB to SQL, and Redis to Redis. Schedules run backups on every engine that has them, and SQL files, exports and saved comparisons on the SQL engines, while Querybara is open.

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

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

The command palette runs any command, and the Keyboard Shortcuts editor changes the key bindings. 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

Related

• Supported engines and versions
• CLI reference