Skip to content

v0.21.0

Choose a tag to compare

@lukaszzochowskiluma lukaszzochowskiluma released this 05 Oct 17:42
· 5 commits to main since this release

SQL Sage 0.21.0

Free after the trial

Every install still starts with a 30-day trial of everything. When the trial ends, SQL Sage now keeps working in a free mode (SQL Sage Free) instead of switching off. These tools make zero AI calls:

  • F5 execution guard — warns before running UPDATE / DELETE without WHERE, DROP and TRUNCATE
  • JOIN…ON suggestions built from your foreign keys
  • Expand wildcards (SELECT * → column list)
  • Qualify object names
  • Format SQL — uses SSMS's built-in formatter when it is available, otherwise SQL Sage's own
  • Execute current statement — runs just the statement under the caret

AI features (chat, Explain / Fix / Optimize / Document, AI completions) and the proof and audit tools (Change-Impact, Incident Mode, Prove-It) need a license.

SQL Prompt–compatible shortcuts

Shortcut Command
Ctrl+B, Ctrl+W Expand wildcards
Ctrl+B, Ctrl+Q Qualify object names
Ctrl+K, Ctrl+Y Format SQL
Shift+F5 Execute current statement
Shift+Alt+Z / Shift+Alt+R / Ctrl+Alt+Z Explain / Fix / Optimize (AI, licensed)

If Redgate SQL Prompt is installed, these shortcuts step aside automatically so they don't clash with it. The commands are always available from the SQL Sage Tools menu when you right-click in the query editor.

"Show impact (Pro)" in the F5 guard

When the guard stops a risky batch, a new Show impact (Pro) link opens the SQL Sage panel with a change-impact request for that SQL (trial or license). Nothing is run. On the free plan, the link explains what a license adds.

Installer fix

The installer is now signed end to end. That includes the setup stage Inno Setup extracts to %TEMP% and the uninstaller. This fixes "Unable to execute file in the temporary directory. Setup aborted. Error 4551" on PCs that use Smart App Control or App Control for Business. Earlier installers had an unsigned inner stage.

Install / upgrade

  1. Close SSMS.
  2. Run SqlSageSetup.exe (below, or from the download page).

SHA-256 of SqlSageSetup.exe: B6AB0186D18D1F25D5721ADBEC11D8CE39CF8FA9B41ECF74C382E496B5B36E4F

Requirements: SQL Server Management Studio 22 on Windows (x64 / Arm64). AI features use your own Claude (Claude Code) or ChatGPT / OpenAI Codex (Codex CLI) account, so there is no API key. The free tools don't need any AI account.