1. Install Node.js (version 22 or later)

   • Alternatively, you can use Bun or Deno

2. Install dbc

3. Install Docker

1. Start SQL Server in a Docker container:

   docker run \
      -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Co1umn&r" \
      -p 1433:1433 --name mssql --hostname mssql \
      -d \
      mcr.microsoft.com/mssql/server:2025-latest

2. Create a table in SQL Server and load data into it:

   docker cp games.sql mssql:/tmp/games.sql
   
   docker exec -it mssql /opt/mssql-tools18/bin/sqlcmd \
     -S localhost -U sa -P 'Co1umn&r' -C -i /tmp/games.sql

1. Install the SQL Server ADBC driver:

   dbc install mssql

2. Install dependencies:

   npm --prefix .. install

3. Customize the script main.js as needed

   • Change the connection arguments in databaseOptions
     • Change uri as needed, using query parameters to add more connection arguments, or keep it as is to use the data included with this example
   • If you changed which database you're connecting to, also change the SQL SELECT statement in conn.query()

sqlserver://my-database-endpoint.database.windows.net:1433?database=my-database-name&fedauth=ActiveDirectoryDefault

1. Run the script:

   Node.js:

   node main.js

   Bun:

   bun run main.js

   Deno:

   deno run --allow-ffi --allow-env main.js

Stop the Docker container running SQL Server:

docker stop mssql
docker rm mssql