Works with
- MySQL
- MariaDB
- PostgreSQL
- SQL Server
- SQLite
Runs on
- macOS12 or later, Apple Silicon and Intel
- Windows10 and 11, from the Microsoft Store or an installer
- Linuxx64, as .deb or AppImage
What it does
- SQL editor
- Completion of schemas, tables and columns, through aliases too. Formatting, find and replace, snippets. Run everything, the selection or the statement under the cursor.
- Results you can edit
- A fast grid with filter and sort, for hundreds of thousands of rows. Edit cells, add and delete rows: every change is shown as SQL before it is applied.
- Execution plans
- The plan of a query drawn as a diagram, to see why it is slow.
- Table and object editors
- Columns, indexes, foreign keys and triggers; views, procedures and functions. The table editor writes the smallest
ALTER TABLEthat makes the change. - Server administration
- Server status with live charts, client sessions, server variables, users, roles and privileges, backup and restore.
- Import and export
- Results to CSV, JSON, SQL, HTML and Excel. CSV files and spreadsheets (xlsx, xls, ods) into a table.
- Files as connections
- SQLite databases and CSV files open like a server. A CSV file is edited as a table and saved in its own format.
- Safe by default
UPDATEandDELETEwithoutWHEREare refused. Production connections are marked on their tab. Unsaved edits and open transactions are confirmed before closing.
What each database gets
| MySQL, MariaDB | PostgreSQL | SQL Server 2017+ | SQLite | |
|---|---|---|---|---|
| SQL editor, results, grid editing | Yes | Yes | Yes, with GO batches | Yes |
| Visual execution plan | Yes | Yes | Yes | Yes |
| Table, view and routine editors | Yes | Yes | Yes | Yes |
| Server status, sessions, variables | Yes | Yes | Yes | No |
| Users and privileges | Yes | Roles | Logins, users, roles | No |
| Backup and restore | mysqldump | pg_dump | .bacpac, .bak | No |
| Also | Copy Database | Sequences, types, extensions | SQL Server Agent jobs (read-only) |
Backup and restore use the database's own command-line tools, which have to be installed. Connections can go through SSH tunnels and SSL.
Download
| System | Download | Updates |
|---|---|---|
| macOS 12 or later | Apple Silicon, Intel | Automatic |
| Windows 10 and 11 beta | Microsoft Store, installer for x64 | Automatic from the Store; with the installer, download the new version |
| Linux x64 beta | .deb for Debian and Ubuntu, AppImage for other distributions | Download the new version |
- macOS: open the
.dmgand drag DBKnife to Applications. The app is signed and notarized by Apple, and updates itself. - Windows: the installer is not signed yet, so SmartScreen shows "Windows protected your PC": choose More info, then Run anyway. The Microsoft Store version has no warning.
- Linux: make the AppImage executable before the first start (Properties, Allow executing as program, or
chmod +x). - Beta: DBKnife is developed and used every day on macOS. The Windows and Linux versions come from the same code, but have been tried much less.
All versions and their changes are on the releases page. English and Italian are built in; other languages can be added as language packs.