Quantix DB

Unified database schemas and migrations for Quantix Labs.

Stack

• Drizzle ORM - Type-safe SQL toolkit
• Neon PostgreSQL - Serverless Postgres

Structure

quantix-db/
├── schema/
│   ├── core/           # Always active
│   │   ├── clients.ts
│   │   ├── licenses.ts
│   │   ├── users.ts
│   │   └── settings.ts
│   ├── modules/        # Activated per license
│   │   ├── crm.ts
│   │   ├── invoicing.ts
│   │   ├── accounting.ts
│   │   ├── automotive.ts
│   │   ├── construction.ts
│   │   └── ...
│   ├── engine/         # Engine operations
│   │   ├── builds.ts
│   │   ├── deployments.ts
│   │   └── templates.ts
│   └── index.ts        # Export all schemas
├── migrations/         # Drizzle migrations
├── seeds/              # Seed data
└── drizzle.config.ts

Usage

This package is imported by quantix-api:

import { clients, licenses, users } from '@quantix/db';

Commands

pnpm generate   # Generate migrations from schema changes
pnpm migrate    # Run pending migrations
pnpm push       # Push schema directly (dev only)
pnpm studio     # Open Drizzle Studio

Quantix Labs - Database Layer