Loading...
Loading...
Use when adding the local Azure SQL Database container to an existing docker-compose or devcontainer.json: database service, healthcheck, depends_on, app waits for the database, appdb init.
npx skill4agent add microsoft/microsoft-sql azuresql-db-sidecarsqldb,1433localhostappdbdepends_onmcr.microsoft.com/mssql/serverSERVERPROPERTY('EngineEdition')5SERVERPROPERTY('Edition')'SQL Azure'12.0.2000.8sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latestlinux/amd64docker login sqldbpreview-dpgaeqhmgphzd4bk.azurecr.iodocker compose upplatform: linux/amd64ACCEPT_EULA=YMSSQL_SA_PASSWORDCREATE DATABASE appdbDatabase=appdbsqldb-initUSEUSEMsg 40508masterUSEmasterDatabase=appdb-d appdbSQL_CONNECTION_STRINGServer=sqldb,1433;Database=appdb;User Id=sa;Password=<sa-password>;TrustServerCertificate=true<sa-password>MSSQL_SA_PASSWORDUser Id=Password=Database=Uid=Pwd=/docker-entrypoint-initdb.d/*.sqlsqlcmd -d appdb -i seed.sqlappdbcompose.yamlsqldbsqldb-initdepends_onservices:
# ---- existing services stay exactly as they are ----
sqldb:
image: sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest
platform: linux/amd64 # x64-only image; required on a non-x64 host
environment:
ACCEPT_EULA: "Y"
MSSQL_SA_PASSWORD: "${MSSQL_SA_PASSWORD:?Set MSSQL_SA_PASSWORD before running Docker Compose}"
SQLCMDPASSWORD: "${MSSQL_SA_PASSWORD:?Set MSSQL_SA_PASSWORD before running Docker Compose}"
ports:
- "127.0.0.1:1433:1433" # optional; only to reach it from this host
healthcheck:
# -b: a SQL error sets the exit code, so transient startup errors
# (e.g. Msg 913) are retried, not masked. -l 2: short login timeout.
test: ["CMD-SHELL", "/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -C -b -l 2 -Q \"SELECT 1\" || exit 1"]
interval: 5s
timeout: 10s
retries: 30
start_period: 30s
# One-shot: the engine does NOT auto-create databases, so create appdb
# (and seed it) before the app starts. Exits 0 when done.
sqldb-init:
image: sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest
platform: linux/amd64
depends_on:
sqldb:
condition: service_healthy
environment:
SQLCMDPASSWORD: "${MSSQL_SA_PASSWORD:?Set MSSQL_SA_PASSWORD before running Docker Compose}"
# If you have seed.sql, mount it and add: -i /seed/seed.sql on a -d appdb call.
# volumes:
# - ./seed.sql:/seed/seed.sql:ro
entrypoint: ["/bin/bash", "-c"]
command:
- >
/opt/mssql-tools18/bin/sqlcmd -S sqldb -U sa -C -b
-Q "IF DB_ID('appdb') IS NULL CREATE DATABASE appdb;"
restart: "no"
app:
# ---- your existing app service ----
depends_on:
sqldb:
condition: service_healthy
sqldb-init:
condition: service_completed_successfully
environment:
# Host is the SERVICE NAME sqldb, not localhost.
SQL_CONNECTION_STRING: "Server=sqldb,1433;Database=appdb;User Id=sa;Password=${MSSQL_SA_PASSWORD};TrustServerCertificate=true"docker logindocker login sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io # pull-only creds by signing up at https://aka.ms/sqldbcontainerpreview-signup
docker compose pull # refresh the daily-rebuilt :latest (compose reuses a cached image otherwise)
docker compose up -ddocker compose configdepends_onsqlcmd/opt/mssql-tools18/bin/sqlcmdupRunninghealthyvolumessqldb-initappdb command:
- >
/opt/mssql-tools18/bin/sqlcmd -S sqldb -U sa -C -b
-Q "IF DB_ID('appdb') IS NULL CREATE DATABASE appdb;" &&
/opt/mssql-tools18/bin/sqlcmd -S sqldb -U sa -C -b
-d appdb -i /seed/seed.sqlsqldbsqldb-init.devcontainer/devcontainer.json{
"name": "app-with-azuresql",
"dockerComposeFile": "../compose.yaml",
"service": "app", // your dev/app service from compose
"workspaceFolder": "/workspace",
"runServices": ["sqldb", "sqldb-init"],
"remoteEnv": {
"SQL_CONNECTION_STRING": "Server=sqldb,1433;Database=appdb;User Id=sa;Password=${localEnv:MSSQL_SA_PASSWORD};TrustServerCertificate=true"
}
}docker login sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io # pull-only creds by signing up at https://aka.ms/sqldbcontainerpreview-signupsqldb,1433sqldblocalhostsqldbsqlcmd ... -C -b -l 2condition: service_healthysqldb-initappdbcondition: service_completed_successfullysqldbsqldb-initplatform: linux/amd64User Id=Password=Database=TrustServerCertificate=true-Cdepends_onmcr.microsoft.com/mssql/serverlocalhostsqldbappdbsqldb-initUSE appdbMsg 40508Database=appdb-d appdb--platformplatform: linux/amd64/docker-entrypoint-initdb.d/*.sqlmcp__microsoft-learn__microsoft_docs_searchmcp__microsoft-learn__microsoft_docs_fetch