Presented by Microsoft Developer, this Data Exposed episode explores advancing SQL development in VS Code using the updated MSSQL extension, GitHub Copilot (at GA), Python, and vector data types to accelerate building AI-powered applications.

Next-Level SQL in VS Code: GitHub Copilot GA and AI-Ready SQL

The latest update to the MSSQL extension for Visual Studio Code brings a range of features designed to streamline SQL development and help build AI-powered applications efficiently.

Key Highlights

• GitHub Copilot General Availability: Now fully GA, GitHub Copilot assists in writing SQL code directly in VS Code, including both Ask and Agent modes that enhance contextual understanding of your database workflow—even without an active database connection.
• In-Product Changelog and Edit Data Enhancements: Developers can now access update logs and improved data editing experiences directly within the extension, making feature tracking and iterative development smoother.
• Schema Evolution for AI-Readiness:
  • Demonstrates evolving a traditional SQL schema into an AI-ready schema using vector data types available in SQL Server 2025.
  • Integrates GitHub Copilot, Python, and semantic search to enable more intelligent data operations and search capabilities.

Demo Walkthrough

1. GitHub Copilot in Action: See how Copilot (Ask and Agent modes) improves productivity by understanding schema, suggesting next steps, and helping with workflow guidance.
2. AI-Ready Schema Implementation:
   • Transition SQL schemas for vector support.
   • Leverage semantic search within the SQL database by combining Python scripting and Copilot-powered workflows.

Resources

• Install MSSQL Extension
• VS Code MSSQL Demos
• MSSQL Extension Blogs
• MSSQL Documentation

Connect with the Hosts

• Anna Hoffman on Twitter
• Carlos Robles on LinkedIn
• Carlos Robles on Twitter
• Azure SQL on Twitter

More Learning

• Data Exposed on YouTube
• Microsoft Azure SQL Channel
• Microsoft SQL Server Channel
• Microsoft Developer Channel

By combining modern AI tooling and advanced SQL features in VS Code, developers can boost workflow efficiency, evolve their database schemas for intelligent use cases, and accelerate application innovation.