microsoft/vscode-mssql

microsoft/vscode-mssql

Description: Visual Studio Code SQL Server extension.

Language: TypeScript

License: NOASSERTION

Stars: 1884

Forks: 590

Open issues: 179

Created: 2016-06-26T04:38:04Z

Pushed: 2026-06-11T03:41:18Z

Default branch: main

Fork: no

Archived: no

README:  

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 | | 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…