
SQL Prompt OptionsMany of SQL Prompt's options can be changed from within the command palette.

Command PaletteThe command palette provides a fast way to navigate SQL Prompt's and SSMS's functionality via a single keyboard shortcut.

Optimize SQL Query with AI

Fix SQL Query with AI

Query Index AnalysisSQL Prompt includes an AI-powered Index Analysis feature, which evaluates the performance impact of different indexes on your query using an internal machine learning model.

Customizing your Formatting StyleSQL Prompt includes options for formatting DML statements, DDL statements, CASE statements, JOINs, CTEs, and more.

Inserting Suggestions into your Code

Displaying the List of Code Analysis Issues

Enabling/Disabling Code Analysis Rules

SQL Prompt Labs

Bulk Code Analysis

Bulk Formatting SummaryOnce the formatting has finished, any errors encountered will be summarized.

Bulk Formatting Dialog

AI-enhanced coding, on your termsSQL Prompt includes optional AI-powered features designed to support your workflow. Write or modify queries using natural language, get clear explanations for unfamiliar code, and fix and optimize SQL with ease - all without leaving SSMS.

Improve code quality as-you-typeAvoid last-minute rework by writing error-free code by default. Smart code completion reduces syntax errors, while real-time code analysis and auto-fixes debugs code. Tab coloring helps keep your changes in the right environment, and refactoring helps you to confidently optimize your queries, code objects and databases.

Keep code consistentWith SQL Prompt, you don’t have to worry about structuring your code as you write it. Simply write SQL your own way and use a shortcut to format your code into a team standard instantly. Same applies for reformatting legacy code, just press CTRL+K+Y to improve readability.

Save time and effort writing SQLWrite SQL up to 50% faster. SQL Prompt speeds up coding by auto-completing your code with valid, context-aware suggestions. Say goodbye to repetitive typing with customizable code snippets and comprehensive query history.