Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,314
pages available: 180

Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.

Open in full browser

Browse databases skills

Showing 3,985–4,008 of 4,314 skills

Crud ImplementationAComplete workflow guide for implementing new CRUD entities. Use when adding a new resource, implementing full CRUD operations, or needing an overview of the database-to-API flow. Triggers: "new entity", "add resource", "implement CRUD", "create table and API". Orchestrates add-database-table, add-domain-entity, and add-api-endpoint skills.databasesgobashVotes: 0GitHub stars: 666
Crud DevelopmentA定义若依（RuoYi / RuoYi-Vue-Plus 生态）在数据持久层（Mapper）与业务层（Service）的 CRUD 开发规范。要求 Mapper 统一继承 `BaseMapperPlus<Entity,Vo>`、Service 统一实现 `IService<Entity>` 并采用标准实现基类；查询/更新条件强制使用 `LambdaQueryWrapper` / `LambdaUpdateWrapper` 构建类型安全条件；分页统一使用 `PageQuery` + `TableDataInfo<T>` 返回。严禁循环执行 SQL、严禁直接返回 Entity 给前端、严禁 `SELECT *`，写操作强制采用批量 API 与 VO/DTO 封装，提升代码一致性、可维护性与性能。databasesjavasqlVotes: 0GitHub stars: 666
Cross Service IntegrationAUse when designing or implementing cross-service communication, data synchronization, or service boundary patterns.databasesgobashVotes: 0GitHub stars: 666
Cross Env Postgresql ExtensionsAActivate when creating database migrations that enable or disable PostgreSQL extensions. Provides the DO block pattern for cross-environment compatibility between Nhost Cloud, CNPG (CloudNativePG), and other PostgreSQL environments.databasessqlgitVotes: 0GitHub stars: 666
Crm Rmx Sync IntegrationACreate or update CRM to RMX syncing integrations. Use when adding a new synced entity, mapping, EF Core model/migration, or CrmSyncingInboxService logic for CRM to RMX (and optional RMX to CRM live sync/outbox). Produces a repeatable step-by-step plan and implements the integration.databasesphptestingVotes: 0GitHub stars: 666
TaskmanagerAManage tasks, state, and memories - parse PRDs into hierarchical tasks with dependencies and complexitydatabasesgosqlVotes: 0GitHub stars: 35
Taskmanager MemoryAManage project memories - constraints, decisions, conventions with conflict detection and resolutiondatabasesrustgoVotes: 0GitHub stars: 35
Critical PeerAProfessional skepticism with pattern enforcement. Verify before agreeing, challenge violations, propose instead of asking. Concise output, research before asking, answer questions literally.databasestypescriptrustVotes: 0GitHub stars: 666
Docker DocsAReference Docker and Compose documentation for configuration patterns and best practicesdatabasesgosqlVotes: 0GitHub stars: 35
Docker DatabaseAConfigure database containers with security, persistence, and health checksdatabasesgoshellVotes: 0GitHub stars: 35
Creating Gorm EntityACreates GORM entity structs for go-kratos microservices with BaseModel embedding, proper field tags, relationships (one-to-one, one-to-many), indexing strategies, and soft delete support. Use when defining database schema, creating new entities, setting up table relationships, or configuring database constraints.databasesgodatabaseVotes: 0GitHub stars: 666
Creating Elysia DomainsACreates new domain modules in the Nexus Elysia API with proper typing for Eden Treaty consumers (Dashboard, The Machine)databasestypescriptbashVotes: 0GitHub stars: 666
TestcontainersAWrite integration tests using TestContainers for .NET with xUnit. Covers infrastructure testing with real databases, message queues, and caches in Docker containers instead of mocks.databasesrustgoVotes: 0GitHub stars: 1,155
Package ManagementAManage NuGet packages using Central Package Management (CPM) and dotnet CLI commands. Never edit XML directly - use dotnet add/remove/list commands. Use shared version variables for related packages.databasesgobashVotes: 0GitHub stars: 1,155
Efcore PatternsAEntity Framework Core best practices including NoTracking by default, query splitting for navigation collections, migration management, dedicated migration services, and common pitfalls to avoid.databasesbashsqlVotes: 0GitHub stars: 1,155
Akka Hosting Actor PatternsAPatterns for building entity actors with Akka.Hosting - GenericChildPerEntityParent, message extractors, cluster sharding abstraction, akka-reminders, and ITimeProvider. Supports both local testing and clustered production modes.databasesgosqlVotes: 0GitHub stars: 1,155
Create SchemaACreate Zod schemas for new entities/resources in the backend. Use when adding a new resource, creating data models, defining DTOs (CreateType, UpdateType), or setting up validation schemas. Triggers on "new schema", "add entity", "create model", "define type".databasestypescriptdatabaseVotes: 0GitHub stars: 666
Create Purchase ReceiptACreate goods receipt (GR) record when receiving goods from supplierdatabasespythongoVotes: 0GitHub stars: 666
Create Purchase OrderACreate purchase order (PO) in NexERP databasedatabasespythongoVotes: 0GitHub stars: 666
Managing AdrsACreate and manage Architecture Decision Records (ADRs) with auto-numbering, template detection, and index maintenance. Use when user mentions "ADR", "architecture decision", "document this decision", "create ADR", editing ADR files (docs/adr/, doc/adr/, .adr/), or discussing architectural choices and tradeoffs.databasesgobashVotes: 0GitHub stars: 21
Create Purchase InvoiceACreate purchase invoice in NexERP databasedatabasespythongoVotes: 0GitHub stars: 666
Create Mongodb RepositoryACreate MongoDB repository implementation for production database. Use when implementing repository interface with MongoDB, setting up document mapping, creating indexes, or connecting to real database. Triggers on "mongodb repository", "mongo repository", "production repository", "database repository".databasestypescriptgoVotes: 0GitHub stars: 666
Create ModelACreate Prisma model layer functions. Use when adding database operations. Never call Prisma directly in routes.databasestypescriptgoVotes: 0GitHub stars: 666
Create MigrationACreate, apply, and rollback database migrations using goosedatabasesgobashVotes: 0GitHub stars: 666