backend-prisma

Prisma generates TypeScript types directly from your database schema defined in the schema.prisma file. Run `prisma generate` to create fully typed client code that syncs with PostgreSQL, MySQL, SQLite, or MongoDB, eliminating manual type definitions and keeping types in sync as your schema evolves.

Prisma supports PostgreSQL, MySQL, SQLite, and MongoDB through a single unified client and schema syntax. You configure your database connection in the .env file and schema.prisma, then use identical CRUD patterns and migrations across any supported database without changing application code.

Prisma manages migrations declaratively through your schema.prisma file. Define schema changes once, then run `prisma migrate dev` to automatically generate and execute migration files. Prisma tracks migration history and handles rollbacks, keeping your database and schema definition synchronized across environments.

Prisma's `include()` and `select()` methods let you fetch related records and choose specific fields in a single type-safe query. Combine with pagination using `skip()` and `take()` to control result sets, and use transactions for multi-step operations that must succeed or fail together.

Prisma's generated client covers standard CRUD, relations, filtering, and transactions without raw SQL. For complex queries beyond the ORM, use `prisma.$queryRaw()` or `prisma.$executeRaw()` for type-safe parameterized SQL when needed, maintaining protection against injection attacks.

Prisma's generated types and singleton client pattern integrate directly with tRPC and other TypeScript frameworks. Define procedures that use the Prisma client for database access, leveraging full type inference from schema to API layer without manual type bridges.