Skip to content

SQL Explorer 0.3.0

Latest

Choose a tag to compare

@github-actions github-actions released this 19 Jul 21:01
f47cbfe

Added

  • Open & save queries as .sql filesCtrl+O to open (or drag a .sql file onto the window),
    Ctrl+S to save, plus Save As and a File ▸ Recent menu. Tabs show a dirty marker and remember
    their file across sessions, and closing a tab or the app offers to save unsaved changes — a
    preference in Settings ▸ Startup turns that prompt off. Saving pending grid-row edits back to the
    database moved from Ctrl+S to Ctrl+Shift+S.
  • Configurable update-check interval — choose how often the app checks for a new release.
  • A shared "Copied" confirmation for copy actions, shown bottom-centre.
  • SQL formatting options in Settings — keyword casing (UPPERCASE / lowercase / preserve) and
    indent width.
  • Proactive plugin-update notifications — an ambient top-bar badge and a persistent, actionable
    notification when compatible updates are available for your installed plugins, without opening the
    Plugin Store, plus a per-plugin changelog (from the notification or any updatable Store row).
    An opt-in Auto-apply on restart policy can stage compatible, non-pinned updates silently, and
    updates that need a newer app are shown ("Update app…") instead of hidden. Off / Notify / Auto in
    Settings ▸ Plugins.
  • Plugin Store "Updates" section — installed plugins with an available update are grouped at the
    top of the Installed tab under "Updates", so you no longer have to hunt for which ones can update
    (they no longer also appear in the list below).
  • extension plugin type — plugins are no longer only one-shot providers and tools: an
    extension plugin can run as a long-lived subsystem that contributes its own bottom panel,
    background work, Tools-menu items and managed connections, each behind a per-capability consent
    shown when you install it.
  • AI can create connections over MCP — with the MCP server on and the new "Let the AI create
    connections" setting enabled (off by default), an AI client can list the available providers and
    create or delete database connections. Fail-closed: creation is refused unless you opt in, only
    loopback hosts are allowed until you add more, persistent connections are capped at read-write, and
    every create/delete is audited. New connections land in an "MCP" folder; temporary ones are
    session-only and cleared when the app closes.
  • AI-activity panel — a bottom tool panel (toggled from the status bar) showing what an AI does
    over MCP: each call, the connection, and whether it was allowed or denied.
  • AI access on the connection tree — connections carry "AI" and "Temporary" badges, and a
    right-click AI access submenu sets the level (None / Read-only / Read-write) or excludes a
    connection from the AI without opening the Connection Manager.
  • One bottom panel at a time — a Settings ▸ Appearance toggle (on by default) so opening a bottom
    panel (Output, Containers, AI activity) closes the others instead of stacking them.
  • Search the Settings — a search box above the category rail filters categories by name or by the
    settings inside them (e.g. "token" surfaces MCP, "theme" surfaces Appearance).

Changed

  • The Plugin Store type filter is now a dropdown instead of a row of chips — more compact and it
    scales as new plugin types are added.

  • Release notes and the in-app updater now read the curated CHANGELOG.md instead of the raw git
    log, so each release describes what changed for you rather than listing commit subjects.

  • App and plugin update checks now log to the Output panel (channel + result), so you can see when
    a check runs and what it found.

  • The SQL formatter now indents SELECT column lists, parenthesised subqueries and JOIN/AND/OR
    conditions, instead of only breaking clauses onto their own lines. SQL Server gets a dedicated
    T-SQL formatter (Microsoft's official ScriptDom parser); the other engines use the improved generic
    engine.

Fixed

  • The app updater no longer offers a lower version on another channel as an "update" — switching
    channels only surfaces a build with an equal-or-higher core version, so a 0.3.0 build is never
    prompted to "update" to 0.2.0-preview.
  • Nightly and preview builds now stamp the version from the branch they are built from, so the About
    dialog no longer shows a mismatched build version.
  • The bottom tool panels (Output, Containers, AI activity) can now be resized by dragging their
    top edge — previously dragging did nothing, or left an empty band above the status bar.
  • "Restart app" (and the in-app updater's relaunch) now reliably brings the app back: the new
    instance no longer connects to the still-closing old one, defers to it and exits — which could leave
    no window at all. It also relaunches correctly when the app runs through the dotnet muxer.

These builds are unsigned / not notarized.
macOS: after moving to /Applications, clear quarantine: xattr -cr "/Applications/SQL Explorer.app".
Windows: pick the -setup.exe (per-user, no admin) or the .zip; SmartScreen may warn on first launch.