Skip to content

Releases: betocmn/widen

Release list

Widen 0.1.0

Choose a tag to compare

@betocmn betocmn released this 17 Jun 02:42
efcf37c

Widen 0.1.0

Ask Postgres with the LLM already on your Mac.

Widen is a free, open-source, native macOS Postgres GUI for macOS 26+.
It introspects your schema, drafts SQL with Apple's on-device Foundation Model
through the macOS Foundation Models framework, shows every query for review,
and only runs what you approve.

Download

Download Widen.dmg

The DMG is signed and notarized. Sparkle updates are served from GitHub
Releases.

Compatibility

  • macOS 26 or later.
  • Apple Silicon.
  • Apple Intelligence enabled for local AI generation.
  • PostgreSQL only today.
  • Xcode 26 only if you want to build from source.

Privacy model

No backend. No account. No analytics.

Mode Schema/question Query results Notes
Local mode Stays on your Mac Stays on your Mac Default. Prompts go to Apple's local Foundation Model through macOS.
Cloud mode Sent to the provider you choose Stays on your Mac Optional. Use Apple Private Cloud Compute on macOS 27+, or OpenRouter with your own API key.

Passwords and API keys live in the macOS Keychain, never on disk in plaintext.

Safety model

Widen drafts SQL. You review it. Widen validates it. Then you decide whether
to run it.

  • One statement only.
  • Reads use SELECT/WITH; writes must be explicit INSERT/UPDATE/DELETE.
  • No DDL, transaction keywords, semicolon chains, pg_sleep, dblink, or
    large-object calls.
  • Statement timeouts and row caps apply at execution time.
  • Writes are never auto-run, and Widen asks for confirmation before DELETE
    or an UPDATE without a WHERE.

What's included

  • Native macOS Postgres workbench.
  • Schema inspector for tables, columns, types, and foreign keys.
  • Persistent query sessions with chat, SQL, and run history.
  • Local Foundation Model SQL generation by default.
  • Optional cloud model toggle for Apple Private Cloud Compute or OpenRouter.
  • Guarded read and write query execution.
  • CSV copy/export from result tables.
  • Sparkle auto-update support.

Known limitations

  • Early MVP, not full DataGrip/TablePlus/Postico feature parity.
  • The local Foundation Model has a small context window; very large schemas are
    truncated whole-table-at-a-time before prompting. If you need a stronger
    model, Widen already supports cloud generation with your own OpenRouter API
    key, and includes support for Apple's Private Cloud Compute models in the
    upcoming September OS releases.
  • Results are rendered as text values; typed grid behavior is still limited.
  • Export is CSV-only today.
  • No SQL syntax highlighting yet.
  • Query results are not persisted across restarts. Transcripts, SQL text, and
    generation metadata are persisted; rerun a session's query to repopulate the
    grid.

Changelog

  • Persist database schema cache and refine startup UX in PR #8.
  • Add query context and paginated results in PR #9.
  • Add selectable cloud LLM backends in PR #10.
  • Add paste autofill for connection settings in PR #11.
  • Add Sparkle auto-update support in PR #12.
  • Retry and repair generated SQL failures in PR #13.
  • Add schema View Data sessions in PR #14.
  • Enable guarded write SQL queries in PR #15.
  • Configure Developer ID releases and Sparkle updates in PR #16.
  • Automate GitHub release publishing in PR #17.

Full changelog: https://github.com/betocmn/widen/commits/v0.1.0