Features
Twelve gestures, recorded from the real app.
Each figure is a recording of the interface with the demo data, no editing. Below, the full index.
SQL editor
Completion knows the database's tables and columns; results stream in as the server sends them.
Find anything
Ctrl+K finds tables, scripts and commands; the right arrow shows what you can do with them.
Pending changes
Edit cells and delete rows, read the SQL, then apply it all in one transaction.
Dry run
The write runs in an open transaction: you see the rows it touched, then commit or roll back.
Guarded production
A production connection opens read-only. To write, you unlock it and type its name.
Foreign keys
F4 on a key opens the linked row, Links shows what points to it, Alt+Left goes back.
Find a value
A name or a code and no idea where it lives: it searches every table, read-only.
Query plan
The plan, drawn: where the time goes, how many rows pass, which index is missing.
Charts
From result to chart in one click: bars, lines, areas, pies and scatter.
ER diagram
Tables and relations lay themselves out; pan and search stay smooth at five hundred tables.
Table editor
Add or change columns and indexes; the ALTER TABLE script writes itself on the right.
Who blocks whom
Connections, open transactions and, under each blocking session, the ones waiting on it.
Everything else. The full index.
Features by area, named as the app names them. The detailed guides live in the manual, inside NiceDB (F1).
Connections
- Connection URL
- Passwords in the keychain
- TLS and client certificate
- SSH tunnel with host key check
- SSH jumps and proxy
- Templates and variables
- Init query
- Keep-alive and reconnect
- Idle timeout
- Row limit
Explorer
- One tree per server
- Estimated rows
- Filter objects
- Visible databases and schemas
- Users and sessions from the server
- Maintenance
- Thousands of objects
SQL editor
- Context-aware completion
- Joins from foreign keys
- Unknown names underlined
- Rename alias
- Multiple cursors
- Format
- Snippets
- Query parameters
- Risk analysis
Results
- Streaming rows
- Spreadsheet selection
- Selection totals
- Copy in several formats
- Server-side sorting
- Value panel: JSON, XML, images
- History
- Compare with…
- Export
Data
- Data view with filters
- Pending changes
- Show SQL and Apply
- Concurrency check
- Undo and redo
- Foreign keys and links
- Open transaction
- Dry run
- Write log
Production
- Read-only
- Timed unlock or until disconnect
- Confirm by name
- Risky statements
- Time limit per environment
- Test data never in production
Schema
- Show DDL and Copy CREATE
- Generate SQL
- Dependencies
- Table editor with live script
- Trial apply
- ER diagram
- Export the diagram
Plans
- Explain
- Where the time goes
- Notes with the missing index
- Compare with the previous plan
- Estimate only
- MongoDB and ClickHouse plans
Charts
- Bars, lines, areas, pies, scatter
- Stacked and log scale
- Time axis
- Chart of a selection
- Export to SVG and PNG
Tools
- Activity and kill
- Monitor and slow queries
- Who blocks whom
- Disk usage
- Users and privileges
- Schema compare
- Data compare
- Find a value
- Test data
- Backup and restore
- Import and export
- Security check
Organisation
- Folders
- Workspaces
- Notes and saved scripts
- Command palette
- Encrypted .nicedb export
- Ctrl+Z everywhere
Look
- Four styles
- Three palettes per style
- Light and dark
- Interface size
- English and Italian
- Sounds, off or on
Other engines
- MongoDB: documents and commands
- Redis: keys and values
- ClickHouse: query progress
- TimescaleDB, Supabase, Neon
- YugabyteDB, TiDB, PlanetScale
The rest
- Manual inside the app (F1)
- Signed updates
- Third-party licences
- Linux, Windows, macOS