ClaudeSuperPower

azuresql-db-from-sql-server

Skill

Migrates a local SQL Server setup to Azure SQL Developer for Azure-faithful local development. Use when a project already uses mcr.microsoft.com/mssql/server, mssql/server, an sqlcmd plus SA password docker setup, a "SQL Server in docker" or "local mssql container", or a docker-compose with the mssq

Install

git clone https://github.com/microsoft/azure-sql-database-container.git ~/.claude/skills/azuresql-db-from-sql-server

What is azuresql-db-from-sql-server?

Migrates a local SQL Server setup to Azure SQL Developer for Azure-faithful local development. Use when a project already uses mcr.microsoft.com/mssql/server, mssql/server, an sqlcmd plus SA password docker setup, a "SQL Server in docker" or "local mssql container", or a docker-compose with the mssql/server image; and use when the user asks for "SQL Server locally", "run mssql in Docker", "spin up a local SQL database", or "test against SQL Server" but actually wants the Azure SQL Database engine (EngineEdition 5). Detects the SQL Server image, rewrites it to Azure SQL Developer, adds --platform on non-x64 hosts, keeps the SA login, flags SQL Server-only features (SQL Agent, FILESTREAM, full Service Broker, cross-server distributed transactions, Windows Auth), and re-points connection strings from master to a provisioned user database.

What this can do

Capabilities declared in this component's own frontmatter — not inferred.

Inherit all session tools

Declares no tool restrictions — inherits every session tool

~212 tokens of context used while enabled, before you invoke anything

Documentation

README · ~6 min read

Migrate from the SQL Server image to Azure SQL Developer

This skill converts an existing local SQL Server setup (the SQL Server image mcr.microsoft.com/mssql/server) into the Azure SQL Database container so local dev matches Azure SQL Database behavior. The two are not the same engine:

SQL Server imageAzure SQL Developer
Imagemcr.microsoft.com/mssql/serversqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest
SERVERPROPERTY('EngineEdition')2/3/4/85
SERVERPROPERTY('Edition')e.g. 'Developer Edition''SQL Azure'
DB modelone instance, many DBs, USE worksmaster for provisioning only; user DB for work; a user-database (SDS) session returns Msg 40508 on USE, exactly as in the cloud; a master connection is a non-SDS provisioning session where the filter is not enforced

Reviews

Log in to leave a review.

No reviews yet — be the first.

Explore related

Other things in this space — across every part of the ecosystem, not just skills.