Databases Agent Skills

Event Sourcing knowledge base. Provides patterns, antipatterns, and PHP-specific guidelines for Event Sourcing architecture audits.

Migrate to event-sourcing architecture with event extraction, store setup, and CQRS implementation

Event sourcing patterns for storing state as a sequence of events.

Enforces event sourcing patterns in hzl - all state mutations must go through EventStore.append(), projections are read-only derived state

Design and implement event stores for event-sourced systems.

Use when optimizing application performance — caching strategies, eager loading, query optimization, Redis patterns, or background job…

Deep expertise in Microsoft Fabric Data Factory — build data pipelines with Copy, Dataflow Gen2, Notebook, and orchestration activities…

Microsoft Fabric data store operations - Cosmos DB database, SQL database, Snowflake database links, datamarts, and Event Schema Set…

Advanced Fabric Mirroring guidance for source onboarding, CDC replication reliability, latency monitoring, schema drift management, and…

Automatically manages PostgreSQL backups with pgBackRest and Wasabi S3 storage when working with FairDB databases

Postgres best practices maintained by Supabase, for Postgres running anywhere.

Fetch recent `journals` rows directly from PostgreSQL and return a JSON array containing `doi`, `title`, `abstract`, and `date` (filtered…

Benchmark and performance-test Django ORM filters on large datasets.

Firebase gives you a complete backend in minutes - auth, database,

Build with Firestore NoSQL database - real-time sync, offline support, and scalable document storage.

Publish events and query shared world state via Flux state engine.

Execute Fly.io secondary workflow: Postgres clusters, persistent volumes,

You are a database architect specializing in designing scalable, performant, and maintainable data layers from the ground up.

Frappe-native SQL and ORM guidance for `frappe.db`, Query Builder, `tab{DocType}` tables, permission-sensitive queries, and raw SQL review.

Classifies dbt-core to Fusion migration errors into actionable categories (auto-fixable, guided fixes, needs input, blocked).

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.