Labsco
prisma logo

prisma-database-setup-sqlserver

✓ Official★ 8

by prisma · part of prisma/cursor-plugin

SQL Server Setup. Reference when using this Prisma feature.

🔥🔥🔥✓ VerifiedFreeAdvanced setup
#database#cloud#git
🧩 One of 7 skills in the prisma/cursor-plugin package — works on its own, and pairs well with its siblings.

SQL Server Setup. Reference when using this Prisma feature.

Inspect the full instructions your agent will receiveExpand

This is the exact playbook injected into your agent when the skill activates — shown here so you can audit it before installing. You don't need to read it to use the skill.

by prisma

SQL Server Setup. Reference when using this Prisma feature. npx skills add https://github.com/prisma/cursor-plugin --skill prisma-database-setup-sqlserver Download ZIPGitHub8

3. Environment Variable

In .env:

Copy & paste — that's it
DATABASE_URL="sqlserver://localhost:1433;database=mydb;user=sa;password=Password123;encrypt=true;trustServerCertificate=true"

Connection String Format

Copy & paste — that's it
sqlserver://HOST:PORT;database=DB;user=USER;password=PASS;encrypt=true;trustServerCertificate=true

  • encrypt: Required for Azure (true).

  • trustServerCertificate: True for self-signed certs (local dev).

Driver Adapter (Prisma ORM 7 required)

Prisma ORM 7 uses the query compiler by default, so you must use a driver adapter.

Install adapter and driver:

Copy & paste — that's it
npm install @prisma/adapter-mssql mssql

Instantiate Prisma Client with the adapter:

Copy & paste — that's it
import 'dotenv/config'
import { PrismaClient } from '../generated/client'
import { PrismaMssql } from '@prisma/adapter-mssql'

const adapter = new PrismaMssql({
 server: 'localhost',
 port: 1433,
 database: 'mydb',
 user: process.env.SQLSERVER_USER,
 password: process.env.SQLSERVER_PASSWORD,
 options: {
 encrypt: true,
 trustServerCertificate: true,
 },
})

const prisma = new PrismaClient({ adapter })