Vibe Index
🎯

postgresql

🎯Skill

from stuartf303/sorcha

VibeIndex|
What it does

Configures and manages PostgreSQL databases with Entity Framework Core, enabling schema-based isolation, JSONB metadata, and .NET Aspire service discovery for robust database integration.

πŸ“¦

Part of

stuartf303/sorcha(22 items)

postgresql

Installation

git cloneClone repository
git clone https://github.com/StuartF303/Sorcha.git
πŸ“– Extracted from docs: stuartf303/sorcha
Need more details? View full documentation on GitHub β†’
2Installs
-
AddedFeb 4, 2026
View on GitHubBack to Skills

Skill Details

SKILL.md

|

Overview

# PostgreSQL Skill

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.

Quick Start

DbContext with PostgreSQL Schema

```csharp

// src/Common/Sorcha.Wallet.Core/Data/WalletDbContext.cs

public class WalletDbContext : DbContext

{

protected override void OnModelCreating(ModelBuilder modelBuilder)

{

modelBuilder.HasDefaultSchema("wallet");

modelBuilder.Entity(entity =>

{

entity.ToTable("wallets");

entity.HasKey(e => e.Address);

// JSONB for metadata

entity.Property(e => e.Metadata)

.HasColumnType("jsonb");

// Soft delete filter

entity.HasQueryFilter(e => e.DeletedAt == null);

});

}

}

```

Npgsql Configuration with Retry

```csharp

// src/Services/Sorcha.Wallet.Service/Extensions/WalletServiceExtensions.cs

services.AddNpgsqlDataSource(connectionString, dataSourceBuilder =>

{

dataSourceBuilder.EnableDynamicJson(); // Required for Dictionary serialization

});

services.AddDbContext(options =>

{

options.UseNpgsql(connectionString, npgsqlOptions =>

{

npgsqlOptions.EnableRetryOnFailure(

maxRetryCount: 10,

maxRetryDelay: TimeSpan.FromSeconds(30),

errorCodesToAdd: null);

npgsqlOptions.MigrationsHistoryTable("__EFMigrationsHistory", "wallet");

});

});

```

Aspire Service Discovery

```csharp

// src/Apps/Sorcha.AppHost/AppHost.cs

var postgres = builder.AddPostgres("postgres").WithPgAdmin();

var walletDb = postgres.AddDatabase("wallet-db", "sorcha_wallet");

builder.AddProject("wallet-service")

.WithReference(walletDb); // Auto-injects connection string

```

Key Concepts

| Concept | Usage | Example |

|---------|-------|---------|

| 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("gen_random_uuid()") |

Common Patterns

High-Precision Decimal for Crypto

When: Storing cryptocurrency amounts

```csharp

entity.Property(e => e.Balance)

.HasColumnType("numeric(28,18)")

.HasPrecision(28, 18);

```

Timestamp with Timezone

When: Audit trails with timezone awareness

```csharp

entity.Property(e => e.CreatedAt)

.HasColumnType("timestamp with time zone")

.HasDefaultValueSql("CURRENT_TIMESTAMP");

```

See Also

  • [patterns](references/patterns.md) - DbContext configuration, indexing strategies
  • [workflows](references/workflows.md) - Migrations, health checks, initialization

Related Skills

  • entity-framework - ORM patterns and repository implementations
  • aspire - Service discovery and connection string injection
  • docker - PostgreSQL container configuration

Documentation Resources

> Fetch latest PostgreSQL documentation with Context7.

How to use Context7:

  1. Use mcp__context7__resolve-library-id to search for "postgresql" or "npgsql efcore"
  2. Prefer website documentation (IDs starting with /websites/) over source code repositories
  3. Query with mcp__context7__query-docs using the resolved library ID

Library IDs:

  • PostgreSQL: /websites/postgresql (61K snippets, High reputation)
  • Npgsql EF Core: /websites/npgsql_efcore_index_html
  • EF Core: /dotnet/entityframework.docs (4K snippets, High reputation)

Recommended Queries:

  • "Index creation strategies"
  • "JSONB operators and functions"
  • "Connection pooling configuration"
  • "Query performance optimization"

More from this repository10

🎯
xunit🎯Skill

xunit skill from stuartf303/sorcha

🎯
frontend-design🎯Skill

Styles Blazor WASM components using MudBlazor Material Design, implementing responsive layouts with CSS isolation and custom design patterns.

🎯
dotnet🎯Skill

Configures .NET 10 projects with C# 13 features, service defaults, dependency injection, and modern development patterns.

🎯
cryptography🎯Skill

Generates cryptographic keys, signs/verifies data, and manages HD wallets using multi-algorithm support across ED25519, P-256, and RSA-4096.

🎯
docker🎯Skill

Manages Docker containerization and docker-compose orchestration for building, running, and configuring multi-service container environments.

🎯
minimal-apis🎯Skill

minimal-apis skill from stuartf303/sorcha

🎯
yarp🎯Skill

yarp skill from stuartf303/sorcha

🎯
nbitcoin🎯Skill

nbitcoin skill from stuartf303/sorcha

🎯
redis🎯Skill

Implements Redis caching, session management, and distributed coordination for Sorcha, enabling efficient token tracking, rate limiting, and shared state across services.

🎯
entity-framework🎯Skill

entity-framework skill from stuartf303/sorcha