@stratal/zenstack-plugin

ZenStack plugin for Stratal that enables multi-connection database support through schema slicing and connection-specific migrations. It splits a single .zmodel schema into per-connection schemas based on the @@connection attribute.

Plugin Setup

In your .zmodel file:

plugin stratal {
  provider = '@stratal/zenstack-plugin'
  output = './zenstack'
  default = 'main'
}

model User {
  id String @id @default(cuid())
  @@connection('main')
}

model AuditLog {
  id String @id @default(cuid())
  @@connection('analytics')
}

Models without @@connection are assigned to the default connection.

Generated Output

After running npx zenstack generate, the plugin produces:

• slicing.ts — Export map used by DatabaseModule for connection-aware query routing
• Per-connection schemas — Separate Prisma schemas for each connection (used for migrations)

CLI: stratal-db

Common options: --connection <name> to target a specific connection, --all-connections to target all.

Conventions

• Always set a default connection in the plugin config
• Run npx zenstack generate before stratal-db commands to update schemas
• The generated slicing.ts integrates directly with DatabaseModule.forRoot() via the slicing option on each connection
• Cross-connection relations are validated at generation time — models in different connections cannot have direct relations