Auth & Orgs: Basic platform authentication & org model

[cuevaio]

Description

Implement authentication and organization model using Prisma + Neon Postgres.

Data Models

• Users
• Organizations
• Organization membership (users <-> orgs)
• Projects (within organizations)
• API Keys (linked to projects and orgs)

Tasks

• Design and create Prisma schema for all models
• Set up Neon Postgres connection
• Integrate BetterAuth for authentication
• Implement signup flow with default org creation (or prompt)
• Create organization invitation/membership system
• Link API keys to projects and organizations
• Implement proper authorization checks

Acceptance Criteria

• Users can sign up and are placed in an organization
• Organizations can have multiple members
• Projects belong to organizations
• API keys are properly scoped to projects/orgs
• All endpoints have proper authorization