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