Database
Database management and queries
build-agents-index
by digipulse-engineering
Scan all agent and sub-agent definition files in .gaai/core/agents/, extract YAML frontmatter, merge with specialists.registry.yaml, and generate a derived agents-index.yaml at .gaai/core/agents/agents-index.yaml. Activate after adding, modifying, or removing any agent, sub-agent, or specialist entry.
seq
by tkersey
"Mine Codex sessions JSONL (~/.codex/sessions) and file-based memories (~/.codex/memories) for skill usage, section/format compliance, trigger evidence, token metrics, and prompt-to-session lookup for resume workflows. Use for prompts like $seq, analyze session history, find sessions by prompt, rank skill mentions, audit missing sections, report token usage, mine memories, or use $seq to improve skill trigger descriptions/frontmatter."
reduce
by tkersey
Deconstruct high-cost abstractions and recommend lower-level primitives that reduce tooling, indirection, and hidden steps. Use when requests ask for fewer layers (for example "too many layers", "remove this framework/plugin/DI", "ditch codegen/task runners", "replace with plain scripts/config/SQL"), or ask for an abstraction audit with a prioritized cut list and phased migration with rollback (analysis-only unless implementation is explicitly requested).
Orquestador Backend
by scaleto
Líder del Grupo Backend. Planifica y delega tareas de APIs, bases de datos, y arquitectura servidor a los especialistas del grupo.
Orquestador Seguridad
by scaleto
Líder del Grupo Seguridad. Planifica y delega tareas de ciberseguridad, auditorías, compliance y pentesting a los especialistas del grupo.
review-against-solid-principles
by Jamie-BitFlight
"Single-pass SOLID review — dispatches one reviewer over the complete ruleset, emitting the fixed candidate schema."
go-goose
by metalagman
Use this skill to plan, write, or run database migrations with the pressly/goose CLI and Go library (SQL/Go migrations, env vars, provider API, embedded migrations).
angular-signals
by analogjs
Implement signal-based reactive state management in Angular v20+. Use for creating reactive state with signal(), derived state with computed(), dependent state with linkedSignal(), and side effects with effect(). Triggers on state management questions, converting from BehaviorSubject/Observable patterns to signals, or implementing reactive data flows.
jpa-patterns
by xu-xiang
Spring Boot 中用于实体设计、关联关系、查询优化、事务、审计、索引、分页和连接池的 JPA/Hibernate 模式。
postgres-patterns
by xu-xiang
PostgreSQL 数据库模式，涵盖查询优化、模式设计、索引和安全性。基于 Supabase 最佳实践。
clickhouse-io
by xu-xiang
ClickHouse 数据库模式、查询优化、分析以及针对高性能分析工作负载的数据工程最佳实践。
python-testing
by xu-xiang
使用 pytest、TDD 方法论、fixtures、mocking、参数化和代码覆盖率要求的 Python 测试策略。
django-security
by xu-xiang
Django 安全最佳实践，涵盖身份认证、授权、CSRF 防护、SQL 注入预防、XSS 预防以及安全的部署配置。
Java Backend Developer Skill Profile
by SoledadVac
Never suggest Python scripts â I work in pure Java ecosystem
airiot
by sshwsfc
"Complete AIRIOT Platform Development Guide - React TypeScript client with shadcn/ui framework, Vite build tool, and MCP server integration. Covers project initialization, development standards, and comprehensive client library usage including API client (createAPI, CRUD operations), Authentication (useLogin, useLogout, useUser), JSON Schema Forms (SchemaForm, FieldArray), Jotai-based State Management (Model, TableModel, useModel hooks), Page Hooks (usePageVar, useDatasourceValue), Real-time Data Subscription (Subscribe, useDataTag, useTableData), and Configuration (setConfig, useMessage)."
airiot
by sshwsfc
"Complete AIRIOT Platform Development Guide - React TypeScript client with shadcn/ui framework, Vite build tool, and MCP server integration. Covers project initialization, development standards, and comprehensive client library usage including API client (createAPI, CRUD operations), Authentication (useLogin, useLogout, useUser), JSON Schema Forms (SchemaForm, FieldArray), Jotai-based State Management (Model, TableModel, useModel hooks), Page Hooks (usePageVar, useDatasourceValue), Real-time Data Subscription (Subscribe, useDataTag, useTableData), and Configuration (setConfig, useMessage)."
effect-v4
by teeverc
"Effect v4 (beta) development and v3 → v4 migration guidance. Use when building new Effect v4 code or upgrading from v3, including API renames, behavior changes, before/after examples, and v4-specific patterns for services, layers, generators, yieldable, error handling, and schema codecs."
goodvibesonly
by JDDoesDev
Security scanner for vibe-coded projects. AUTO-INVOKE this skill before any git commit, git push, or when user says "commit", "push", "ship it", "deploy", "is this safe?", "check for security issues", or "goodvibesonly". Also invoke after generating code that handles user input, authentication, database queries, or file operations.
easy-query-expert
by cc123hh
Guidance for Easy-Query ORM (Java), covering type-safe proxy queries, implicit joins, and tracking updates.
content-ops
by cwyhkyochen-a11y
Social media content operations automation system with SQLite database. Supports content crawling, curation, publish tasks, unified dispatch, and X API publishing with OAuth/token refresh.
database-driver-design
by Joannis
'Expert guidance on building Swift database client libraries. Use when developers mention: (1) building a database driver, (2) wire protocol implementation, (3) connection pooling design, (4) state machines for protocol handling, (5) NIO channel handlers for databases, (6) backpressure in result streaming, (7) actor executor alignment with NIO.'
postgres
by Joannis
'Expert guidance on using PostgreSQL with Swift. Use when developers mention: (1) PostgreSQL or Postgres in Swift, (2) postgres-nio library, (3) SQL queries in Swift, (4) PostgreSQL connection pooling, (5) prepared statements, (6) type-safe database access, (7) bulk loading or COPY FROM, (8) PostgresClient or PostgresConnection.'
joi
by damusix
"Use when building joi schemas, validating input data, defining custom types, conditional validation with .when(), cross-field references, custom error messages, or writing joi extensions. Standalone package that integrates with the @hapi ecosystem."
json-schema-validator
by dkyazzentwatwa
Validate JSON data against JSON Schema specifications. Use for API validation, config file validation, or data quality checks.