SQL Prompt for VS Code

SQL Prompt is a SQL Server IntelliSense and formatting extension for VS Code. It provides schema-aware table completion, configurable alias and procedure-call insertion, wildcard expansion, and a configurable SQL formatter driven by style files, inspired by tools like Redgate SQL Prompt.

What this extension does

• Uses your active ms-mssql connection for the current SQL file
• Suggests schema-qualified table names after FROM and JOIN
• Inserts schema-aware table and function completions with configurable aliases
• Expands * and alias.* into column lists from the current query
• Inserts stored procedure calls with configurable named or positional parameters
• Reloads schema context when you switch to another .sql file with a different active connection
• Formats SQL documents using configurable style files (JSON exports from Redgate SQL Prompt)

Requirements

• VS Code 1.75+
• SQL Server for VS Code extension (ms-mssql.mssql)
• A reachable SQL Server database

Note: ms-mssql.mssql is an extension dependency and is installed automatically when needed.

First-time setup

1. Open a .sql file in VS Code.
2. Connect to your database using ms-mssql:
   • Status bar button, or
   • Command Palette > MS SQL: Connect
3. Wait a moment for SQL Prompt to detect the active connection and load schema metadata.
4. Start typing a query and trigger completion after FROM or JOIN.

Example:

SELECT *
FROM |

Typical suggestions:

• dbo.TABLE_NAME AS tn
• dbo.Orders AS o
• dbo.OrderDetails AS od

Alias and procedure insertion behavior can be customized:

{
  "sqlPrompt.completions.insertAsKeyword": false,
  "sqlPrompt.completions.aliasIgnorePrefixes": ["Bespoke_"],
  "sqlPrompt.completions.insertNamedProcedureParameters": false,
  "sqlPrompt.completions.insertSchemaPrefix": false
}

With those settings:

• dbo.Bespoke_KPIElement is inserted as Bespoke_KPIElement ke
• stored procedures are inserted without @ParamName =
• completion labels and inserted text omit the schema prefix

SQL Formatter

SQL Prompt includes a document formatter that integrates with VS Code's Format Document command.

Style selection

The active formatting style is shown in the status bar. Click it to open the style picker, or use:

• Command Palette > SQL Prompt: Select Formatting Style
• SQL Prompt: Format with <Style Name> - one command per loaded style file, bindable to keyboard shortcuts

To make SQL Prompt the default formatter for SQL files, add this to your settings.json:

{
  "[sql]": {
    "editor.defaultFormatter": "watson95.vscode-sqlprompt"
  }
}

Configuring the styles folder

Style files are standard JSON exports from Redgate SQL Prompt. Point the extension to the folder that contains them:

{
  "sqlPrompt.formatting.stylesFolder": "/path/to/your/styles"
}

The folder is scanned immediately; no reload required. Every .json file in that folder is loaded as a named style. The active style is persisted per workspace via sqlPrompt.formatting.activeStyle.

Example style file (MyStyle.json):

{
  "metadata": { "name": "My Style" },
  "casing": {
    "reservedKeywords": "uppercase"
  },
  "lists": {
    "placeCommasBeforeItems": true,
    "commaAlignment": "toList"
  },
  "whitespace": {
    "wrapLinesLongerThan": 200
  }
}

See docs/formatting/Defaults.json for the full set of supported keys, and docs/formatting/FORMATTING.md for the complete option reference.

Commands

Settings reference

IntelliSense behavior and automatic suppression

SQL Prompt can automatically suppress the ms-mssql extension's IntelliSense so that SQL Prompt completions appear first while you are connected. This suppression only affects completion suggestions; other ms-mssql features such as Script As, Alter/Modify Procedure, Execute Query, and connection sharing remain available.

Set sqlPrompt.suppressMssqlIntellisense to false to let both providers coexist, though you may see duplicate suggestions.

If changes do not apply immediately, run Developer: Reload Window from the Command Palette.

Packaging and local install (VSIX)

npm install -g @vscode/vsce
vsce package
code --install-extension vscode-sqlprompt-0.1.2.vsix

Additional documentation

• Development documentation: docs/DEVELOPMENT.md
• Formatting guide: docs/formatting/FORMATTING.md
• Planned next work: docs/ROADMAP.md
• Commit guidelines: docs/COMMIT_GUIDELINES.md