数据库
数据库管理与查询
ruoyi-code-generator
alffei
基于若依(RuoYi)框架规范生成 CRUD 代码。当用户需要为数据表生成后端Java代码(实体类、Mapper、Service、Controller)、 前端Vue代码(列表页、API封装)、MyBatis XML映射文件或菜单初始化SQL时使用此技能。 适用于: 创建新模块、添加业务功能、根据表结构生成代码等场景。
semgrep-rule-variant-creator
lv416e
Creates language variants of existing Semgrep rules. Use when porting a Semgrep rule to specified target languages. Takes an existing rule and target languages as input, produces independent rule+test directories for each language.
create-auth-skill
futuregerald
Skill for creating auth layers in TypeScript/JavaScript apps using Better Auth.
changelog
v1-io
Use when generating a changelog from recent merged PRs or documenting releases. Triggers on "write changelog", "release notes", "what shipped".
better-auth-best-practices
futuregerald
Skill for integrating Better Auth - the comprehensive TypeScript authentication framework.
architecture-decision-records
futuregerald
Write and maintain Architecture Decision Records (ADRs) following best practices for technical decision documentation. Use when documenting significant technical decisions, reviewing past architectural choices, or establishing decision processes.
json-typed-attributes
RoleModel
Define typed attributes backed by JSON fields in Rails models. Use when models need flexible data storage with type casting, validations, and form integration. Supports integer, decimal, string, text, boolean, date, and array types.
turso-best-practices
futuregerald
Turso and libSQL best practices for SQLite-compatible cloud database development with edge distribution, embedded replicas, and vector search.
pandas-coder
majesticlabs-dev
DataFrame manipulation with chunked processing, memory optimization, and vectorized operations.
sql-optimization-patterns
futuregerald
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
esx-framework
proelias7
Develops resources for FiveM using the ESX Framework (Legacy). Covers resource creation, Core Object (ESX), xPlayer functions, Events, Callbacks, Items, Jobs, Database (oxmysql), and best practices. Use when the user works with FiveM, ESX, ESX Legacy, or mentions ESX.GetCoreObject, xPlayer, ESX.GetPlayerFromId, or esx:.
performance-profiling
lv416e
"Use when investigating performance issues, before attempting any optimization - four-phase methodology (baseline measurement, bottleneck profiling, complexity analysis, targeted optimization) that ensures data-driven decisions over gut-feel tuning パフォーマンスの問題を調査する際、最適化を試みる前に使用 - 4フェーズ手法(ベースライン測定、ボトルネックプロファイリング、計算量分析、的を絞った最適化)により、直感的なチューニングではなくデータに基づく判断を保証"
aws-cli
oldwinter
This skill should be used when users need to interact with AWS services via CLI. It covers all AWS services including EC2, ECS, EKS, Lambda, S3, RDS, DynamoDB, VPC, Route53, CloudFront, Bedrock, Support, Billing, and more. Supports querying, creating, modifying, deleting resources, monitoring, debugging, and cost analysis. Triggers on requests mentioning AWS, cloud resources, or specific AWS service names.
state-management
mgd34msu
"Load PROACTIVELY when task involves application state, data fetching, or form handling. Use when user says \"manage state\", \"add data fetching\", \"set up Zustand\", \"handle form validation\", or \"add React Query\". Covers server state (TanStack Query with caching, optimistic updates), client state (Zustand stores), form state (React Hook Form with Zod validation), URL state (search params, routing), and choosing between state solutions."
aws-cost-explorer
oldwinter
This skill should be used when users need to query AWS cost and usage details for a specific date. It supports querying costs at service level (e.g., EC2, S3, RDS) and drilling down to usage type level (e.g., instance types, storage classes, data transfer). Triggers on requests mentioning AWS costs, billing, spending, cost breakdown, or fee analysis.
qbcore-framework
proelias7
Develops resources for FiveM using the QBCore Framework. Covers resource creation, Core Object usage, Player management, Callbacks, Events, Items, Jobs, Gangs, Database (oxmysql), and best practices. Use when the user works with FiveM, QBCore, Lua scripts for QBCore servers, or mentions QBCore.Functions, GetCoreObject, CitizenID, or any system of the QBCore Framework.
supabase-postgres-best-practices
oldwinter
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
api-design-principles
futuregerald
Master REST and GraphQL API design principles to build intuitive, scalable, and maintainable APIs that delight developers. Use when designing new APIs, reviewing API specifications, or establishing API design standards.
fixture-invalid-schema-skill
daishiman
Skill with invalid JSON schema for testing
pandera-validation
majesticlabs-dev
DataFrame schema validation using pandera. Schema definitions, column checks, and decorator-based validation.
SQLite Database Expert
futuregerald
Expert in SQLite, libSQL, and Turso database development for desktop and web applications with focus on SQL injection prevention, migrations, FTS search, edge deployments, and secure data handling
parquet-coder
majesticlabs-dev
Columnar file patterns including partitioning, predicate pushdown, and schema evolution.
dbt-coder
majesticlabs-dev
dbt (data build tool) patterns for model organization, incremental strategies, and testing.
fivem-development
proelias7
Develops resources for FiveM using vRP Creative Network with Lua. Covers resource creation, Proxy/Tunnel system, inventory, money, groups, identity, NUI, database (oxmysql), security, and performance. Use when the user works with FiveM, vRP, Lua scripts for GTA V servers, or mentions resources, client/server scripts, natives, NUI, or any system of the vRP Creative Network framework.