数据库

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

86 个 Skills 可用

Skills 列表

things-mac

things-mac

384Kdatabase

Add, update, list, search, or inspect Things 3 todos, inbox, today, projects, areas, and tags on macOS.

steipete avatarsteipete
获取
plan-orchestrate

plan-orchestrate

237Kdatabase

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 avataraffaan-m
获取
kotlin-exposed-patterns

kotlin-exposed-patterns

231Kdatabase

JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and repository pattern.

affaan-m avataraffaan-m
获取
architecture-decision-records

architecture-decision-records

231Kdatabase

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 avataraffaan-m
获取
blueprint

blueprint

231Kdatabase

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 avataraffaan-m
获取
clickhouse-io

clickhouse-io

230Kdatabase

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

affaan-m avataraffaan-m
获取
database-migrations

database-migrations

230Kdatabase

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 avataraffaan-m
获取
laravel-patterns

laravel-patterns

230Kdatabase

Laravel architecture patterns, routing/controllers, Eloquent ORM, service layers, queues, events, caching, and API resources for production apps.

affaan-m avataraffaan-m
获取
jpa-patterns

jpa-patterns

230Kdatabase

JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

affaan-m avataraffaan-m
获取
postgres-patterns

postgres-patterns

230Kdatabase

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

affaan-m avataraffaan-m
获取
vitest

vitest

108Ktesting-qa

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 avatarsupabase
获取
project-overview

project-overview

81Kdatabase

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 avatarlobehub
获取
drizzle

drizzle

81Kdatabase

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 avatarlobehub
获取
deprecation-and-migration

deprecation-and-migration

78Kdatabase

管理弃用和迁移。用于移除旧系统、API 或功能时。用于将用户从一个实现迁移到另一个实现时。用于决定是维护现有代码还是将其淘汰时。

addyosmani avataraddyosmani
获取
documentation-and-adrs

documentation-and-adrs

77Kdatabase

记录决策和文档。在做出架构决策、更改公共 API、发布功能或需要记录未来工程师和代理理解代码库所需的上下文时使用。

addyosmani avataraddyosmani
获取
prisma-expert

prisma-expert

44Kdatabase

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 avatarsickn33
获取
create-spring-boot-kotlin-project

create-spring-boot-kotlin-project

37Kdatabase

Create Spring Boot Kotlin Project Skeleton

github avatargithub
获取
create-spring-boot-java-project

create-spring-boot-java-project

36Kdatabase

创建Spring Boot Java项目骨架

github avatargithub
获取
ef-core

ef-core

36Kdatabase

获取 Entity Framework Core 的最佳实践

github avatargithub
获取
snowflake-semanticview

snowflake-semanticview

36Kdatabase

使用 Snowflake CLI (snow) 创建、修改和验证 Snowflake 语义视图。当需要构建或排查语义视图/语义层定义(使用 CREATE/ALTER SEMANTIC VIEW)、通过 CLI 验证语义视图 DDL 或指导 Snowflake CLI 安装和连接设置时使用。

github avatargithub
获取
postgresql-code-review

postgresql-code-review

36Kdatabase

PostgreSQL 代码审查助手,专注于 PostgreSQL 最佳实践、反模式和独特质量标准。涵盖 JSONB 操作、数组使用、自定义类型、模式设计、函数优化以及行级安全(RLS)等 PostgreSQL 专属安全特性。

github avatargithub
获取
sql-code-review

sql-code-review

36Kdatabase

通用SQL代码审查助手,对MySQL、PostgreSQL、SQL Server、Oracle等所有SQL数据库进行全面安全、可维护性和代码质量分析。专注于SQL注入防护、访问控制、代码标准和反模式检测。与SQL优化提示互补,实现完整的开发覆盖。

github avatargithub
获取
sql-optimization

sql-optimization

36Kdatabase

通用SQL性能优化助手,提供全面的查询调优、索引策略和数据库性能分析,支持所有SQL数据库(MySQL、PostgreSQL、SQL Server、Oracle)。提供执行计划分析、分页优化、批量操作和性能监控指导。

github avatargithub
获取
postgresql-optimization

postgresql-optimization

36Kdatabase

PostgreSQL专用开发助手,专注于PostgreSQL独特功能、高级数据类型和PostgreSQL专属能力。涵盖JSONB操作、数组类型、自定义类型、范围/几何类型、全文搜索、窗口函数和PostgreSQL扩展生态系统。

github avatargithub
获取