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

things-mac
Add, update, list, search, or inspect Things 3 todos, inbox, today, projects, areas, and tags on macOS.
steipete
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
kotlin-exposed-patterns
JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and repository pattern.
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
clickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
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
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
affaan-m
vitest
Vitest API and config reference (Jest-compatible) — mocking with vi.*, spies, fake timers, coverage configuration, fixtures, snapshots, and test filtering. Use for Vitest API and configuration questions anywhere in the monorepo; for Studio-specific test strategy and component-test setup, start with studio-testing and studio-mock-api-tests.
supabase
project-overview
LobeHub open-source monorepo architecture map. Use when locating code layers, understanding apps/packages/src layout, business stubs, project structure, or onboarding to the repository.
lobehub
drizzle
LobeHub Drizzle ORM schema and query style. Use for pgTable schemas, indexes, joins, inferred types, db.select/db.query, schema fields, foreign keys, junction tables, or postgres query patterns.
lobehub
deprecation-and-migration
管理弃用和迁移。用于移除旧系统、API 或功能时。用于将用户从一个实现迁移到另一个实现时。用于决定是维护现有代码还是将其淘汰时。
addyosmani
documentation-and-adrs
记录决策和文档。在做出架构决策、更改公共 API、发布功能或需要记录未来工程师和代理理解代码库所需的上下文时使用。
addyosmani
prisma-expert
You are an expert in Prisma ORM with deep knowledge of schema design, migrations, query optimization, relations modeling, and database operations across PostgreSQL, MySQL, and SQLite.
sickn33
create-spring-boot-kotlin-project
Create Spring Boot Kotlin Project Skeleton
github
create-spring-boot-java-project
创建Spring Boot Java项目骨架
github
ef-core
获取 Entity Framework Core 的最佳实践
github
snowflake-semanticview
使用 Snowflake CLI (snow) 创建、修改和验证 Snowflake 语义视图。当需要构建或排查语义视图/语义层定义(使用 CREATE/ALTER SEMANTIC VIEW)、通过 CLI 验证语义视图 DDL 或指导 Snowflake CLI 安装和连接设置时使用。
github
postgresql-code-review
PostgreSQL 代码审查助手,专注于 PostgreSQL 最佳实践、反模式和独特质量标准。涵盖 JSONB 操作、数组使用、自定义类型、模式设计、函数优化以及行级安全(RLS)等 PostgreSQL 专属安全特性。
github
sql-code-review
通用SQL代码审查助手,对MySQL、PostgreSQL、SQL Server、Oracle等所有SQL数据库进行全面安全、可维护性和代码质量分析。专注于SQL注入防护、访问控制、代码标准和反模式检测。与SQL优化提示互补,实现完整的开发覆盖。
github
sql-optimization
通用SQL性能优化助手,提供全面的查询调优、索引策略和数据库性能分析,支持所有SQL数据库(MySQL、PostgreSQL、SQL Server、Oracle)。提供执行计划分析、分页优化、批量操作和性能监控指导。
github
postgresql-optimization
PostgreSQL专用开发助手,专注于PostgreSQL独特功能、高级数据类型和PostgreSQL专属能力。涵盖JSONB操作、数组类型、自定义类型、范围/几何类型、全文搜索、窗口函数和PostgreSQL扩展生态系统。
github