Configure a standalone PostgreSQL module with its own connection pool and migrations.
npx skills add https://github.com/juanre/pgdbm --skill standalone-service
Please help me install this Agent Skill. Skill: standalone-service Source: https://github.com/juanre/pgdbm/tree/main/skills/standalone-service Command: npx skills add https://github.com/juanre/pgdbm --skill standalone-service
Solves the challenge of building modules that own their own PostgreSQL database by providing a complete standalone pattern with its own connection pool and migrations.
High-intent search queries and answers about installing and using this skill.
Set up a standalone PostgreSQL database by installing pgdbm, creating a DatabaseConfig with your connection string, initializing AsyncDatabaseManager, and calling connect(). This gives your service its own isolated connection pool without relying on shared infrastructure.
Yes. Create an AsyncMigrationManager with your migrations_path and a unique module_name, then call apply_pending_migrations() during initialization. Migrations run in isolation for your service's database before queries execute.
Use the standalone pattern with AsyncDatabaseManager to give each background worker its own connection pool and migrations. This approach isolates workers, prevents connection conflicts, and ensures clean lifecycle management with connect() and disconnect().
No. The standalone pattern eliminates shared pools by providing each service, worker, or test environment with its own AsyncDatabaseManager instance, pool, and migrations—simplifying isolation and teardown.
Call disconnect() on your AsyncDatabaseManager during shutdown. This cleanly closes the connection pool for your service's dedicated PostgreSQL database and ensures proper resource cleanup.
The standalone pattern uses standard pgdbm primitives—DatabaseConfig, AsyncDatabaseManager, and AsyncMigrationManager—supporting async queries, connection pooling, and migration execution for any PostgreSQL database owned by your service.
cipherstashInstall and configure CipherStash EQL extensions in PostgreSQL databases.
xukrutdonutExecute SQL queries and manage schemas across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.
ricardorocheEnforce correct async/await patterns in Python functions using asyncio.
juanreShare one PostgreSQL pool across FastAPI services with schema-isolated managers.
