microsoft/microsoft-sql-vscode

v1.0.0

Build and manage Azure SQL Database applications in Visual Studio Code with the MSSQL extension, including connections, schema and ORM workflows, deployment, diagnostics, security, data movement, recovery, T-SQL, vector search, and database projects. Data API Builder guidance is excluded where it would duplicate tools provided by the extension.

GitHub

skills

connect-to-azure-sql

Connects an application to Azure SQL Database: picks the Microsoft driver for the language, sets encryption and certificate validation, sizes the pool against the worker limit not the session limit, and makes retry part of the first version of the code. Use when a user asks "how do I connect to Azure SQL", "which driver should I use", "what goes in the connection string", "add retry logic", "the connection keeps dropping", "should I set TrustServerCertificate", or "my app times out connecting to Azure". Also use when a first connection to a free or serverless database fails with error 40613, documented resume behaviour, not an outage. Azure SQL Database only, not Azure SQL Managed Instance and not self-managed SQL Server. Driver installation, connection strings and pooling per language belong to connect-from-dotnet, connect-from-python and connect-from-typescript-and-node.

Read SKILL.md at the source

Pinned to revision eeb1c6867c2d, so it is the text this page describes rather than whatever the author pushed since.

Files

skills/connect-to-azure-sql/SKILL.md

Every link opens the file at its source, pinned to the revision this page describes.