postgresql
✓Manages PostgreSQL databases and Entity Framework Core integration. Use when: configuring database connections, writing migrations, creating DbContext classes, optimizing queries, or integrating with .NET Aspire.
Installation
SKILL.md
PostgreSQL database management for Sorcha's distributed ledger platform. This project uses PostgreSQL 17 with Npgsql 8.0+ and Entity Framework Core 10, featuring dedicated schemas (wallet, public), JSONB columns for metadata, and .NET Aspire service discovery for connection management.
| Schema isolation | Separate domains | modelBuilder.HasDefaultSchema("wallet") | | JSONB columns | Flexible metadata | HasColumnType("jsonb") | | Soft deletes | Query filters | HasQueryFilter(e => e.DeletedAt == null) | | Row versioning | Concurrency | Property(e => e.RowVersion).IsRowVersion() |
| Composite indexes | Query performance | HasIndex(e => new { e.Owner, e.Tenant }) | | UUID generation | Primary keys | HasDefaultValueSql("genrandomuuid()") |
Manages PostgreSQL databases and Entity Framework Core integration. Use when: configuring database connections, writing migrations, creating DbContext classes, optimizing queries, or integrating with .NET Aspire. Source: stuartf303/sorcha.
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/stuartf303/sorcha --skill postgresql- Source
- stuartf303/sorcha
- Category
- </>Dev Tools
- Verified
- ✓
- First Seen
- 2026-02-01
- Updated
- 2026-02-18
Quick answers
What is postgresql?
Manages PostgreSQL databases and Entity Framework Core integration. Use when: configuring database connections, writing migrations, creating DbContext classes, optimizing queries, or integrating with .NET Aspire. Source: stuartf303/sorcha.
How do I install postgresql?
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/stuartf303/sorcha --skill postgresql Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code or Cursor
Where is the source repository?
https://github.com/stuartf303/sorcha
Details
- Category
- </>Dev Tools
- Source
- skills.sh
- First Seen
- 2026-02-01