Tusk
A clean, fast, connection-first desktop database studio — for PostgreSQL, MySQL and SQLite, with AI when you want it.
What Tusk does
Tusk is a standalone desktop app for Windows, macOS and Linux that boots its engine in-process — no browser, no separate server. It's connection-first, like DBeaver or DataGrip: a live connections tree on the left, a tabbed workspace on the right, and right-click context menus everywhere. Nothing queries the database until you open it.
Under one calm, consistent interface it pairs a SQL workbench, a spreadsheet-style data browser with inline editing, an ER diagram, a query-plan visualizer, schema diff/migrations, and a full backup / restore / import / export suite. An optional AI assistant — backed by local Ollama, Anthropic or OpenAI — turns natural language into schema-aware SQL.
The workbench
A faithful preview of Tusk's SQL workbench (shown with its built-in demo data):
FROM customers ORDER BY revenue DESC;
| name | orders | revenue | avg_order | country |
|---|---|---|---|---|
| Acme Corp | 128 | 84,210.00 | 657.89 | DE |
| Northwind Traders | 96 | 61,480.00 | 640.42 | US |
| Globex | 88 | 57,912.00 | 658.09 | US |
| Initech | 74 | 44,106.00 | 596.03 | CA |
| Umbrella Health | 69 | 41,330.00 | 599.13 | UK |
| Vandelay Imports | 61 | 38,745.00 | 635.16 | US |
Features
SQL workbench
Syntax highlighting, schema-aware autocomplete, run-selection, LIMIT control and a results grid.
Ask AI
Natural language → SQL, plus explain, fix and optimize. Local Ollama, Anthropic or OpenAI.
Data browser
Sort, filter and edit cells inline — review the generated UPDATE before it runs.
ER diagrams
Auto-laid-out table cards with PK/FK markers, drawn relationships, zoom and re-layout.
Query-plan visualizer
EXPLAIN ANALYZE rendered as an execution tree with a per-node timing heatmap.
Multi-engine
PostgreSQL (native), MySQL and SQLite (WASM — no native build required).
Secure connectivity
SSH tunnels (password or key auth); secrets encrypted at rest via the OS keychain.
Backup & import/export
Backup / restore plus a 4-step CSV import wizard with validation reporting.