Database in NestJS

Overview

This page contains 6 code snippets for implementing Database in NestJS. Each snippet is production-ready and can be copy-pasted directly into your project.

Available Snippets

Prisma Service

Prisma client as injectable NestJS service

npx hanma add prisma-service --framework nest

Module lifecycle integration
Health check method
Transaction helper with retry

Drizzle Service

Drizzle ORM service with PostgreSQL

npx hanma add drizzle-service --framework nest

PostgreSQL connection pool
Transaction helper
Raw SQL execution

Parse UUID Pipe

UUID parsing and validation

npx hanma add parse-uuid-pipe --framework nest

UUID version validation
Optional handling
Lower case normalization

Prisma Exception Filter

Prisma database error handling

npx hanma add prisma-exception-filter --framework nest

Unique constraint errors
Not found errors
Foreign key errors

Health Indicators

Health check services

npx hanma add health-provider --framework nest

Database health
Redis health
Memory usage

Pagination Helpers

Offset and cursor pagination

npx hanma add pagination --framework nest

Offset pagination DTO
Cursor pagination DTO
Prisma helpers

Frequently Asked Questions

How do I implement Database in NestJS?

Browse the snippets above and copy the code that matches your needs. Each snippet includes installation instructions and usage examples.

Are these snippets production-ready?

Yes, all snippets are designed for production use. However, always review and test them in your specific context before deployment.

Can I use these snippets with other NestJS versions?

These snippets are designed for the current major version of the framework. Check the snippet documentation for version compatibility notes.