Add database connection health check indicator

[MissBlue00]

Task

Implement the database health indicator with actual Prisma query.

Details

• In apps/api/src/health/indicators/database.health.ts
• Inject PrismaService
• Execute SELECT 1 via prisma.$queryRaw
• Return healthy only when query succeeds
• Log query errors for debugging

Path

• apps/api/src/health/indicators/database.health.ts

Test

Run pnpm --filter api build to verify.

[kingzedox]

@kingzedox has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

hey stellar pay maintainers, I can work on this issue and deliver fast. please assign

ℹ️ Repo Maintainers: To accept this application, review their application or assign @kingzedox to this issue.

[deep-bhikadiya]

@deep-bhikadiya has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hello, this looks like something I can help with. I'd appreciate being assigned to it.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @deep-bhikadiya to this issue.

[0darkside0rbit-star]

@0darkside0rbit-star has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

I would like to work on this issue please

ℹ️ Repo Maintainers: To accept this application, review their application or assign @0darkside0rbit-star to this issue.