Create new database tables with Drizzle ORM schemas and Valibot validation. 使用 Drizzle ORM 创建新的数据库表模式和 Valibot 验证。 Use when: - Adding new database tables - Creating entity schemas - User mentions "new table", "database schema", "add entity", "新增表", "数据库模式"
Generate and manage database seed data for development and testing. Use when developers need realistic test data, database migrations with initial data, or automated seeding for local environments. Supports PostgreSQL, MySQL, SQLite with Faker-based data generation and relationship management.
TiDB-specific documentation lookup guided by this repo's llms.txt hub: read llms.txt, pick the best linked source (tidb-dev-guide llms-full.txt, TiDB user guide llms.txt, or Uber Go style guide), fetch it, then search within it to answer with precise references. Use when asked to find docs, research, or provide doc-grounded answers about TiDB development or usage.
MySQL database development standards. Triggers when working with MySQL databases, queries, schema design, or optimization.
Define database models with clear naming, appropriate data types, proper constraints, and well-defined relationships. Use this skill when creating new database models or entities, defining model schemas, implementing model validations, setting up model relationships (one-to-one, one-to-many, many-to-many), adding timestamps or audit fields, defining database constraints (NOT NULL, UNIQUE, foreign keys), choosing appropriate data types for fields, implementing model hooks or lifecycle methods, creating indexes on model fields, working with ORM model files, or refactoring existing model definitions. Use when working with model files in directories like models/, entities/, or schema/ for ORMs like Sequelize, TypeORM, Prisma, SQLAlchemy, ActiveRecord, Django models, or Mongoose.
Standard patterns for connecting applications to Neon Postgres and managing schema changes via migrations (Alembic / SQLModel / SQLAlchemy), with attention to serverless connection behaviour.
PostgreSQL performance optimization techniques and query tuning
Adds a new table to Convex schema with indexes. Input: Table name, fields, and query patterns. Output: Updated schema.ts with new table definition.
Process large datasets with Doctrine batch processing, iteration, and memory management. WHEN: Processing thousands/millions of records, batch updates/inserts, clearing EntityManager periodically, using toIterable(), managing memory in long-running scripts. WHEN NOT: Simple CRUD operations, query optimization (use php-symfony-doctrine-fetch-modes), migrations (use php-symfony-doctrine-migrations).
Guide for building FoundationDB layers in Rust. Use when designing key schemas, handling transactions, implementing indexes, or troubleshooting FDB errors. Covers tuple layer, atomic ops, retries, and performance patterns.
Master Eloquent ORM with relationships, scopes, casts, observers, and query optimization. Use when creating models, defining relationships, writing queries, or optimizing database access.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
Define and structure database models with proper naming conventions, data integrity constraints, and relationship definitions. Use this skill when creating or modifying database model files, defining table schemas, setting up model relationships (one-to-many, many-to-many, one-to-one), working with ORM model files (schema.prisma, models/*, app/models/*, entities/*), implementing data validation at the model level, adding timestamps and audit fields, defining foreign keys and indexes, choosing appropriate data types, configuring cascade behaviors, or balancing database normalization with query performance. Apply this skill when designing database schemas, creating new models, refactoring existing model structures, or reviewing data integrity and relationship configurations.
Generate SQL schema for Agentuity Auth tables. Use for managing authentication credentials
Describes the structure of the Food Journal database that allows to store and read food journal entries
Expert database administrator specializing in high-availability systems, performance optimization, and disaster recovery. Masters PostgreSQL, MySQL, MongoDB, and Redis with focus on reliability, scalability, and operational excellence.
Production-ready SQLModel patterns for FastAPI applications. This skill should be used when creating database models, writing queries, managing sessions, setting up relationships, configuring connection pools, or troubleshooting database issues with SQLModel.
SQLite veritabani yapisi ve CRUD pattern referansi. Use when working with database operations, queries, or understanding the data model.
SQL schema conventions for PSRDatabase. When writing SQL schemas for PSRDatabase, follow these conventions strictly.
Usa este skill cuando el usuario pida crear una nueva tabla, modelo o esquema en Drizzle ORM para PostgreSQL.
数据库迁移技能：安全的数据库 schema 变更工作流。 Use when: 需要修改数据库结构、执行迁移、回滚变更。 Triggers: "迁移", "migration", "数据库", "schema", "表结构"
