GenCodify Studio Publisher Prisma Client

Prisma client library for the GenCodify Studio Publisher service.

Installation

npm install @gencodify-studio/publisher-prisma-client
# or
pnpm add @gencodify-studio/publisher-prisma-client
# or
yarn add @gencodify-studio/publisher-prisma-client

Usage

This package provides the Prisma client and utilities for database operations in the GenCodify Studio Publisher.

Database Configuration

The package supports multiple ways to configure the database connection:

Option 1: Single DATABASE_URL (default)

DATABASE_URL="postgresql://user:password@host:5432/database?schema=public"

Option 2: Individual environment variables

You can use individual environment variables instead of a single connection string:

| Variable | Description | Default | |----------|-------------|---------| | DB_HOST | Database host | - | | DB_PORT | Database port | 5432 | | DB_USER or DB_USERNAME | Database user | - | | DB_PASSWORD | Database password | - | | DB_NAME or DB_DATABASE | Database name | - | | DB_SCHEMA | Database schema | (optional) | | DB_SSL | Enable SSL (true/false) | false |

Example:

DB_HOST=studio-database.gencodify-infra
DB_PORT=5432
DB_USER=postgres
DB_PASSWORD=your-password
DB_NAME=gencodify
DB_SCHEMA=public
DB_SSL=true

Option 3: Programmatic configuration

import { createPrisma } from '@gencodify/publisher-prisma-client';

const prisma = createPrisma({
  datasourceUrl: 'postgresql://user:password@host:5432/database',
  timeout: 5000,
  maxWait: 2000,
});

Debug Mode

Set DEBUG_DB=true to log connection info (password is masked):

DEBUG_DB=true node your-app.js
# Output: [Prisma] Connecting to: postgresql://user:****@host:5432/database

Generating Prisma Client

pnpm generate

Running Migrations

pnpm migrations

Dependencies

• Prisma 5.12.1
• zod for schema validation
• umzug for migration management
• nanoid for ID generation

License

MIT