microsoft / vscode-mssql

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 • 🎬 Watch the demos: Explore key features through our YouTube playlist • 🤖 Watch the GitHub Copilot demos: Learn how to use GitHub Copilot to write, explain, and refactor your database schema • 📝 Read the blog posts: Learn from use cases, walkthroughs, and product updates • 📖 Read the documentation: Get started or go deep with our official docs • 🗺️ Check out the roadmap: See what's coming next, including upcoming features and improvements 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 | | Query Results | View, sort, copy, and export query results | | Query Plan Visualizer | Analyze execution plans with interactive node navigation | | 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 | | 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 | | Data-tier Application (DACPAC) | 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 | Public Preview | Capability | Description | | ---------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------- | | Schema Designer with GitHub Copilot | Natural language schema design within the visual Schema Designer | | 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 | | SQL Notebooks | Jupyter-based SQL notebooks with rich results and multi-kernel support | | Query Profiler | Real-time database activity monitoring with Extended Events | 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 ( , then type ). • Open or create a file. To manually set language mode, press and select **SQL**. • Press , type , and follow the prompts to create a profile. See manage connection profiles for advanced options. • Connect to a database using > or the shortcut . • Write your T-SQL script using IntelliSense and snippets. Type to explore available snippets. • Run queries by selecting **MS SQL: Execute Query** from the Command Palette ( ), or use the shortcut: • **Windows/Linux**: • **macOS**: • Customize shortcuts via the command palette or in your . See customize shortcuts for help. Resources • Get started with the MSSQL extension: Step-by-step tutorial to connect and query your first database • SQL Developer tutorial: Build full-stack apps using SQL Server with C#, Java, Node.js, Python, and more • Local development with Azure SQL: Learn how to develop locally with Azure SQL Database • Dev Containers for Azure SQL: Set up repeatable dev environments using Dev Containers • Join the Discussion: Ask questions, suggest features, and engage with the community Command Palette Commands Press and type to see all available commands. Here are the most commonly used: View common commands **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 **C…