Database workflows - schema design, migrations, query optimization. Use when designing schemas, reviewing migrations, optimizing queries, preventing N+1 problems, or working with ORMs like Prisma, Drizzle, and TypeORM.
Automatically reviews data pipelines, optimizes SQL queries, and ensures data quality. Activates when you mention: data pipeline, ETL, SQL optimization, query performance, data quality, schema design, Airflow DAG, database index, slow query. Provides: Pipeline design patterns, SQL query optimization, index recommendations, data validation strategies, schema improvements. Supports: PostgreSQL, MySQL, SQLAlchemy, Prisma, Spring Data JPA
Provides general guidance for implementing data access layers in backend applications. This skill should be used when designing repositories, implementing query methods, or managing database access patterns.
Production-grade event-driven architecture skill for Kafka, RabbitMQ, event sourcing, CQRS, and message patterns
Supabase backend patterns for Crispy CRM - RLS policies, Edge Functions, query optimization, and migration best practices. Focuses on PostgreSQL 17 patterns with soft deletes and multi-tenant architecture.
Plan and implement safe database schema changes including migrations, indexes, and backfills. Use when creating tables, adding columns, optimizing queries, or managing Eloquent relationships. EXCLUSIVE to database-admin agent.
Design and optimize database schemas, queries, and migrations with best practices
This skill should be used when the user asks to "create MongoDB model", "define Beanie document", "write MongoDB query", "create aggregation pipeline", "run database migration", "index MongoDB collection", or mentions Beanie, Motor, MongoDB documents, or async database operations. Provides MongoDB/Beanie ODM patterns for FastAPI.
Kailash DataFlow - zero-config database framework with automatic model-to-node generation. Use when asking about 'database operations', 'DataFlow', 'database models', 'CRUD operations', 'bulk operations', 'database queries', 'database migrations', 'multi-tenancy', 'multi-instance', 'database transactions', 'PostgreSQL', 'MySQL', 'SQLite', 'MongoDB', 'pgvector', 'vector search', 'document database', 'RAG', 'semantic search', 'existing database', 'database performance', 'database deployment', 'database testing', or 'TDD with databases'. DataFlow is NOT an ORM - it generates 11 workflow nodes per SQL model, 8 nodes for MongoDB, and 3 nodes for vector operations.
This skill should be used when the user asks to "update TBC schemas", "regenerate schemas from kicker", "sync schemas with new TBC version", "extract schemas from kicker-aggregated.json", "update template schemas", or mentions "schema update", "schema regeneration", "kicker update", or "new TBC release".
Expert-level Apache Kafka, event streaming, Kafka Streams, and distributed messaging
Author SEA-DSL specifications with proper CQRS annotations, validation, and namespace conventions. Use when creating .sea files with entities, flows, and policies that require @cqrs, @tx, @outbox, and @idempotency annotations following the Flow-only CQRS tagging pattern.
Guide for using code execution capabilities to perform parallel batch processing, conditional filtering, and data aggregation. This skill should be used when agents need to analyze multiple files efficiently, validate large result sets, aggregate data from multiple sources, or reduce token consumption through execution-based filtering. Provides reusable templates for quota-aware workflows, error handling patterns, and token-efficient data processing.
Backend architecture agent for API design, database schema, and microservices
Data pipeline architecture, ETL/ELT patterns, data modeling, and production data platform design
Use this skill whenever the user wants to design, set up, or refactor Cloudflare D1 database usage in a Hono + TypeScript app running on Cloudflare Workers/Pages, including schema management, bindings, query patterns, and data-access structure.
Expert knowledge on Supabase Postgres schema, Drizzle ORM patterns, normalized user tables, relations, query patterns, and migrations. Use this skill when user asks about "database", "schema", "drizzle", "query", "table", "postgres", "supabase", "migration", or database design questions.
Create and manage database migrations following best practices for safe schema evolution. Use this skill when creating new database migration files for schema changes. Use this skill when modifying table structures, adding or removing columns, or changing data types. Use this skill when creating or modifying database indexes. Use this skill when implementing reversible migrations with up/down or rollback methods. Use this skill when working with migration files in database change management directories. Use this skill when planning zero-downtime deployments or backwards-compatible schema changes. Use this skill when separating schema changes from data migrations.
Advanced distributed event patterns for ABP microservices including idempotent handlers, cross-tenant events, event sourcing lite, and saga patterns. Use when: (1) implementing event handlers across services, (2) ensuring idempotent event processing, (3) cross-tenant event handling, (4) designing event-driven architectures.
Provides Prisma-specific patterns for soft delete, transactions, optimistic locking, bulk operations, and performance optimization. This skill should be used when implementing data persistence, handling concurrent updates, managing complex multi-table operations, or optimizing query performance.
Tool for managing Neon Postgres databases. Use for listing projects, inspecting schema, and running queries.
Work with Drizzle ORM, PostgreSQL schema, database migrations, and Supabase. Use when working with database schema, migrations, SQL queries, pgvector, RLS policies, or database operations.
Teach agents to design TUIs in the tuimorphic style (Bagels/Calcure/Claude Code/Droid-inspired).
