The extension is good and free. TuskDB is for when you want Postgres work in its own app, and when you work with pgvector.
14-day free trial · no account · no credit card
Most people do not need to leave it, and that is worth saying plainly. The two reasons they do: database work competes with code for the same window, and there is no pgvector UI, so every similarity query is hand-written distance SQL.
TuskDB is a native Mac app, so grids, keyboard flow, and window management belong to the database rather than to your editor. It adds a pgvector workflow (find-similar, recall lab, index health), SSH tunnelling with strict host-key verification, and previewed one-row edits keyed to the primary key.
| Feature | TuskDB | the VS Code PostgreSQL extension |
|---|---|---|
| Native macOS app | Yes, Swift & AppKit | No, an extension inside VS Code |
| Platforms | macOS 15+ | Anywhere VS Code runs |
| Database engines | PostgreSQL only | PostgreSQL only |
| Price | $39 one-time | Free |
| Devices per license | 5 Macs, one person | Unlimited (free) |
| Updates | All updates, no renewal | Free |
| Free trial | 14 days, every feature | Free (no purchase) |
| pgvector UI | Yes, find-similar + recall lab | None found (July 2026) |
| Visual EXPLAIN | Yes, computed verdict | Yes, four-view plan visualizer |
| ERD diagram | Yes, incremental canvas | Yes, schema visualizer |
| SSH tunnel | Yes, strict host-key | Not documented (July 2026) |
Verified 23 July 2026 against the Microsoft docs and the ms-ossdata.vscode-pgsql marketplace listing. Microsoft ships often, so check their changelog before relying on any gap below.
If you are happy inside VS Code and do not touch embeddings, stay. The extension is free, Microsoft-backed, and covers EXPLAIN, ERD, and activity properly. TuskDB is $39 and Mac-only, and it should have to earn the difference.
14 days, every feature, no account. Bring your own database.