SQL Explorer 0.2.0
Features
- feat: Elasticsearch query sweep + inline update bar with download/install
- feat(mcp): SE-147 no console window on Windows + Start/Stop toggle in Settings
- feat(security): SE-145 redact secrets from MCP query results
- feat(updater): SE-137 Fase 2 — in-place update, rollback, periodic check
- feat(updater): SE-137 in-app updater with release channels (Fase 0+1)
- feat(providers): SE-128 show the engine server version (host API v25)
- feat(ci): version the artifact names and ship a Windows installer
- feat(legal): SE-127 generate third-party notices from the NuGet closure
- feat(about): SE-126 diagnostics — system info, plugin list, copy to clipboard
- feat(main-window): SE-123 tool-window model for Output and History
- feat(plugin-store): SE-120 version-pin plugins to hold a specific release
- feat(settings): SE-122 move Plugin Store sources to Settings
- feat(plugin-store): SE-121 category chip-filter in Browse sidebar
- feat(mssql): SE-116 login Properties prefill + diff-based Apply
- feat(connection-manager): drag-to-reorder + provider icons
- feat(elasticsearch): add Elasticsearch provider + cursor-paging fundament (SE-3)
- feat(dragonflydb): add DragonflyDB provider plugin (SE-4)
- feat(sdk,plugins): non-SQL editable-grid writeback + Redis provider (SE-114/SE-20)
- feat(mssql): server-login management via compiled-AXAML view (host-API v21)
- feat(plugins): accept a host-API version range; store compat by build version
- feat(backup): restore per-object selection + Fase 2b + dialog polish
- feat(mongodb): MongoDB provider + non-SQL provider seam (host API v20)
- feat(backup): per-object schema/data selection + live checklist (Fase 1+2a)
- feat(plugins): localization seam + translated tool plugins + built-in Store icons
- feat(security): optional master password + quick wins
- feat: quick fixes — context menu, top 1000, MCP query-log tool
- feat(logging): opt-in query log with source scope + non-modal viewer
- feat(mcp): host-owned MCP server for AI query access
- feat(security): user management + ICustomSecurityUi seam
- feat(monitor): activity monitor + provider-owned cell actions
- feat(schema): view/table DDL script + folder object counts
- feat(ci): build on push to main
- feat(app): quick wins — HTML copy, GUID insert, exit confirm, SQLite backup
- feat(mssql): admin dialogs, nested tool menus and connection tuning
- feat(ci): ad-hoc sign macOS bundle and document quarantine workaround
- feat(ci): publish rolling nightly release with fixed asset links
- feat(schema): browse and execute procedures, functions and triggers
- feat(editor): persist editor zoom to the font-size setting
- feat(app): session restore, system-database toggle, and editor/grid polish
- feat(tree): size badges, compact rows, and tab/grid polish
- feat(output): auto-scroll, copy-all, and affected-row count
- feat(output): copy an output line via right-click
- feat(store): plugin store UI + wiring — Browse/Installed/Sources, install flow
- feat(store): plugin store core — dual-root loader, catalog + install pipeline
- feat(shortcuts): configurable keyboard shortcuts + plugin shortcut SDK
- feat(app): schema-tree UX, editor/grid quick wins, tab restyle
- feat(backup): streaming .lbak v2 for large LOBs + datatype-correct restore
- feat(tools): tool plugin SDK + universal backup/restore
- feat(settings): plugin settings SDK + redesigned preferences window
- feat(connections): add connection manager window with nested folders
- feat(connections): sidebar folders to group connections (FR-6)
- feat(query): Stop button to cancel a running query (FR-7)
- feat(connections): keep an open connection alive when editing it
- feat(app): error banner + output/log panel for failures and notices
- feat(mssql): render Advanced connection section via Route B custom view
- feat(connections): Route B seam — provider-supplied advanced connection UI
- feat(connections): import connection string to prefill fields (FR-1)
- feat(connections): rich, grouped advanced connection settings
- feat(desktop): macOS .app bundle packaging with native menu bar
- feat(app): settings window, menu bar, and copy-result-to-clipboard
- feat(app): merge command palette into Ctrl+K quick-open
- feat(app): result export (CSV/JSON/SQL), CSV import, per-column browse filter
- feat(app): execute-selection/at-cursor, multi-resultset, EXPLAIN, FK-introspectie
- feat(app): DDL create, connection/db switcher, DROP/ALTER, auto-increment
- feat(app): schema-aware SQL completion (Ctrl+Space / on ".")
- feat(app): schema cache + quick-open object search (Ctrl+K)
- feat(app): selection aggregation strip (count/sum/avg/min/max)
- feat(app): cell value viewer with JSON pretty-print
- feat(app): persistent, searchable query history with re-run
- feat(app): per-connection colour flag + read-only safe mode
Fixes
- fix(ci): use commit SHA as release target, not the v-tag name
- fix(about): show all three host API contracts, not just the provider
- fix(store): SE-136 judge mcp plugins against the McpHostApi window
- fix(ci): SE-135 harden the build pipeline against injection and unverified tools
- fix(about): read the informational version so the build channel shows
- fix(plugin-store): require https for sources and downloads, pin only a deliberate choice
- fix(about): localize the plugin source and flag labels
- fix(mssql): correct role diffing, USE parsing and password masking in login properties
- fix(build): set the product version to 0.1.0
- fix(app): don't crash on startup when a saved connection's provider is missing
- fix(ui): colour a connection's status dot when a query auto-connects
- fix(ui): render plugin icons crisply at small sizes
- fix(ci): set GH_REPO so nightly release works without a checkout
- fix(ci): make macOS ad-hoc signing non-fatal
- fix(ci): pin AppImage arch to x86_64
- fix(browse): stop the connection switcher nulling a browse tab's connection
- fix(store): align Plugin Store UI with mockup + polish
- fix(mssql): full column type with length in schema tree
- fix(connections): connect on root expand + full-width Advanced section
- fix(connections): edited advanced values now show in a Route B view on re-edit
- fix(app): keep SQL editor pane on New Query after a browse tab
Other
- ci: retry the DMG build when hdiutil reports "Resource busy"
- ci: build develop nightly and main as preview
- chore(mssql): bump sqlserver plugin to 0.2.1 with refreshed icon
- perf(app): fix DataGrid scroll + browse page size, language dropdown, settings polish
- chore(redis): embed the brand icon (matches MongoDB's icon.png convention)
- chore(plugins): version bundled plugins at 0.1.0
- Fix icon paths in build.yml for SqlExplorer
- Fix publish command path in build.yml
- refactor(rename)+feat: SqlExplorer namespaces, tray, DB properties tabs
- Update release condition to include push events
- chore(ci): skip push builds for docs-only changes
- docs(ci): update build workflow header for active nightly schedule
- Enable nightly build schedule in GitHub Actions
- chore(ci): add multi-platform build workflow
- refactor(output): consolidate query feedback into the Output panel
- docs(plugins): document tool plugins, settings/shortcut capabilities
- docs: add plugin authoring guide (PLUGINS.md)
- reordenend solution folders
- refactor(plugins): move dev-only template provider to repo-root plugins/
- refactor(sdk): align namespaces with folders
- refactor(sdk): consolidate to one SDK project with folders
- refactor(sdk)!: manifest provider identity + execute-time database context
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.