Database workspace
A multi-driver SQL + NoSQL client inside Spec ADE: inline editing, backup/restore, an ER diagram, and a Safe Mode that protects production.
Supported drivers
| Driver | Versions |
|---|---|
| PostgreSQL | 13+ (gồm 17) |
| MySQL | 5.7 · 8.0 · 8.4 |
| MariaDB | 10.6+ · 11.x |
| SQLite | bundled |
| MongoDB | 6 · 7 |
| Redis | 6 · 7 |
Safe Mode
Each connection declares a Safe Mode level: read-only, strict, confirm-destructive, or off. When the connection environment is prod/production, anything weaker than strict is escalated to strict automatically — destructive writes always require explicit confirmation.
You cannot accidentally leave a production connection loosely configured. Safe Mode escalation happens automatically based on the connection’s environment field.
Inline editing
Edit directly in the data grid with deferred commit and an SQL preview before applying. Pending edits survive tab switches thanks to the same hidden-pool technique as the terminal.
Backup & restore
Each driver uses the right tool: bundled pg_dump for Postgres; lazy-downloaded mariadb-dump/mongodump for MariaDB/Mongo; VACUUM INTO for SQLite; BGSAVE + .rdb copy for Redis. Backups can be optionally encrypted with a passphrase (Argon2id-derived AES-GCM-256).
Dump tools that are not bundled are downloaded into a cache directory on first use, and every download is verified against a hardcoded SHA-256 hash before it runs.
Import existing connections
A wizard imports connection config from TablePlus, DBeaver, Sequel Ace, and Beekeeper. It reads connection metadata only — it never decrypts those tools’ stored passwords.