SQL Server on Docker (Prisma ORM v6) (/docs/orm/v6/overview/databases/sql-server/sql-server-docker)

For the complete Prisma documentation index, see llms.txt. A markdown version of any docs page is available by appending .md to its URL.

Download and use the Microsoft SQL Server Docker image.

Location: ORM > v6 > Core Concepts > Supported databases > SQL Server > SQL Server on Docker

[!NOTE] Quick summary

This guide provides a quick overview on setting up and running Microsoft SQL Server in a Docker container, including pulling the image, starting the server, connecting, and creating a test database.

[!WARNING] Prisma 7.0.0 has updated minimum Node.js requirements:

• Node.js 20: >= 20.19.0
• Node.js 22: >= 22.12.0
• Node.js 24: >= 24.0.0+

If you're using Prisma 7.0.0 or higher with Docker, ensure your application's Docker base image uses Node.js 22 or 24. Update your Dockerfile to use node:22-alpine or node:24-alpine instead of older Node.js 20 images.

To run a Microsoft SQL Server container image with Docker:

1. Install and set up Docker

2. Run the following command in your terminal to download the Microsoft SQL Server 2019 image:

   docker pull mcr.microsoft.com/mssql/server:2019-latest

3. Create an instance of the container image, replacing the value of SA_PASSWORD with a password of your choice:

   docker run --name sql_container -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=myPassword' -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest

4. Follow Microsoft's instructions to connect to SQL Server and use the sqlcmd tool, replacing the image name and password with your own.

5. From the sqlcmd command prompt, create a new database:

   CREATE DATABASE quickstart
   GO

6. Run the following command to check that your database was created successfully:

   sp_databases
   GO

Based on this example, your credentials are:

• Username: sa
• Password: myPassword
• Database: quickstart
• Port: 1433

• SQL Server on Windows (local): Set up and configure SQL Server on Windows.