Configure PostgreSQL databases with EF Core for schema isolation and JSONB metadata.
npx skills add https://github.com/StuartF303/Sorcha --skill postgresql-stuartf303
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/StuartF303/Sorcha/tree/main/.claude/skills/postgresql Command: npx skills add https://github.com/StuartF303/Sorcha --skill postgresql-stuartf303
This Skill helps developers configure and integrate PostgreSQL databases with .NET EF Core in Sorcha, delivering schema isolation, JSONB metadata handling, robust connection strategies, and smooth migrations across services.
Use this skill to configure wallet-db and tenant-db for Sorcha, enabling the wallet schema, JSON metadata, and retry policy; then wire up WalletService with AddNpgsqlDataSource and WithPgAdmin for development.
High-intent search queries and answers about installing and using this skill.
Configure PostgreSQL with EF Core by setting up a DbContext with dedicated schemas and enabling Npgsql integration. This approach isolates wallet and tenant data into separate schemas, improving security and multi-tenancy management while maintaining a single database connection.
Yes. EF Core migrations fully support JSONB metadata columns in PostgreSQL through Npgsql. Define JSONB properties in your DbContext model, and migrations generate the correct column types and indexes automatically.
Enable retry policies in EF Core by configuring connection resilience through Npgsql's retry mechanism and migrations history tracking. This ensures deployments survive transient connection failures across development, staging, and production environments.
Yes. Aspire automatically injects PostgreSQL connection strings into .NET services using service discovery. Wire up services with AddNpgsqlDataSource and PgAdmin for development, eliminating manual connection string configuration.
EF Core with Npgsql supports schema isolation, soft deletes via query filters, optimistic concurrency through row versioning, and JSONB metadata storage. These patterns enable robust multi-tenant and versioned data models.
bmslabsCreate Entity Framework Core entities with properties, validations, and DbContext wiring.
afonsoftAutomate EF Core DbContext configuration and repository patterns for ABP modules.
codewithmukeshConfigures DbContext, optimizes queries, and manages migrations for .NET 10.
Mte90Define Golang database interaction standards with raw SQL and repository patterns.
