数据库

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

217 个 Skills 可用

Skills 列表

core-data

core-data

1Kdatabase

Build, review, or improve Core Data persistence in apps that have not adopted SwiftData. Use when working with NSManagedObject subclasses, NSFetchedResultsController for list-driven UI, NSBatchInsertRequest / NSBatchDeleteRequest / NSBatchUpdateRequest for bulk operations, NSPersistentHistoryChangeRequest for persistent history tracking and multi-target sync, NSStagedMigrationManager for staged schema migrations (iOS 17+), NSCompositeAttributeDescription for composite attributes (iOS 17+), or when integrating Core Data threading with Swift Concurrency. For Core Data + SwiftData coexistence or migration, see the swiftdata skill instead.

dpearson2699 avatardpearson2699
获取
service-itsm-agentic-setup-configure

service-itsm-agentic-setup-configure

979database

Top-level orchestrator for setting up IT Service Management (ITSM) in Salesforce Service Cloud. Use when the user asks to set up ITSM, configure service management, wants a guided walkthrough, or asks what is needed to get ITSM running. Presents a paged multi-select track menu and delegates to domain sub-orchestrators — Incident Management, Agentforce for ITSM, CMDB, Channels (Portal, Notifications, Microsoft Teams, Slack), and Unified Catalog (find and deploy Service Process templates). Prerequisites (e.g., the Incident Management master switch) are owned inside the relevant sub-orchestrator, not at this level. Triggers on: set up ITSM, configure service management, ITSM setup, get ITSM running, set up CMDB / channels / Teams / Slack / Agentforce for ITSM / Unified Catalog templates. DO NOT TRIGGER when: the user asks about a specific feature directly (e.g., the priority matrix alone), asks only about Case management, wants to create a single user, or asks general ITSM questions without setup intent.

forcedotcom avatarforcedotcom
获取
d1-drizzle-schema

d1-drizzle-schema

977database

Generate Drizzle ORM schemas for Cloudflare D1 databases with correct D1-specific patterns. Produces schema files, migration commands, type exports, and DATABASE_SCHEMA.md documentation. Handles D1 quirks: foreign keys always enforced, no native BOOLEAN/DATETIME types, 100 bound parameter limit, JSON stored as TEXT. Use when creating a new database, adding tables, or scaffolding a D1 data layer.

jezweb avatarjezweb
获取
asc-subscription-localization

asc-subscription-localization

948database

使用 asc CLI 批量本地化 App Store 各语言区的订阅、订阅组以及内购项目(IAP)的显示名称与描述,支持 API 4.4.1 版本作用域的 v2 资源。适合在无需手动操作 App Store Connect 后台界面的情况下,快速填充或更新订阅/IAP 的多语言名称与描述。

rorkai avatarrorkai
获取
asc-subscription-localization

asc-subscription-localization

948database

使用 asc 命令行工具跨 App Store 各语言区域(Locales)批量本地化应用 <<<DESC>>> 使用 asc 命令行工具跨 App Store 各语言区域(Locale)批量本地化订阅(Subscription)、订阅组(Subscription Group)及内购(IAP)的显示名称与描述,支持 API 4.4.1 版本作用域的 v2 资源。适用于无需手动操作 App Store Connect 网页后台即可批量填充或更新订阅/内购名称及描述的场景。

rudrankriyam avatarrudrankriyam
获取
swiftdata

swiftdata

931database

Implement, review, or improve data persistence using SwiftData. Use when defining @Model classes with @Attribute, @Relationship, @Transient, #Unique, or #Index; when querying with @Query, #Predicate, FetchDescriptor, or SortDescriptor; when configuring ModelContainer and ModelContext for SwiftUI or background work with @ModelActor; when planning schema migrations with VersionedSchema and SchemaMigrationPlan; when setting up CloudKit sync with ModelConfiguration; or when coexisting with or migrating from Core Data.

dpearson2699 avatardpearson2699
获取
code-review

code-review

872database

按照 Sentry 工程实践执行代码审查。用于审查拉取请求、检查代码变更或提供代码质量反馈。涵盖安全性、性能、测试和设计审查。

getsentry avatargetsentry
获取
db

db

806database

Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. Use when the user asks to write, edit, rewrite, review, format, debug, tune, or explain SQL; create or refactor PL/SQL; use SQLcl, Liquibase, ORDS, JDBC, node-oracledb, Python, Java, .NET, or database frameworks; troubleshoot queries, sessions, locks, waits, indexes, optimizer plans, AWR, ASH, migrations, schemas, users, roles, privileges, backup, recovery, Data Guard, RAC, multitenant, containers, monitoring, auditing, encryption, VPD, or safe agent database operations.

oracle avataroracle
获取
data360-connect

data360-connect

786database

Salesforce Data Cloud Connect phase. Use this skill when the user manages Data Cloud connections, connectors, or sets up a new source system. TRIGGER when: user manages Data Cloud connections, connectors, connector metadata, tests a connection, browses source objects or databases, or sets up a new source system. DO NOT TRIGGER when: the task is about data streams or DLOs (use data360-prepare), DMOs or identity resolution (use data360-harmonize), retrieval/search (use data360-query), or STDM telemetry (use agentforce-observe).

forcedotcom avatarforcedotcom
获取
diffity-review

diffity-review

761database

Review current diff and leave comments using diffity agent commands

nilbuild avatarnilbuild
获取
azure-container-apps

azure-container-apps

745devops-cloud

Expert knowledge for Azure Container Apps development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when configuring ACA auth, KEDA/Dapr scaling, CI/CD deployments, Java microservices, or GPU/AI workloads, and other Azure Container Apps related development tasks. Not for Azure App Service (use azure-app-service), Azure Functions (use azure-functions), Azure Kubernetes Service (AKS) (use azure-kubernetes-service), Azure Red Hat OpenShift (use azure-redhat-openshift).

microsoftdocs avatarmicrosoftdocs
获取
azure-sql-database

azure-sql-database

745security

Expert knowledge for Azure SQL Database development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when choosing DTU/vCore tiers, configuring Hyperscale/HA, setting geo-replication/Data Sync, or automating CI/CD, and other Azure SQL Database related development tasks. Not for Azure SQL Managed Instance (use azure-sql-managed-instance), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines), Azure Cosmos DB (use azure-cosmos-db), Azure Data Factory (use azure-data-factory).

microsoftdocs avatarmicrosoftdocs
获取
dotnet-init

dotnet-init

710database

Interactive project initialization. Detects project type, asks architecture questions, and generates a customized CLAUDE.md — no manual template copying. Use when: "init project", "setup project", "initialize", "new project setup", "generate CLAUDE.md", "configure for dotnet-claude-kit", or starting Claude Code on a fresh or existing .NET codebase.

codewithmukesh avatarcodewithmukesh
获取
plan

plan

710database

Enter plan mode for .NET projects with architecture awareness. Analyzes tasks through the lens of supported architectures (VSA, Clean Architecture, DDD, Modular Monolith) and produces structured implementation plans before any code is written. Use when: "plan", "let's plan", "think through", "design this", "how should I implement", or any non-trivial task requiring 3+ steps.

codewithmukesh avatarcodewithmukesh
获取
migrate

migrate

710database

Guided, safe migration workflow covering EF Core schema migrations, .NET version upgrades, and NuGet dependency updates — each with rollback strategies and verification steps. Invoke when: "add migration", "update database", "create migration", "schema change", "new table", "rename column", "upgrade nuget", "update packages", "dependency update", "version upgrade", ".NET upgrade".

codewithmukesh avatarcodewithmukesh
获取
ef-core

ef-core

707database

Entity Framework Core patterns for .NET 10. Covers DbContext configuration, migrations workflow, interceptors, compiled queries, ExecuteUpdateAsync, ExecuteDeleteAsync, value converters, and query optimization. Load this skill when working with databases, writing queries, managing schema changes, or when the user mentions "EF Core", "Entity Framework", "DbContext", "migration", "LINQ query", "database", "SQL", "N+1", "Include", "split query", "value converter", "interceptor", or "compiled query".

codewithmukesh avatarcodewithmukesh
获取
project-setup

project-setup

707database

Tech-stack selection advisor for .NET projects: recommended defaults for database, auth, caching, messaging, observability, and resilience, with the rationale behind each default. Load when choosing or reviewing a project's tech stack, or when the user says "tech stack", "which database", "pick a stack", "recommended defaults", or "what should I use for". For project initialization use dotnet-init, for codebase assessment use health-check, for upgrades and schema changes use migrate.

codewithmukesh avatarcodewithmukesh
获取
nuxthub

nuxthub

700database

Use when building NuxtHub v0.10.6 applications - provides database (Drizzle ORM with sqlite/postgresql/mysql), KV storage, blob storage, and cache APIs. Covers configuration, schema definition, migrations, multi-cloud deployment (Cloudflare, Vercel), and the new hub:db, hub:kv, hub:blob virtual module imports.

onmax avataronmax
获取
vitess

vitess

641database

Vitess 最佳实践、查询优化和连接故障排查,适用于 PlanetScale Vitess 数据库。在处理 Vitess 数据库、分片、VSchema 配置、keyspace 管理或 MySQL 扩展问题时加载。

planetscale avatarplanetscale
获取
neki

neki

640database

Overview and information about Neki, the sharded Postgres product by PlanetScale. Load when working with Neki-related tasks and the need to scale or shard postgres. Load when facing Postgres scaling or sharding issues.

planetscale avatarplanetscale
获取
read-file

read-file

577database

Read any data file (CSV, JSON, Parquet, Avro, Excel, spatial, SQLite) or remote URL (S3, HTTPS). Use when user references a data file, asks "what's in this file", or wants to preview/profile a dataset. Not for source code.

duckdb avatarduckdb
获取
mysql

mysql

549database

规划和审查 MySQL/InnoDB 的 schema、索引、查询调优、事务和运维。在创建或修改 MySQL 表、索引或查询时,诊断慢查询或锁行为时,规划迁移时,或排查复制和连接问题时使用。在使用 MySQL 数据库时加载。

planetscale avatarplanetscale
获取
postgres

postgres

549database

PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.

planetscale avatarplanetscale
获取
chdb-sql

chdb-sql

495database

当用户希望对本地文件(parquet/csv/json)、URL、S3路径或远程数据库(Postgres、MySQL、MongoDB、ClickHouse Cloud、Iceberg、Delta Lake)运行SQL(尤其是分析型SQL),而无需搭建服务器时使用。提供chDB——嵌入Python的ClickHouse SQL,支持1000+函数、用于有状态多步骤管道的Session、参数化查询,以及通过`s3()`、`mysql()`、`postgresql()`、`iceberg()`、`deltaLake()`、`remoteSecure()`表函数实现的跨源JOIN。触发条件:用户希望对parquet/csv/文件或跨远程分析源使用SQL;使用ClickHouse SQL特性(窗口函数、windowFunnel、geoToH3、JSON路径操作、Session、参数化查询);导入`chdb`或调用`chdb.query()`。跳过此技能:用于pandas风格的DataFrame方法链(请使用chdb-datastore)或ClickHouse服务器管理。

clickhouse avatarclickhouse
获取