Features

AKML SQL replicates and extends the Redgate SQL Prompt feature set inside SQL Server Management Studio 22 and Visual Studio 2026, powered by a self-contained .NET 10 engine.

• IntelliSense

  Nine completion providers — Column, Alias, Object, Keyword, Snippet, Variable, JOIN, QuickInfo, and Signature — with fuzzy matching, dot-trigger, and schema-aware ranking. The SQL Prompt-style popup shows type-coded icon badges and turns semi-transparent while you hold Ctrl to peek at the code behind it.

• Code formatting

  A 7-stage pipeline (parse → annotate → layout → cast → emit → validate → idempotency) behind 21 format commands. Share styles as .akmlstyle profiles, and round-trip SQL Prompt .sqlpromptstylev2 XML — import and export — so existing team styles carry over unchanged.

• Static analysis

  More than 130 rules across 8 categories — Performance, Best Practices, Security, Style, Design, Deprecated, Execution, and Naming — with inline suppressions, per-project .casettings, and native Visual Studio Error List integration.

• Refactoring

  Heavyweight operations like Smart Rename, Parameterize Values, and Convert Temp Table, plus 9 lightweight ops — Expand INSERT Columns, Convert Old-Style Joins, Encapsulate BEGIN/END, and more — that reshape SQL in a single action.

• Snippets

  Personal, team, and built-in snippet folders with context-aware filtering, so the right snippet surfaces where it applies. A surround-with chord wraps a selection in blocks like transactions or try/catch.

• SQL History

  A full, crash-safe history of every executed query in a three-panel UI — queries, versions, and a syntax-highlighted preview — with full-text search and star, open, and closed filters.

• AI assistance

  Text-to-SQL, Explain, Fix, Optimize, Index Analysis, Chat, and Ghost Text inline autocomplete — all schema-aware, so suggestions are grounded in the database you are actually working against.

Download AKML SQL Read the docs