PgDesigner
Announcements

PgDesigner v0.0.2 — DSN Introspection, Keyboard Shortcuts, and Project Settings

vmkteam •
#postgresql#schema-design#release#ux

PgDesigner v0.0.2 is out. This release focuses on UX: faster workflows, less mouse clicking, and direct PostgreSQL connectivity.

DSN Introspection

Connect to a live PostgreSQL instance, preview schemas and tables, and selectively import what you need. No more exporting SQL dumps and converting — point PgDesigner at your database and pick the tables you want.

PgDesigner DSN Introspection dialog connecting to PostgreSQL and showing schemas in light theme

This works alongside existing import from .pdd, .dbs, .dm2, and plain SQL.

Canvas Hotkeys

Three new hotkeys on the ERD canvas:

  • T — create table
  • F — create foreign key
  • M — create many-to-many relationship

Combined with click-to-create-FK from v0.0.1, you can now build an entire schema without touching a menu.

Keyboard Shortcuts

Full keyboard shortcut support:

  • Ctrl+N — new project
  • Ctrl+O — open file
  • Ctrl+S — save
  • Ctrl+Shift+S — save as
  • Ctrl+W — close project
  • ? — keyboard reference

Project Settings

Per-project configuration: PostgreSQL version target, naming conventions, FK defaults, and lint config. Settings are stored inside the .pgd file, so they travel with the project and are shared across the team via git.

Auto-save DDL

Enable auto-save to generate a .sql file alongside your .pgd on every save. Your DDL stays in sync with your schema without an extra step.

Save SQL

Export DDL, diff patches, and test data as .sql files directly from the UI.

More improvements

  • Update checker — status bar badge when a new version is available
  • Column index indicator — Ix column in grid, index links in column properties
  • Recent files — welcome screen shows your 2 most recent projects
  • Flat SVG toolbar icons replacing emoji
  • FK referenced column is now a dropdown
  • VueUse adoption and Vue 3.5 best practices

Bug fixes

10 fixes including: multi-schema FK lint false positive (E009), multi-schema layout position corruption (W014), duplicate table creation, node position jumps after FK creation, fitView over-zooming on small schemas, and several keyboard shortcut conflicts.

Full changelog: v0.0.1…v0.0.2

← Back to Blog