Skip to content

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.

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.

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.

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.

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 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.

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

Documents Querybara 0.1.19 · built from89dc752