数据库
SQL、Schema 设计、迁移和数据库操作
Skills 列表

things-mac
Add, update, list, search, or inspect Things 3 todos, inbox, today, projects, areas, and tags on macOS.
openclaw
things-mac
在 macOS 上添加、更新、列出、搜索或检查 Things 3 待办事项、收件箱、今天、项目、区域和标签。
steipete
uncloud
Use when managing an Uncloud cluster — deploying services, configuring Caddy ingress, adding static proxy routes for non-cluster devices, publishing ports, scaling, inspecting logs, or managing machines and volumes with the `uc` CLI.
affaan-m
plan-orchestrate
Read a plan document, decompose it into steps, design a per-step agent chain from the ECC catalogue, and emit ready-to-paste /orchestrate custom prompts. Generative only — never invokes /orchestrate itself. Use when the user has a multi-step plan and wants to drive it through orchestrate without composing chains by hand.
affaan-m
prisma-patterns
Prisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like updateMany returning count not records, $transaction timeouts, migrate dev resetting the DB, @updatedAt skipped on bulk writes, and serverless connection exhaustion. Use when writing a Prisma schema or query, or debugging transactions, migrations, or serverless connection limits.
affaan-m
architecture-decision-records
Capture architectural decisions made during Claude Code sessions as structured ADRs. Auto-detects decision moments, records context, alternatives considered, and rationale. Maintains an ADR log so future developers understand why the codebase is shaped the way it is.
affaan-m
blueprint
Turn a one-line objective into a step-by-step construction plan for multi-session, multi-agent engineering projects. Each step has a self-contained context brief so a fresh agent can execute it cold. Includes adversarial review gate, dependency graph, parallel step detection, anti-pattern catalog, and plan mutation protocol. TRIGGER when: user requests a plan, blueprint, or roadmap for a complex multi-PR task, or describes work that needs multiple sessions. DO NOT TRIGGER when: task is completable in a single PR or fewer than 3 tool calls, or user says "just do it".
affaan-m
kotlin-exposed-patterns
JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and repository pattern.
affaan-m
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
affaan-m
database-migrations
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate).
affaan-m
laravel-patterns
Laravel architecture patterns, routing/controllers, Eloquent ORM, service layers, queues, events, caching, and API resources for production apps.
affaan-m
jpa-patterns
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.
affaan-m
clickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
affaan-m
prisma-patterns
TypeScript 后端开发中的 Prisma ORM 最佳实践与踩坑指南 — 涵盖 Schema 设计、查询优化、事务处理、分页方案,以及常见避坑点(如 updateMany 只返回 count 不返回记录行、$transaction 超时、migrate dev 重置数据库、批量写入跳过 @updatedAt、Serverless 环境下数据库连接池耗尽等)。
affaan-m
plan-orchestrate
读取计划文档,将其拆解为多个步骤,从 ECC 目录中为每个步骤设计专属 Agent 链,并生成可直接复制粘贴的 /orchestrate custom 提示词。纯生成工具——绝不主动调用 /orchestrate。当用户拥有多步骤计划且希望通过 orchestrate 执行,又不想手动搭 Agent 链时使用。
affaan-m
kotlin-exposed-patterns
JetBrains Exposed ORM 的最佳实践与设计模式,涵盖 DSL 查询、DAO 模式、事务管理、HikariCP 连接池配置、Flyway 数据库迁移以及 Repository 仓储模式实现。
affaan-m
architecture-decision-records
在 Claude Code 会话期间捕获架构决策,并将其记录为结构化的 ADR。自动检测决策时刻,记录上下文、备选方案和理由。维护 ADR 日志,以便未来的开发者理解代码库为何如此设计。
affaan-m
blueprint
将一行目标转化为多会话、多智能体工程项目的逐步构建计划。每个步骤都包含自包含的上下文摘要,使新智能体无需前置知识即可执行。包含对抗性审查关卡、依赖关系图、并行步骤检测、反模式目录和计划变更协议。触发条件:用户请求复杂多PR任务的计划、蓝图或路线图,或描述需要多个会话完成的工作。不触发条件:任务可在单个PR或少于3次工具调用内完成,或用户说“直接做”。
affaan-m
clickhouse-io
ClickHouse数据库模式、查询优化、分析以及面向高性能分析工作负载的数据工程最佳实践。
affaan-m
database-migrations
针对数据库 Schema 变动、数据迁移、回滚以及零停机部署的最佳实践,覆盖 PostgreSQL、MySQL 和常见 ORM/迁移工具(如 Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate)。
affaan-m
laravel-patterns
Laravel架构模式、路由/控制器、Eloquent ORM、服务层、队列、事件、缓存和API资源,适用于生产级应用。
affaan-m
jpa-patterns
JPA/Hibernate模式,用于Spring Boot中的实体设计、关系映射、查询优化、事务管理、审计、索引、分页和连接池。
affaan-m
postgres-patterns
PostgreSQL 数据库模式,涵盖查询优化、模式设计、索引和安全。基于 Supabase 最佳实践。
affaan-m
vercel-composition-patterns
React composition patterns that scale. Use when refactoring components with
supabase