Home

MSSQL extension for Visual Studio Code

Welcome to MSSQL for Visual Studio Code! This extension is designed to help developers seamlessly work with their databases, making it easier to use SQL Server, any Azure SQL service (including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs), and SQL database in Fabric as the backend for their applications. With a rich set of features, MSSQL for Visual Studio Code enhances the development experience, offering functionalities such as:

• Connect to Microsoft SQL Server and Azure SQL Database: Seamlessly connect to your databases to manage and query data. The new Connection Dialog (Preview) offers a more intuitive interface, with options for entering parameters, connection strings, or browsing Azure databases. The Recent Connections panel provides quick access to previously used servers.
• Create and manage connection profiles: Easily manage multiple connection profiles and quickly reconnect using your most recently used connections.
• Enhanced T-SQL Editing Experience: Write T-SQL scripts with a range of powerful features, including:
  • IntelliSense for faster and more accurate coding.
  • Go to Definition for exploring database objects.
  • T-SQL snippets to speed up repetitive tasks.
  • Syntax colorizations and T-SQL error validations.
  • Support for the GO batch separator.
• Execute queries and View Results (Preview): Run your scripts and view results in a simple, yet powerful, grid with improved data visualization features:
  • View results in a unified interface alongside the integrated terminal and output panels or in their own tab.
  • Sort results by clicking on column headers.
  • Easily copy results with or without headers for use in other applications.
  • Export results to multiple formats, including JSON, Excel, and CSV.
  • View estimated plan and actual plan for T-SQL queries.
• Object Explorer (Preview): Navigate through your database objects, such as databases, tables, views, and programmability items. Enhanced filtering allows you to filter database objects by properties like name, owner, or creation date, making it easier to locate specific objects within large database hierarchies.
• Table Designer (Preview): A visual tool for creating and managing tables in your databases. Design every aspect of the table's structure, including:
  • Adding columns, setting data types, and specifying default values.
  • Defining primary keys and managing indexes to improve query performance.
  • Setting up foreign keys to maintain data integrity across tables.
  • Configuring advanced options like check constraints.
  • Script As Create: Automatically generate T-SQL scripts for your table design and apply changes directly to the database.
• Query Plan Visualizer (Preview): Analyze SQL query performance with detailed execution plans. Key features include:
  • Node Navigation: Interact with each step in the execution plan, including collapsing or expanding nodes for a simplified view.
  • Zoom Controls: Zoom in or out to adjust the level of detail, or use "zoom to fit" for a complete view of the plan.
  • Metrics and Highlighting: Highlight key performance indicators, such as elapsed time or subtree cost, to identify bottlenecks in query execution.
• Customizable Extension Options: Configure command shortcuts, appearance, and other settings to personalize your development experience.