Add database connection timeout configuration to Prisma client setup

[Cjay-Cyber-2]

Description

Explicitly configure connection timeouts and logging options on the Prisma client instance to improve debugging and prevent hanging database connections under load.

Context & Requirements

The Prisma client is initialized across backend services. Adding explicit connection options and query error logging enhances operational visibility when Horizon or database connectivity experiences transient latency.

Acceptance Criteria

• Update Prisma client instantiation (likely in a dedicated db/prisma module under src/services/ or src/lib/).
• Configure explicit connection timeout parameters.
• Ensure log levels match Pino logger configuration.

Implementation Guidance

• Likely files to touch: Prisma client initialization file.
• Follow existing patterns for environment variable usage (e.g. process.env.DATABASE_URL).

Testing & Validation

• Run npm run prisma:generate and npm test to verify database client initialization and test execution.

Submission Guidelines

• Open a Pull Request referencing Closes #<issue-number>.
• Adhere to TypeScript strict rules and existing codebase formatting standards.

---

Wave complexity: Trivial

[shychips]

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

could you assign this to me?

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

[Michael-Olagoke]

@Michael-Olagoke has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi maintainer, I've carefully read what the prerequisite for this task should be. I have vast and robust experience in project management as you can confirm from my GitHub profile. I am experienced in all the languages required for this task.

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

[joydeelish]

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

Gm

Please Can i work on this issue

i would love to be a contributor to this great project

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

[dotunv]

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

Hey maintainer. I will love to contribute to this issue

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

[drips-wave]

Congratulations, @dotunv! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on August 31, 2026.

🧑‍💻 @dotunv: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊