Connections

• MS SQL: Connect — connect using connection profiles or recent connections
• MS SQL: Disconnect — disconnect the current editor session
• MS SQL: Use Database — switch to another database on the same server
• MS SQL: Manage Connection Profiles — create, edit, or remove connection profiles
• MS SQL: Add Connection — add a new connection to the Object Explorer

Queries

• MS SQL: New Query — open a new SQL query file with your selected connection
• MS SQL: Execute Query — run T-SQL scripts, statements, or batches
• MS SQL: Execute Current Statement — run only the statement under the cursor
• MS SQL: Cancel Query — cancel a running query
• MS SQL: Estimated Plan — view the estimated execution plan without running the query
• MS SQL: Toggle Actual Plan — enable or disable actual execution plan capture

Local Development

• MS SQL: Create Container Group — set up a new SQL Server container locally
• MS SQL: Schema Designer — open the visual schema designer
• MS SQL: Schema Compare — compare schemas between databases, DACPACs, or SQL projects

Data

• MS SQL: Edit Data — browse and edit table data inline
• MS SQL: Select Top 1000 — quick-select rows from a table
• MS SQL: Data-tier Application — deploy, extract, import, or export DACPAC/BACPAC files

Copilot

• MS SQL: Explain Query — get an AI explanation of the current query
• MS SQL: Analyze Query Performance — AI-powered query performance analysis
• MS SQL: Rewrite Query — let Copilot rewrite and optimize your query

// General Settings
{
  "mssql.enableExperimentalFeatures": false,                // Enable experimental features for early testing
  "mssql.enableRichExperiences": true,                     // Enable rich UI experiences (tables, schema designer)
  "mssql.logDebugInfo": false,                             // Enable debug logging for troubleshooting
  "mssql.messagesDefaultOpen": true,                       // Show messages panel by default after query execution
  "mssql.autoRevealResultsPanel": false,                    // Auto-reveal results panel when queries execute
  "mssql.statusBar.connectionInfoMaxLength": -1,           // Max characters to display in status bar (-1 = unlimited)
  "mssql.statusBar.enableConnectionColor": true,            // Color-code status bar by connection group
  "mssql.schemaDesigner.enableExpandCollapseButtons": true, // Show expand/collapse buttons in Schema Designer UI for entity relationships
  "mssql.showChangelogOnUpdate": true                       // Show changelog when extension updates
}

// Connectivity
{
  "mssql.maxRecentConnections": 5,                         // Number of recent connections to display (0-50)
  "mssql.connectionManagement.rememberPasswordsUntilRestart": true,  // Keep passwords in memory until VS Code restarts
  "mssql.enableConnectionPooling": false,                  // Enable connection pooling for improved performance
  "mssql.enableSqlAuthenticationProvider": true,           // Enable SQL authentication support
  "mssql.azureActiveDirectory": "AuthCodeGrant"            // Azure AD auth method: "AuthCodeGrant" or "DeviceCode"
}

// Query Formatting
{
  "mssql.format.alignColumnDefinitionsInColumns": false,   // Align column definitions in CREATE TABLE statements
  "mssql.format.datatypeCasing": "none",                   // Datatype casing: "none" | "uppercase" | "lowercase"
  "mssql.format.keywordCasing": "none",                    // SQL keyword casing: "none" | "uppercase" | "lowercase"
  "mssql.format.placeCommasBeforeNextStatement": false,    // Place commas before next item (procedural style)
  "mssql.format.placeSelectStatementReferencesOnNewLine": false  // Put SELECT references on new lines
}

// IntelliSense
{
  "mssql.intelliSense.enableIntelliSense": true,           // Enable IntelliSense for T-SQL code completion
  "mssql.intelliSense.enableErrorChecking": true,          // Enable real-time syntax and semantic error checking
  "mssql.intelliSense.enableSuggestions": true,            // Enable code suggestions and autocompletion
  "mssql.intelliSense.enableQuickInfo": true               // Show quick info tooltips on hover
}

// Query Execution
{
  "mssql.query.displayBitAsNumber": true,                  // Display bit values as 0/1 instead of false/true
  "mssql.query.preventAutoExecuteScript": false,           // Prevent auto-execution of scripts on file open
  "mssql.query.maxCharsToStore": 65535,                    // Maximum characters to store per result cell
  "mssql.query.maxXmlCharsToStore": 2097152,               // Maximum characters for XML data in results
  "mssql.query.rowCount": 0,                               // SET ROWCOUNT value (0 = unlimited rows returned)
  "mssql.query.textSize": 2147483647,                       // SET TEXTSIZE for text/ntext columns (bytes)
  "mssql.query.executionTimeout": 0,                       // Query timeout in seconds (0 = no timeout)
  "mssql.query.noCount": false,                            // Execute SET NOCOUNT ON (suppresses row count message)
  "mssql.query.noExec": false,                             // Parse only without executing (SET NOEXEC ON)
  "mssql.query.showActiveConnectionAsCodeLensSuggestion": true // Show active connection as CodeLens suggestion
}

// Advanced Query Execution (T-SQL SET Options)
{
  "mssql.query.parseOnly": false,                          // Parse queries without executing (SET PARSEONLY ON)
  "mssql.query.arithAbort": true,                          // Terminate query on overflow/divide-by-zero (SET ARITHABORT ON)
  "mssql.query.statisticsTime": false,                     // Display execution time statistics (SET STATISTICS TIME ON)
  "mssql.query.statisticsIO": false,                       // Display I/O statistics (SET STATISTICS IO ON)
  "mssql.query.xactAbortOn": false,                        // Rollback transaction on error (SET XACT_ABORT ON)
  "mssql.query.transactionIsolationLevel": "READ COMMITTED", // Transaction isolation: "READ COMMITTED" | "READ UNCOMMITTED" | "REPEATABLE READ" | "SERIALIZABLE"
  "mssql.query.deadlockPriority": "Normal",                // Deadlock priority: "Normal" | "Low"
  "mssql.query.lockTimeout": -1,                           // Lock timeout in milliseconds (-1 = wait indefinitely)
  "mssql.query.queryGovernorCostLimit": -1,                // Query governor cost limit (-1 = no limit)
  "mssql.query.ansiDefaults": false,                       // Enable ANSI defaults (SET ANSI_DEFAULTS ON)
  "mssql.query.quotedIdentifier": true,                    // Use quoted identifiers (SET QUOTED_IDENTIFIER ON)
  "mssql.query.ansiNullDefaultOn": true,                   // New columns allow nulls by default (SET ANSI_NULL_DFLT_ON)
  "mssql.query.implicitTransactions": false,               // Enable implicit transactions (SET IMPLICIT_TRANSACTIONS ON)
  "mssql.query.cursorCloseOnCommit": false,                // Close cursors on commit (SET CURSOR_CLOSE_ON_COMMIT ON)
  "mssql.query.ansiPadding": true,                         // ANSI padding for char/varchar (SET ANSI_PADDING ON)
  "mssql.query.ansiWarnings": true,                        // ANSI warnings for aggregates/nulls (SET ANSI_WARNINGS ON)
  "mssql.query.ansiNulls": true,                           // ANSI null comparison behavior (SET ANSI_NULLS ON)
  "mssql.query.alwaysEncryptedParameterization": false     // Enable Always Encrypted parameterization
}

// Query Results & Grid
{
  "mssql.openQueryResultsInTabByDefault": false,           // Open query results in a tab instead of side panel
  "mssql.resultsFontFamily": null,                         // Font family for results grid (null = VS Code default)
  "mssql.resultsFontSize": null,                           // Font size for results grid in pixels (null = VS Code default)
  "mssql.defaultQueryResultsViewMode": "Grid",             // Default results view: "Grid" or "Text"
  "mssql.showBatchTime": false,                            // Show batch execution time in results pane
  "mssql.resultsGrid.autoSizeColumnsMode": "headersAndData", // Auto-size columns: "headersAndData" | "dataOnly" | "headerOnly" | "off"
  "mssql.resultsGrid.inMemoryDataProcessingThreshold": 5000, // Rows threshold for in-memory processing
  "mssql.splitPaneSelection": "next",                      // Focus after split pane: "next" | "current" | "end"
  "mssql.persistQueryResultTabs": false,                   // Keep result tabs open after closing query file
  "mssql.copyIncludeHeaders": false,                       // Include column headers when copying results
  "mssql.copyRemoveNewLine": true,                         // Remove newline characters when copying
  "mssql.saveAsCsv.includeHeaders": true,                  // Include column headers when saving as CSV
  "mssql.saveAsCsv.delimiter": ",",                        // CSV delimiter: "," | "\\t" | ";" | "|"
  "mssql.saveAsCsv.lineSeparator": null,                   // CSV line separator (null = OS default)
  "mssql.saveAsCsv.textIdentifier": "\"",                  // CSV text identifier/quote character
  "mssql.saveAsCsv.encoding": "utf-8",                     // CSV encoding: "utf-8" | "utf-16le" | "ascii" etc.
  "mssql.enableQueryHistoryCapture": true,                 // Automatically capture all executed queries in history
  "mssql.enableQueryHistoryFeature": true,                 // Enable the Query History feature and UI
  "mssql.queryHistoryLimit": 20                            // Maximum number of queries to retain in history
}

// Object Explorer
{
  "mssql.objectExplorer.groupBySchema": false,             // Group database objects by schema (tables, views, etc.)
  "mssql.objectExplorer.collapseConnectionGroupsOnStartup": false,  // Auto-collapse connection groups on extension startup
  "mssql.objectExplorer.expandTimeout": 45                 // Timeout in seconds for expanding object explorer node children
}

// Diagnostics & Logging
{
  "mssql.tracingLevel": "Critical",                        // Logging level: "All" | "Off" | "Critical" | "Error" | "Warning" | "Information" | "Verbose"
  "mssql.logRetentionMinutes": 10080,                      // Log retention period in minutes (10080 = 7 days)
  "mssql.logFilesRemovalLimit": 100                        // Maximum number of log files to keep before cleanup
}

// Shortcuts
{
  "mssql.shortcuts": {
    "event.queryResults.switchToResultsTab": "ctrl+alt+R",
    "event.queryResults.switchToMessagesTab": "ctrl+alt+Y",
    "event.queryResults.switchToQueryPlanTab": "ctrl+alt+E",
    "event.queryResults.prevGrid": "ctrlcmd+up",
    "event.queryResults.nextGrid": "ctrlcmd+down",
    "event.queryResults.switchToTextView": "",
    "event.queryResults.maximizeGrid": "",
    "event.queryResults.saveAsJSON": "",
    "event.queryResults.saveAsCSV": "",
    "event.queryResults.saveAsExcel": "",
    "event.queryResults.saveAsInsert": "",
    "event.resultGrid.copySelection": "ctrlcmd+c",
    "event.resultGrid.copyWithHeaders": "",
    "event.resultGrid.copyAllHeaders": "",
    "event.resultGrid.selectAll": "ctrlcmd+a",
    "event.resultGrid.copyAsCSV": "",
    "event.resultGrid.copyAsJSON": "",
    "event.resultGrid.copyAsInsert": "",
    "event.resultGrid.copyAsInClause": "",
    "event.resultGrid.changeColumnWidth": "alt+shift+s",
    "event.resultGrid.expandSelectionLeft": "shift+left",
    "event.resultGrid.expandSelectionRight": "shift+right",
    "event.resultGrid.expandSelectionUp": "shift+up",
    "event.resultGrid.expandSelectionDown": "shift+down",
    "event.resultGrid.openColumnMenu": "f3",
    "event.resultGrid.openFilterMenu": "",
    "event.resultGrid.moveToRowStart": "ctrlcmd+left",
    "event.resultGrid.moveToRowEnd": "ctrlcmd+right",
    "event.resultGrid.selectColumn": "ctrl+space",
    "event.resultGrid.selectRow": "shift+space",
    "event.resultGrid.toggleSort": "alt+shift+o"
  }
}

Repository Layout

• extensions/ - all of the individual VS Code extensions
• extensions/mssql/ - Primary MSSQL extension that provides connection management, editors, and Copilot integration
• extensions/sql-database-projects/ - SQL Database Projects extension focused on SQL project authoring, build, and publish experiences
• extensions/data-workspace/ - Data Workspace extension providing project workspace management and coordination
• typings/ - Shared .d.ts shims for first-party dependencies (azdata, dataworkspace, mssql, vscode-mssql)

Prerequisites

• Node.js >= 20.19.4
• Yarn >= 1.22
• VS Code >= 1.98.0

All commands below should be executed from the extension's folder unless noted otherwise.

MSSQL Extension (extensions/mssql/)

cd extensions/mssql

# Development
yarn                                # install extension dependencies
yarn watch                          # continuous build (extension + webviews + bundles)
yarn build                          # one-off full build
yarn package [--online|--offline]   # produces VSIX

# Testing
yarn test                           # run unit tests
yarn smoketest                      # run end-to-end tests (requires SQL instance)

SQL Database Projects Extension (extensions/sql-database-projects/)

cd extensions/sql-database-projects

# Development
yarn                      # install extension dependencies
yarn watch                # continuous build (extension + webviews + bundles)
yarn build                # one-off full build
yarn package              # produces VSIX

# Testing
yarn test                 # run unit tests; NOT CURRENTLY WORKING

Data Workspace Extension (extensions/data-workspace/)

cd extensions/data-workspace

# Development
yarn                      # install extension dependencies
yarn watch                # continuous build
yarn build                # one-off full build
yarn package              # produces VSIX

# Testing
yarn test                 # run unit tests

Debugging From The Root Workspace

1. Open the repository root in VS Code.
2. Run yarn watch from any or all extension subfolders
3. Launch a run configuration from VS Code:
   • Run All Extensions

Contributing Tips

• Keep the extensions independent—run yarn install inside each folder instead of the repo root.
• Shared code (e.g., telemetry helpers, typings) should live under typings/ or a new sibling package to avoid implicit cross-imports.
• When editing build or launch configuration, ensure both extensions continue to debug cleanly from the new root-level .vscode/launch.json.
• Before opening a PR, document which extension you changed and how you validated it (commands above or manual scenarios).