MSSQL Storage

The @stepflowjs/storage-mssql adapter provides an enterprise-grade storage backend using Microsoft SQL Server. It uses sp_getapplock for distributed locking and MERGE statements for atomic updates.

Installation

pnpm add @stepflowjs/storage-mssql

Usage

import { Stepflow } from "@stepflowjs/core";
import { MssqlStorageAdapter } from "@stepflowjs/storage-mssql";

const stepflow = new Stepflow({
  storage: new MssqlStorageAdapter({
    server: "localhost",
    database: "StepflowDB",
    user: "sa",
    password: "YourStrongPassword",
    options: {
      encrypt: true,
      trustServerCertificate: true,
    },
  }),
});

Configuration Options

Features

• Enterprise Ready: Full support for Microsoft SQL Server features.
• Distributed Locking: Uses sp_getapplock for reliable leader election.
• Atomic Updates: Uses MERGE statements to handle upserts and state transitions atomically.
• Automatic Migrations: Automatically creates schemas, tables, and indexes on startup.

Environment Variables

MSSQL_SERVER=localhost
MSSQL_DATABASE=StepflowDB
MSSQL_USER=sa
MSSQL_PASSWORD=YourStrongPassword