Database
Learn how to work with the database in your MakerKit application.
MVS Telecom uses PostgreSQL (Neon in production) with Prisma as the ORM.
Tenant isolation is enforced at the application layer, not in the database: there is no Postgres Row Level Security. Queries are org-scoped in application code through the Organization and Member models (with a handful of org-direct models such as Customer, ApiKey, RoutingPolicy, MrrSnapshot, and OpsDigest carrying organizationId directly).
This section covers:
- Database schema and structure
- Running migrations
- Querying data
- Functions and triggers
For the authoritative, current schema, see docs/system/data-model.md.