Recently, Microsoft released a major update to its MSSQL extension for Visual Studio Code, introducing new features aimed at making easier database development. The update targets developers working with Azure SQL, SQL Database in Fabric (Preview), and SQL Server databases, according to the company’s announcement. This release represents the most significant overhaul of the extension since its initial launch, focusing on improving developer productivity and workflow efficiency.
The centerpiece of this release is a completely redesigned user interface that introduces several productivity-focused tools. Microsoft stated in its developer blog the following:
These updates make connecting to databases, managing objects, and optimizing queries more intuitive than ever.
The company also reports that the changes were driven by extensive user feedback and growing demands for more sophisticated database management tools within the Visual Studio Code environment.
Among the key improvements is a new Connection Dialog system that simplifies database access. The updated interface allows developers to connect to databases through multiple methods, including direct parameter input, connection strings, or Azure resource browsing. The system now maintains a comprehensive history of saved and recent connections, significantly reducing the time required for recurring database access.
(Connection Dialog, Source: Microsoft DevBlog)
Microsoft has also revamped the Object Explorer, adding advanced filtering capabilities that enable developers to locate specific database objects more quickly. The new filtering system works across all levels of the database hierarchy, significantly reducing search time for complex database structures. Users can now filter by various properties including names, owners, and creation dates, with the ability to apply multiple filters simultaneously.
The release introduces a visual Table Designer that transforms how developers create and modify database tables. This tool includes an automatic T-SQL script generation feature, allowing developers to either publish changes directly or execute them manually. The designer incorporates comprehensive tools for managing table structures, including column definitions, key relationships, and constraint management.
Substantial improvements have been made to query analysis capabilities, with the addition of separate result tabs and enhanced visualization tools. The update includes both estimated and actual execution plan features, providing developers with deeper insights into query performance. A new Query Plan Visualizer offers interactive node navigation and customizable metrics tracking for detailed performance analysis.
Microsoft has also enhanced data manipulation features, adding support for multiple export formats including JSON, Excel, and CSV. The new version includes memory-optimized table support and expanded metrics tracking for performance analysis. Advanced features such as system versioning and check constraints have been integrated into the main interface, making them more accessible to developers.
Community feedback on the updated MSSQL extension for Visual Studio Code has been mixed. While many praised its streamlined workflow, some raised concerns about overlap with the Azure Data Studio (ADS) tool. Carlos Robles, Senior Product Manager for Azure SQL, clarified that the extension complements ADS and SQL Server Management Studio, focusing on lightweight tasks like queries and schema adjustments for VS Code users. Developers have welcomed this, though some continue to call for better tool consolidation and stability.
The extension is available immediately through Visual Studio Code’s extension marketplace, with Microsoft providing detailed documentation for users transitioning to the new interface. The company indicates that this update lays the groundwork for future enhancements focused on cloud integration and advanced database management capabilities.
