All categories
Databases
SQL, NoSQL, schema design, migrations, ORMs, and database operations
- 4,708
- 197
Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.
Open in full browserBrowse databases skills
Showing 3,073–3,096 of 4,708 skills
- Pave EnvSet up local development environments — devcontainers, Docker Compose, one-command setup, dev/prod parity. Use when asked to "set up dev environment", "devcontainer", "docker compose for dev", "local development setup", or "one command to run".Votes: 0GitHub stars: 71
- Lens MetricsProduce a complete metrics definition doc — metric name, formula, data source, segmentation, SQL or event tracking spec, and what good/bad looks like. Given a product area, outputs the full metrics spec. Use when asked to "define KPIs", "metrics framework", "what should we measure", "north star metric", or "instrument this feature".Votes: 0GitHub stars: 71
- Hue TokenAudit or refactor a design token system for color — naming, structure, and coverage. Use when asked to "refactor our color tokens", "fix color token naming", or "improve token coverage for color".Votes: 0GitHub stars: 71
- FluxData engineer — databases, migrations, pipelines, schema design, and query optimization. Use when asked to "design a schema", "write a migration", "build a data pipeline", or "optimize this query".Votes: 0GitHub stars: 71
- Flux SchemaDesign and build database schema — tables, columns, types, indexes, constraints, relationships. Given a domain description, output the schema and write the files. Use when asked to "design schema", "database design", "create tables", or "data model".Votes: 0GitHub stars: 71
- Flux ReconDatabase reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns. Use when asked to "assess this database", "understand the schema", or "database health check".Votes: 0GitHub stars: 71
- Flux QueryOptimize slow database queries — analyze execution plans, add indexes, rewrite queries. Use when asked about "slow query", "optimize SQL", "query performance", or "explain this query".Votes: 0GitHub stars: 71
- Flux MigrateBuild zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence. Use when asked to "write migration", "schema change", "add column", "rename table", "drop column", or "migrate safely".Votes: 0GitHub stars: 71
- Flux HealthData quality and pipeline health check — freshness, schema drift, null rates, orphaned records, pipeline status. Use when asked about "data quality check", "pipeline health", "is our data fresh", or "schema drift".Votes: 0GitHub stars: 71
- Atlas AdrWrite an Architecture Decision Record — document what was decided, why, what alternatives were considered, and what trade-offs were accepted. Use when asked to "write an ADR", "document this decision", or "why did we choose X".Votes: 0GitHub stars: 71
- Drizzle Orm Best PracticesDialect-aware Drizzle ORM conventions for safe query, mutation, and transaction boundaries. Use when writing or reviewing Drizzle schemas, queries, transactions, or raw SQL.Votes: 0GitHub stars: 12
- Review Backend ChangeUse when the user asks for a pre-PR or diff review of backend controllers, APIs, domain services, authorization, tenant context, jobs, transactions, repositories, SQL, ORM or mapper code, schema migrations, constraints, indexes, or backfills. Reviews reachable domain, persistence, and rollout regressions across the full call chain.Votes: 0GitHub stars: 130
- PostgresUse when working with PostgreSQL specifically. Covers indexing, MVCC and vacuum, connection pooling, partitioning, JSONB, replication, and the operational realities that separate Postgres from generic SQL.Votes: 0GitHub stars: 26
- Ddd Domain Interactions设计构造块间的协作机制：领域事件、领域服务、仓储接口与工厂。Votes: 0GitHub stars: 62
- Oracle PrismMulti-perspective analysis — one agent transforms through 5 lenses (Archaeologist, Bug Hunter, Skeptic, Architect, Auditor) inline, no subagents. Use when user says "prism", "oracle-prism", "multi-perspective", "มองหลายมุม", "did we miss anything", "analyze from all angles", or before closing a session/migration/design decision. Presets: --preset retro/design/incident, --lenses N, --custom. Do NOT trigger for adversarial disproving (use /adversarial-analysis) or plain retrospectives (use /rrr).Votes: 0GitHub stars: 120
- Object-Oriented Programming (OOP) SkillDeep dive into all four OOP pillars: Encapsulation, Abstraction, Inheritance, and Polymorphism. Covers design patterns, SOLID principles, real-world examples in Java, Python, and JavaScript, and anti-patterns to avoid.Votes: 0GitHub stars: 3
- Database Schema Generation SkillDesign relational schemas and write versioned migrations for PostgreSQL, MySQL, and SQL Server: keys and constraints, indexes derived from queries, expand → migrate → contract for breaking changes, and the migration tool the project already chose (Flyway, Liquibase, Alembic). Every example here was run against PostgreSQL 17, MySQL 8.4, and SQL Server 2022 on 2026-09-29.Votes: 0GitHub stars: 3
- ADR SkillReusable skill for Engineering Decision Records. Defines the ADR record, its seven-state lifecycle, the ten decision types, ID allocation, and the supersede chain. Owned by architect:adr; read by current_tech_spec_skill, traceability_skill, and quality:observe. Enforced by RULE 11 in instructions/master_instruction_set.md.Votes: 0GitHub stars: 3
- Configure NightwatchConfigures Laravel Nightwatch data collection, sampling rates, filtering rules, and redaction policies. Use when setting up Nightwatch, managing data volume, protecting sensitive data (PII), or optimizing event collection for production workloads.Votes: 0GitHub stars: 717
- Context7E 阶段按需拉取库文档 — 用 ctx7 获取准确 API 信息Votes: 0GitHub stars: 188
- Compound跨 sprint 经验沉淀到 compound/。产生 learning / trick / decision / explore 时触发。Votes: 0GitHub stars: 188
- Athena DevAthena 主入口。收到新任务需要 PACE 路由分诊时触发。Votes: 0GitHub stars: 188
- CompoundCompound Learning Loop. 跨 sprint 积累的经验沉淀到 compound/, 按 doc_type 分文件存档. 4 种 doc_type: learning / trick / decision / explore. v9.6.4 重写 (替代 v9.6.2 单文件 lessons.md). 铁律 13: 一事一档, ≤100 行.Votes: 0GitHub stars: 188
- CompoundCompound Learning Loop. 跨 sprint 积累的经验沉淀到 compound/, 按 doc_type 分文件存档. 4 种 doc_type: learning / trick / decision / explore. v9.6.4 重写 (替代 v9.6.2 单文件 lessons.md). 铁律 13: 一事一档, ≤100 行.Votes: 0GitHub stars: 188