@clevercx/security-master-prisma

Shared Prisma schema for the CleverCX Security Master PostgreSQL database.

Installation

npm install @clevercx/security-master-prisma prisma @prisma/client

Configuration

Add the following to your package.json:

{
  "prisma": {
    "schema": "node_modules/@clevercx/security-master-prisma/schema.prisma"
  }
}

Generate Prisma Client

npx prisma generate

This generates the Prisma Client locally in your project.

Usage

import { PrismaClient } from '@prisma/client';

// For AWS IAM authentication, generate the URL at runtime
async function getPrismaClient(): Promise<PrismaClient> {
  const url = await getSecurityMasterDatabaseUrl(); // Your AWS IAM auth function

  return new PrismaClient({
    datasources: {
      db: { url }
    }
  });
}

// Query the database
const client = await getPrismaClient();
const securities = await client.security.findMany();

Related Packages

• @clevercx/security-master-types - TypeScript type definitions (for typing only, not querying)
• clevercx-security-master-types (PyPI) - Python dataclasses