database-dev
Specialist in database design and development. Provides expert assistance on schema design, migrations, query optimization, indexing, normalization, and ORM configuration. Works with PostgreSQL, MongoDB, SQLite, Supabase, Firebase, Redis, Prisma, and Drizzle. Use this agent when the user mentions concepts like user database, database, DB, SQL, table, schema, migration, query, index, Prisma, Supabase, MongoDB, PostgreSQL, relationship, or foreign key.
database-architect
Expert database architect specializing in data-layer design from scratch, technology selection, schema modeling, and scalable database architectures. Expert in selecting SQL, NoSQL, and time-series databases, normalization strategies, migration planning, and performance-first design. Handles both greenfield architectures and re-architecture of existing systems. Use proactively for database architecture, technology selection, or data-modeling decisions.
supabase
Supabase development and self-hosted operations. Use when user mentions supabase, database query, migration, Edge Function, RLS policy, pgvector, vector search, backup, health check, or says "資料庫", "supabase掛了", "備份", "向量搜尋", "RAG". Covers CLI ops, Docker management, schema design, and vector/RAG pipelines.
database-best-practices
Prisma ORM best practices for Shopify apps including multi-tenant data isolation, query optimization, transaction patterns, and migration strategies. Auto-invoked when working with database operations.
backend-dev-guidelines
Comprehensive backend development guide for Node.js/Express/TypeScript microservices. Use when creating routes, controllers, services, repositories, middleware, or working with Express APIs, Prisma database access, Sentry error tracking, Zod validation, unifiedConfig, dependency injection, or async patterns. Covers layered architecture (routes → controllers → services → repositories), BaseController pattern, error handling, performance monitoring, testing strategies, and migration from legacy patterns.
laravel-backend-development
Triggers on Laravel backend tasks: controllers, models, migrations, APIs, services, jobs, policies, database schema, Eloquent, or any server-side PHP. Generates idiomatic Laravel code with string ULID IDs, versioned REST APIs, and modern best practices.
database-migrations-sql-migrations
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server, focusing on data integrity and rollback plans.
data-integrity-guardian
Use this agent when you need to review database migrations, data models, or any code that manipulates persistent data. This includes checking migration safety, validating data constraints, ensuring transaction boundaries are correct, and verifying that referential integrity and privacy requirements are maintained.
database design
Schema design, indexing, migrations, query optimization, and PostgreSQL patterns for production systems.
senior-backend
This skill should be used when the user asks to "design REST APIs", "optimize database queries", "implement authentication", "build microservices", "review backend code", "set up GraphQL", "handle database migrations", or "load test APIs". Use for Node.js/Express/Fastify development, PostgreSQL optimization, API security, and backend architecture patterns.
Designing Database Schemas
Process use when you need to work with database schema design. This skill provides schema design and migrations with comprehensive guidance and automation. Trigger with phrases like "design schema", "create migration", or "model database".
wp-migrate
This skill should be used when the user asks to "migrate a site", "move WordPress", "transfer my site", "clone site", "copy site to new hosting", or mentions any WordPress migration between hosts or platforms. Covers full site, content-only, and database migrations.
database-migrations-migration-observability
Migration monitoring, CDC, and observability infrastructure
gin-database
Integrate PostgreSQL databases with Go Gin APIs using GORM or sqlx. Covers repository pattern, connection pooling, transactions, migrations, and dependency injection. Use when adding database support, creating models, writing queries, implementing repositories, setting up migrations, or wiring database layers into a Gin project. Also activate when the user mentions GORM, sqlx, database connection, SQL queries, repository pattern, or database migrations in a Go/Gin context.
DB Schema Designer
Designs database schemas from domain model descriptions. Generates ERD, migration scripts, and index strategies for PostgreSQL, MySQL, and MongoDB. Includes Prisma, Drizzle, SQLAlchemy, and raw SQL support.
database-migration
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
gin-database
Integrate PostgreSQL databases with Go Gin APIs using GORM or sqlx. Covers repository pattern, connection pooling, transactions, migrations, and dependency injection. Use when adding database support, creating models, writing queries, implementing repositories, setting up migrations, or wiring database layers into a Gin project. Also activate when the user mentions GORM, sqlx, database connection, SQL queries, repository pattern, or database migrations in a Go/Gin context.
database-schema-generator
Generate PostgreSQL/Supabase database schemas from natural language descriptions. Use when creating new databases, adding tables to existing projects, or designing data models. Includes RLS policies, TypeScript types, and migration files.
api-database-drizzle
Drizzle ORM, queries, migrations
data-migration-expert
Use this agent when reviewing PRs that touch database migrations, data backfills, or any code that transforms production data. This agent validates ID mappings against production reality, checks for swapped values, verifies rollback safety, and ensures data integrity during schema changes. Essential for any migration that involves ID mappings, column renames, or data transformations.
Supabase Manager
Install, configure, and manage Supabase projects — local dev, migrations, database management, edge functions, and production deployment from the CLI.
Managing Database Migrations
Process use when you need to work with database migrations. This skill provides schema migration management with comprehensive guidance and automation. Trigger with phrases like "create migration", "run migrations", or "manage schema versions".
drizzle-migrations
Drizzle ORM migrations for Neon PostgreSQL. Use when creating database schemas, running migrations, or troubleshooting Drizzle issues.
api-database-prisma
Prisma ORM, type-safe queries, migrations, relations
database-optimizer
Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures. Masters advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization. Handles complex query analysis, migration strategies, and performance monitoring. Use PROACTIVELY for database optimization, performance issues, or scalability challenges.