/mssql-docker

Spin up an Microsoft SQL Server DB for local testing

Primary LanguageTSQL

mssql-docker

Spin up an Microsoft SQL Server DB with the Northwinds sample dataset for local testing via Docker Desktop

Requirements: Docker Desktop v4.24+ with both VirtioFS and Rosetta for emulation enabled

  1. Set the tag you want to use in database.Dockerfile

  2. docker compose up -d --build

  3. Create a new mssql resource:

    host: host.docker.internal
port: 1433
username: sa
pw: (see SA_PASSWORD in compose.yml)

  4. Outside of Retool, use a SQL GUI like TablePlus to connect to the database to inspect data/run queries