π Roadmap 2026
π Report Bug
π Request Feature
π GitHub Discussions
π Build and Test (Unit + E2E)
π codecov
MSSQL extension for Visual Studio Code
The MSSQL Extension for Visual Studio Code is designed to empower developers by providing a seamless and modern database development experience. Our goal is to make SQL development more productive and intuitive by integrating essential features such as schema management, query execution, and AI-powered assistance.
Explore and Learn
π MSSQL Extension Demo Playlist
Features
The MSSQL extension provides a rich set of capabilities for SQL development. Each capability links to its detailed documentation on Microsoft Learn.
General Availability
| Capability |
Description |
| Connection Dialog |
Connect using parameters, connection strings, or Azure/Fabric browse. Organize connections with color-coded groups |
| Object Explorer |
Browse and filter database objects with type-aware search |
| Database Object Search |
Search for tables, views, stored procedures, and other objects across a database |
| Fabric integration |
Browse Fabric workspaces and provision SQL databases |
| Query Results |
View, sort, copy, and export query results |
| Query Plan Visualizer |
Analyze execution plans with interactive node navigation |
| Query Profiler |
Real-time database activity monitoring with Extended Events |
| Table Designer |
Create and manage tables with a visual interface |
| Schema Designer |
Visual schema modeling with drag-and-drop, auto-layout, and T-SQL script generation |
| GitHub Copilot in Schema Designer |
Natural language schema design within the visual Schema Designer |
| Schema Compare |
Compare and synchronize schemas between databases or DACPACs |
| GitHub Copilot integration |
AI-assisted SQL development with natural language chat and agent mode |
| Local SQL Server containers |
Create and manage SQL Server containers locally |
| View & Edit Data |
Browse and modify table data inline without writing T-SQL |
| Database Operations |
Rename, back up, restore, import data from flat files, and drop databases from Object Explorer |
| Data-tier Application (DACPAC and BACPAC) |
Deploy, extract, import, and export DACPAC and BACPAC files |
| Fabric integration |
Browse Fabric workspaces and provision SQL databases |
| SQL Database Projects |
Build, publish with the visual Publish Dialog, and analyze SQL projects with Code Analysis |
| Query Profiler |
Real-time database activity monitoring with Extended Events |
| Backup and Restore |
Back up and restore SQL Server databases |
| Flat File Import |
Import flat files (CSV, TXT) as new database tables using a guided wizard |
| Object Search |
Search for database objects by name across a server or database |
| Database Management |
Create, rename, and drop databases |
| SQL Notebooks |
Jupyter-based SQL notebooks with rich results and multi-kernel support |
| Data API builder |
Create REST, GraphQL, and MCP endpoints for SQL databases |
| GitHub Copilot in Data API builder |
Generate Data API builder configs using natural language |
Public Preview
Using the MSSQL Extension
Follow these steps to get started with the MSSQL extension:
- Install Visual Studio Code and then install the MSSQL extension from the Extensions view or via the command palette (
F1, then type Install Extensions).
- Open or create a
.sql file. To manually set language mode, press Ctrl+K M and select SQL.
- Press
F1, type MS SQL: Manage Connection Profile, and follow the prompts to create a profile. See manage connection profiles for advanced options.
- Connect to a database using
F1 > MS SQL: Connect or the shortcut Ctrl+Shift+C.
- Write your T-SQL script using IntelliSense and snippets. Type
sql to explore available snippets.
- Run queries by selecting MS SQL: Execute Query from the Command Palette (
F1), or use the shortcut:
- Windows/Linux:
Ctrl+Shift+E
- macOS:
Cmd+Shift+E
- Customize shortcuts via the command palette or in your
settings.json. See customize shortcuts for help.
Resources
Command Palette Commands
Press F1 and type MS SQL to see all available commands. Here are the most commonly used:
Extension Settings
Configure the MSSQL extension in user preferences (Cmd+,) or workspace settings (.vscode/settings.json). For the complete reference with descriptions for all settings, see Customize Options on the wiki.
Keyboard Shortcuts
Customize keyboard shortcuts for query results, grid operations, and other actions. For the complete reference, see Customize Shortcuts on the wiki.
Coming from SSMS or Azure Data Studio? Install the Database Management Keymap companion extension to use familiar keyboard shortcuts like F5 (execute query) and Ctrl+Shift+R (toggle query result panel) in VS Code.
For full details on all extension settings and keyboard shortcuts, see the wiki:
Supported Operating Systems
- Windows 11 (x64, arm64)
- macOS (Intel & Apple Silicon)
- Linux (x64, arm64) β including Ubuntu, Debian, RHEL, Fedora, and other major distributions
Offline Installation
The extension will download and install a required SqlToolsService package during activation. For machines with no Internet access, you can still use the extension by choosing the Install from VSIX... option in the extension view and installing a bundled release from our Releases page.
Each operating system has a .vsix file with the required service included. Pick the file for your OS, download and install to get started. We recommend you choose a full release and ignore any alpha or beta releases as these are our daily builds used in testing.
Change Log
View the change log in the extension via the MS SQL: Show Change Log command, or browse the full change log on GitHub. The change log is also shown automatically on first install and after updates.
Support
Support for this extension is provided via GitHub issues. You can submit a bug report, a feature suggestion or participate in discussions.
Development & Contributing
This is a multi-extension monorepo. See the developer documentation for details on how to contribute.
Code of Conduct
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.
Telemetry
This extension collects telemetry data, which is used to help understand how to improve the product. For example, this usage data helps to debug issues, such as slow start-up times, and to prioritize new features. While we appreciate the insights this data provides, we also know that not everyone wants to send usage data and you can disable telemetry as described in the VS Code disable telemetry reporting documentation.
Administrators can set or disable feedback and telemetry collection across their entire organization/tenant with the same mechanism. Learn more about setting feedback and telemetry collection policy and centrally managing VS Code settings with policies.
Privacy Statement
The Microsoft Enterprise and Developer Privacy Statement describes the privacy statement of this software.
License
This extension is licensed under the MIT License. Please see the third-party notices file for additional copyright notices and license terms applicable to portions of the software.