Create a shared pgdbm pool with schema-isolated managers and template queries.
npx skills add https://github.com/juanre/pgdbm --skill using-pgdbm
Please help me install this Agent Skill. Skill: using-pgdbm Source: https://github.com/juanre/pgdbm/tree/main/skills/using-pgdbm Command: npx skills add https://github.com/juanre/pgdbm --skill using-pgdbm
This skill clarifies how to design and operate a scalable pgdbm setup using one shared pool and per-service schemas, including template-based queries and per-module migrations.
Instantiate a shared pool with a DatabaseConfig, create AsyncDatabaseManager instances per schema, and run migrations for each module. Then perform queries using the template syntax {{tables.*}}.
High-intent search queries and answers about installing and using this skill.
Schema isolation with a shared pool centralizes connection management while keeping each service's data separate. Create one DatabaseConfig for the pool, then instantiate AsyncDatabaseManager per schema to operate independently while reusing connections.
Per-module migrations let each service update its schema without blocking others. Run migrations for each AsyncDatabaseManager instance separately, all drawing from the same shared pool to minimize resource overhead.
Template-driven queries using {{tables.*}} syntax decouple query logic from schema location. This portability means the same query works whether schemas are deployed locally, in containers, or across microservices.
Yes. One shared pool with per-service schemas provides safe multi-tenancy and microservices isolation. Each module gets its own schema while the pool handles all connection coordination, reducing database load and operational complexity.
No. A single shared pool suffices for multiple schemas when using AsyncDatabaseManager. This design minimizes connection overhead while maintaining schema isolation and safe concurrent access across services.
gazollaConnect Java applications to Supabase PostgreSQL via JDBC with HikariCP pooling.
skinred78Design schemas, write queries, and administer MongoDB and PostgreSQL databases.
LevironexeEnforce Prisma ORM architecture with singleton clients and migration-only schema changes.
tcelestinoAutomate schema-per-tenant Aurora MySQL repository setup with KMS encryption and reusable pools.
