Tusk 2026.06.04-00

Fixes

• Fixed PostgreSQL numeric result decoding so values copy/export correctly.
• Focuses the SQL editor when opening a new query tab.

Other

• Added project-local Codex skills.
• Added project-specific dev-review rules.

---

Not notarized. On first launch right-click -> Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app

Tusk 2026.04.24-00

Features

• SSH agent authentication for SSH tunnels — select "SSH Agent" in the connection sheet to use $SSH_AUTH_SOCK (works with 1Password, Secretive, ssh-agent)
• Visual EXPLAIN plan viewer — node graph with pan/zoom and cost colour-coding alongside the existing tree view; bottlenecks visible at a glance
• Query notifications — get a macOS notification when a long-running query completes
• Confirm before delete — confirmation prompt before destructive row deletions
• Data browser polish — sidebar debounce, parallel schema loads, column cache

Fixes

• SSH agent mode: BatchMode=yes to fail fast when agent has no matching identity; skip Keychain passphrase lookup in agent mode
• Explain graph: cached layout data in init, single-pass O(n) tree build algorithm
• Main-thread delivery guaranteed for tab activation notifications
• SQL execution cap at 50 in-flight entries
• UX: toolbar verb consistency, copy fixes, hints, tooltips, empty states

---

Not notarized. On first launch right-click → Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app

Tusk 2026.04.23-00

Features

• Import connections from .pgpass file — new menu item in the sidebar + button, with a table view showing parsed entries, duplicate detection, and selective import
• Filter clear button in the query editor and navigable relation nodes in the schema graph
• Function source viewer tab and executor
• Enum and sequence detail tabs; context menus for sidebar schema objects
• Sidebar tree visual polish — icons, hierarchy, and density improvements

Fixes

• .pgpass entries with wildcards in identifying fields are now skipped (no invalid blank-host connections)
• Empty .pgpass passwords no longer wipe existing Keychain entries
• Stale async load results discarded on rapid file picker use
• Schema resolution for relation nodes corrected
• Connection sheet UX, role detail badge, and copy fixes
• Enum/sequence/function detail view polish
• DROP PROCEDURE used for procedures instead of DROP FUNCTION
• Public schema and tables collapsed by default in sidebar

Performance

• Nine performance optimisations across SQL execution, sidebar rendering, copy, and proxy

---

Not notarized. On first launch right-click → Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app

Tusk 2026.04.20-00

Features

• Google Cloud SQL — first-class connection type with automatic cloud-sql-proxy lifecycle management
• Cloud SQL instance picker — browse instances via gcloud sql instances list with search/filter
• Cloud SQL database picker — list databases on an instance via gcloud sql databases list
• IAM / Application Default Credentials — connect with ADC via gcloud auth print-access-token; no static password needed
• Proxy status badge — sidebar badge shows proxy starting / running / crashed with restart action
• Empty schema visibility — schemas with no tables now appear in the sidebar via pg_namespace

Fixes

• SSL correctly disabled on local cloud-sql-proxy connection (proxy handles SSL to Cloud SQL)
• Proxy auto-restarts on crash when switching databases
• Test Connection proxy stopped on sheet dismiss
• Stale Keychain password deleted when switching to ADC
• Proxy crash status synced to sidebar badge in real time
• readDataToEndOfFile() replaced with non-blocking availableData in proxy error path
• gcloud availability cached to avoid blocking main thread during UI render

---

Not notarized. On first launch right-click → Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app

Tusk 2026.04.08-00

Fixes

• SSL connections now work with AWS RDS and other private CA setups. A new Verify Certificate toggle (off by default) appears under Use SSL, separating encryption from certificate verification — matching psql's sslmode=require behaviour. Previously, Tusk would fail with a misleading "could not reach the server" error when the server's certificate wasn't in the macOS system trust store.
• SSL mode upgraded from .prefer to .require when SSL is explicitly enabled.
• Improved error message when a TLS handshake fails — now suggests disabling certificate verification rather than checking host/port.
• sslmode=verify-full / sslmode=verify-ca in pasted URIs now correctly enables the Verify Certificate option.

---

Not notarized. On first launch right-click → Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app

Tusk 2026.04.07-00

Features

• Role browser — new "Users & Roles" sidebar tree node per connection, with Users (login-enabled) and Roles sub-groups
• Per-role detail tabs — click any role to open a dedicated tab with full superuser management: toggle attributes, rename, set password, grant/revoke membership, drop role
• Schema management — add constraints, create indexes (#135, #137, #138)
• Superuser badge and live filter bar in the sidebar (#133, #134)
• Cancel running query and toggle line comments in the SQL editor
• Configurable page size and pinned columns in the data browser

Fixes

• Password redaction in Activity Monitor (PASSWORD '...' replaced with PASSWORD '***')
• Roles cache now retried on failure (nil sentinel preserved)
• validUntil nil handling corrected for SQL NULL / infinity values
• FK source column now single-select; stale tabs closed on schema rename

---

Not notarized. On first launch right-click → Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app

Tusk 2026.03.28-00

Features

• Switch database — right-click a connected server to switch between databases without reconnecting; SSH tunnel is reused, schema tree reloads automatically
• Read-only mode — per-connection toggle that sets default_transaction_read_only = on at session start; all write affordances (insert, edit, delete, schema mutations) are hidden; lock icon in sidebar
• Paste URI — paste a postgresql:// URI in the New Connection sheet to auto-fill all fields
• Duplicate connection — right-click a connection to duplicate it with credentials copied
• Connection notes — optional notes field on each connection; shown in sidebar tooltip

Fixes

• Schema caches cleared before refresh on database switch to prevent stale data after a failed refresh
• Database list cleared on reconnect so stale server databases are never shown
• Connection notes trimmed before tooltip display to avoid blank lines
• decodeIfPresent used for all optional Connection fields so existing saved connections survive app updates
• URI parser now requires an explicit host (no silent localhost fallback) and handles sslmode case-insensitively
• isReadOnly flag propagated into Test Connection so the read-only session setup is validated before saving

---

Not notarized. On first launch right-click → Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app

Tusk 2026.03.27-00

Features

• Schema DDL: Drop and truncate tables directly from the sidebar context menu — confirmation dialog warns of FK dependents and offers CASCADE option
• Create Table wizard: "New Table…" also available on the Tables row context menu (in addition to the schema label)
• Edit column attributes: Edit type, default, and nullability from the Columns tab
• Add/drop columns: Add and drop columns directly from the Columns tab

Fixes

• Drop Table: dependency lookup errors now surface an alert instead of silently showing "no dependents"
• Drop Table: dependent table list is now schema-qualified (e.g. public.orders) and correctly deduplicates across schemas
• Truncate Table: schema tree and table sizes refresh after a successful truncate
• Create Table sheet no longer flickers or reopens after a table is created
• Column actions (Rename, Edit, Drop) now require a single selection; SQL inputs validated against injection characters
• ALTER COLUMN multi-step operations wrapped in a transaction
• Table rename correctly updates open tab title and query connection target

---

Not notarized. On first launch right-click → Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app

Tusk 2026.03.22-02

Features

• In-app Help view (⌘?) with keyboard shortcuts reference and feature tips for the Query Editor, Data Browser, and Schema Browser

Fixes

• Row selection now fires on mouse down (matches native AppKit behaviour, eliminates perceived lag)
• Control-click no longer clobbers multi-row selection when opening the context menu
• Help menu now shows only "Help…" and "Sponsor Tusk…" — removed the broken default "Tusk Help" item
• Help… and Sponsor Tusk… are now in the correct order in the Help menu

---

Not notarized. On first launch right-click → Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app

Tusk 2026.03.22-01

Features

• Resizable columns — drag column header edges to resize; applies to both data browser and query results
• Column width persistence — resized widths are saved per connection + schema + table and restored on next open
• Sortable columns in data browser — click a column header to sort ascending; click again for descending; click a third time to clear; ↑/↓ indicator shown in active header

Fixes

• Sort column now resets when switching tables (previously stale sort could cause failed loads)
• ORDER BY now uses proper identifier quoting for column names containing special characters
• Column header hover cursor no longer pops unrelated cursors when sorting is disabled
• UserDefaults key for column widths now uses unambiguous separator (no collision risk with schema/table names containing dots)

---

Not notarized. On first launch right-click → Open, or run:

xattr -d com.apple.quarantine /Applications/Tusk.app