DBKnife

Write queries, edit data and run your database servers from one app.

DBKnife is a free desktop app for MySQL, MariaDB, PostgreSQL, SQL Server and SQLite, on macOS, Windows and Linux.

Download

Free and open source, for macOS, Windows and Linux.

Works with

Runs on

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 TABLE that 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
UPDATE and DELETE without WHERE are refused. Production connections are marked on their tab. Unsaved edits and open transactions are confirmed before closing.

What each database gets

MySQL, MariaDBPostgreSQLSQL Server 2017+SQLite
SQL editor, results, grid editingYesYesYes, with GO batchesYes
Visual execution planYesYesYesYes
Table, view and routine editorsYesYesYesYes
Server status, sessions, variablesYesYesYesNo
Users and privilegesYesRolesLogins, users, rolesNo
Backup and restoremysqldumppg_dump.bacpac, .bakNo
AlsoCopy DatabaseSequences, types, extensionsSQL 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

SystemDownloadUpdates
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

All versions and their changes are on the releases page. English and Italian are built in; other languages can be added as language packs.