VOOZH about

URL: https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql

⇱ SQL Server (mssql) - Visual Studio Marketplace


Skip to content
πŸ‘ Image
Sign in
Visual Studio Code>Programming Languages>SQL Server (mssql)New to Visual Studio Code? Get it now.
πŸ‘ SQL Server (mssql)

SQL Server (mssql)

Design and optimize schemas for SQL Server, Azure SQL, and SQL Database in Fabric using a modern, lightweight extension built for developers
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

πŸ‘ 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

Capability Description
Azure SQL database provisioning Create and connect to free tier Azure SQL database

Using the MSSQL Extension

Follow these steps to get started with the MSSQL extension:

  1. Install Visual Studio Code and then install the MSSQL extension from the Extensions view or via the command palette (F1, then type Install Extensions).
  2. Open or create a .sql file. To manually set language mode, press Ctrl+K M and select SQL.
  3. Press F1, type MS SQL: Manage Connection Profile, and follow the prompts to create a profile. See manage connection profiles for advanced options.
  4. Connect to a database using F1 > MS SQL: Connect or the shortcut Ctrl+Shift+C.
  5. Write your T-SQL script using IntelliSense and snippets. Type sql to explore available snippets.
  6. 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
  1. 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.