agents-skills

Explains and applies the database normal forms (1NF, 2NF, 3NF, BCNF, 4NF, 5NF) and strategic denormalization, with worked examples in PostgreSQL, MySQL, SQLite, MongoDB, Cassandra, ScyllaDB, and DynamoDB. Use when users ask about normal forms, functional/multivalued/join dependencies, anomalies (insertion/update/deletion), schema design and refactoring, when they need help deciding how far to normalize a schema, or when they want a normalization concept translated into a specific database's modeling idioms (relational tables, MongoDB embedding/referencing, Cassandra/ScyllaDB query-driven tables, DynamoDB single-table design).

Explains and applies the 23 Gang of Four (GoF) design patterns with idiomatic code examples in Python, C, C++, Java, C#, JavaScript, Rust, Go, PHP, and Swift. Use when users ask about design patterns (singleton, factory, builder, observer, strategy, decorator, adapter, etc.), when they need help choosing a pattern for a design problem, when refactoring code toward a pattern, or when they want a pattern example in a specific language.

Explains and applies the object-oriented programming paradigm — classes, the four pillars (encapsulation, abstraction, inheritance, polymorphism), object relationships, SOLID, and design qualities — with idiomatic code examples in Python, C++, Java, C#, JavaScript, PHP, and Swift. Use when users ask about OOP concepts or SOLID principles, when they need help modeling a domain with classes and interfaces, when reviewing or refactoring class hierarchies, or when they want an OOP concept example in a specific language.

Explains and applies {domain, e.g. "the Gang of Four design patterns" / "the 12-factor app principles"} with idiomatic {guidance/examples} in {context, e.g. "Python, Java, Go, and Rust" or "system design"}. Use when users ask about {topic-1}, {topic-2}, {topic-3}, when they need help choosing {an item} for a design problem, when refactoring toward {an item}, or when they want {an item} example in a specific {language/context}.

Use when users ask how to {primary-capabilities}, especially when they need official {Product Name} documentation, exact links, or docs-grounded guidance.

Use when users ask how to install, configure, authenticate, script, filter output, troubleshoot, or run AWS CLI commands for AWS services, including profiles, credentials, SSO, IAM roles, regions, endpoints, JMESPath queries, output formats, pagination, retries, proxies, wizards, aliases, shell completion, or migration from AWS CLI v1 to v2, especially when they need official AWS CLI documentation, exact links, or docs-grounded command guidance.

Use when users ask how to create, model, query, index, secure, scale, stream, replicate, back up, cache, or troubleshoot Amazon DynamoDB tables and items, including partition keys, sort keys, GSIs, LSIs, on-demand or provisioned capacity, DynamoDB Streams, global tables, transactions, TTL, PartiQL, DAX, IAM access, or DynamoDB API behavior, especially when they need official Amazon DynamoDB documentation, exact links, or docs-grounded guidance.

Use when users ask how to create, configure, deploy, scale, network, secure, or troubleshoot Amazon ECS clusters, task definitions, services, and tasks, including Fargate, EC2 launch types, ECS Managed Instances, Service Connect, auto scaling, IAM roles, ECR integration, ECS Anywhere, or capacity providers, especially when they need official Amazon ECS documentation, exact links, or docs-grounded guidance.

Use when users ask how to create, configure, secure, scale, upgrade, network, or troubleshoot Amazon EKS clusters and workloads, including managed node groups, Fargate, EKS Auto Mode, add-ons, IRSA, EKS Capabilities, networking, storage, observability, eksctl, cluster access, or hybrid/Anywhere deployments, especially when they need official Amazon EKS documentation, exact links, or docs-grounded guidance.

Use when users ask how to create, configure, secure, audit, or troubleshoot AWS IAM identities and permissions, including users, groups, roles, policies, trust policies, permission boundaries, IAM Identity Center, STS, MFA, access keys, service-linked roles, IAM Roles Anywhere, Access Analyzer, or cross-account access, especially when they need official AWS IAM documentation, exact links, or docs-grounded guidance.

Use when users ask how to create, configure, deploy, invoke, scale, secure, monitor, or troubleshoot AWS Lambda functions, including runtimes, layers, deployment packages, container images, triggers, event sources, VPC configuration, concurrency, provisioned concurrency, Lambda URLs, permissions, environment variables, or Lambda extensions, especially when they need official AWS Lambda documentation, exact links, or docs-grounded guidance.

Use when users ask how to create, configure, secure, access, replicate, lifecycle-manage, or troubleshoot Amazon S3 buckets and objects, including storage classes, encryption, bucket policies, ACLs, Block Public Access, presigned URLs, static website hosting, event notifications, replication, S3 Glacier, Mountpoint, or S3 API behavior, especially when they need official Amazon S3 documentation, exact links, or docs-grounded guidance.

Use when users ask how to create, configure, process, schedule, retry, rate-limit, monitor, or troubleshoot BullMQ job queues and workers in Node.js, including queues, workers, jobs, flows, job schedulers, events, telemetry, Redis compatibility, NestJS integration, patterns, or production deployment, especially when they need official BullMQ documentation, exact links, or docs-grounded guidance.

Use when users ask how to install, configure, model, query, index, secure, scale, repair, compact, back up, monitor, or troubleshoot Apache Cassandra clusters and CQL applications, including keyspaces, tables, partition keys, clustering columns, SAI, secondary indexes, replication, compaction, nodetool, cqlsh, vector search, CDC, or the native protocol, especially when they need official Apache Cassandra documentation, exact links, or docs-grounded guidance.

Use when users ask how to build, explain, configure, model, query, secure, test, deploy, migrate, or troubleshoot Django web applications, including models, views, templates, forms, URLconfs, the admin, ORM, migrations, authentication, middleware, REST patterns, async views, caching, or management commands, especially when they need official Django 6.0 documentation, exact links, or docs-grounded Python guidance.

Use when users ask how to install, configure, build, run, network, secure, compose, orchestrate, or troubleshoot Docker containers, images, volumes, networks, registries, Docker Engine, Docker Compose, Buildx, Swarm, or the Docker Engine API, including Dockerfile syntax, Compose file format, CLI flags, daemon configuration, and Docker Desktop, especially when they need official Docker documentation, exact links, or docs-grounded guidance.

Use when users ask how to deploy, index, search, map, secure, scale, monitor, ingest, aggregate, alert on, or troubleshoot Elasticsearch clusters and the Elastic Stack, including Kibana, Query DSL, ES|QL, data streams, ingest pipelines, vector search, machine learning, Elastic Cloud, Fleet, Beats, Logstash, Elastic Security, or Elastic Observability, especially when they need official Elastic documentation, exact links, or docs-grounded guidance.

Use when users ask how to build, explain, configure, route, secure, debug, migrate, or troubleshoot Express.js web applications and APIs, including middleware, routing, error handling, request/response objects, the Router, static files, templates, proxies, performance, security, graceful shutdown, or Express 5 migration, especially when they need official Express documentation, exact links, or docs-grounded JavaScript guidance.

Use when users ask how to build, explain, configure, validate, secure, test, deploy, or troubleshoot FastAPI applications and APIs, including path operations, dependencies, Pydantic models, OpenAPI docs, middleware, background tasks, WebSockets, lifespan events, SQL databases, authentication, or async Python, especially when they need official FastAPI documentation, exact links, or docs-grounded Python guidance.

Use when users ask how to build, explain, configure, extend, validate, test, deploy, or troubleshoot Fastify HTTP servers, including routes, plugins, hooks, decorators, lifecycle, JSON Schema validation, serialization, logging, middleware, TypeScript, serverless, or the @fastify ecosystem, especially when they need official Fastify documentation, exact links, or docs-grounded JavaScript/TypeScript guidance.

Use when users ask how to build, explain, configure, route, secure, test, deploy, or troubleshoot Flask web applications, including blueprints, application factories, request/response objects, templates, sessions, error handling, CLI commands, extensions, WSGI middleware, async views, or production deployment, especially when they need official Flask documentation, exact links, or docs-grounded Python guidance.

Use when users ask how to write, explain, customize, migrate, secure, or troubleshoot GitHub Actions workflows, workflow syntax, triggers, matrices, runners, reusable workflows, artifacts, caching, secrets, OIDC, deployments, custom actions, or Actions Runner Controller, especially when they need official GitHub documentation, exact links, or docs-grounded YAML guidance.

Use when users ask how to write, explain, configure, secure, optimize, or troubleshoot GitLab CI/CD pipelines, `.gitlab-ci.yml` syntax, stages, jobs, runners, variables, inputs, expressions, artifacts, caches, environments, deployments, CI/CD components, parent-child pipelines, merge request pipelines, or pipeline schedules, especially when they need official GitLab documentation, exact links, or docs-grounded YAML guidance.

Use when users ask how to install, configure, query, visualize, alert on, administer, or troubleshoot Grafana and the Grafana Labs observability stack, including Grafana OSS, Grafana Enterprise, Grafana Cloud, dashboards, panels, data sources, Loki, Mimir, Tempo, Pyroscope, Alloy, Beyla, k6, alerting, IRM, SLOs, or OpenTelemetry integrations, especially when they need official Grafana Labs documentation, exact links, or docs-grounded guidance.

Use when users ask how to design, query, mutate, subscribe to, validate, secure, deploy, or troubleshoot GraphQL APIs, including schemas and types, queries and mutations, subscriptions, resolvers, validation, execution, responses, introspection, HTTP transport, authorization, pagination, federation, performance, security, or schema evolution, especially when they need official GraphQL documentation, exact links, or docs-grounded guidance from graphql.org.

Use when users ask how to install, search, deploy, upgrade, rollback, uninstall, template, lint, package, or troubleshoot Helm charts and releases on Kubernetes, including chart development, values, repositories, hooks, plugins, OCI registries, Helm 4 changes, or the Helm Go SDK, especially when they need official Helm documentation, exact links, or docs-grounded guidance.

Use when users ask how to build, explain, configure, tune, secure, operate, replicate, or troubleshoot Apache Kafka clusters and applications, including topics, partitions, producers, consumers, consumer groups, KRaft, brokers, replication, exactly-once semantics, Kafka Connect, Kafka Streams, ACLs, SASL, SSL, tiered storage, monitoring, or upgrading, especially when they need official Apache Kafka 4.3 documentation, exact links, or docs-grounded guidance.

Use when users ask how to install, configure, deploy, scale, secure, network, store, schedule, debug, or troubleshoot Kubernetes clusters and workloads, including pods, deployments, services, ingress, configmaps, secrets, RBAC, kubectl, kubeadm, Helm-adjacent core APIs, autoscaling, jobs, statefulsets, daemonsets, CRDs, or cluster administration, especially when they need official Kubernetes documentation, exact links, or docs-grounded guidance.

Use when users ask how to deploy, connect to, query, model, index, aggregate, secure, scale, back up, monitor, or troubleshoot MongoDB databases and applications, including Atlas, Community Edition, Enterprise Advanced, CRUD, the aggregation framework, search, vector search, transactions, change streams, replication, sharding, drivers, Compass, or data modeling, especially when they need official MongoDB documentation, exact links, or docs-grounded guidance.

Use when users ask how to write, explain, configure, tune, secure, replicate, back up, monitor, or troubleshoot MySQL SQL, schemas, indexes, transactions, users, privileges, InnoDB, replication, Group Replication, InnoDB Cluster, connectors, or server settings, especially when they need official MySQL documentation, exact links, or docs-grounded guidance.

Use when users ask how to build, explain, configure, secure, test, deploy, or troubleshoot NestJS applications, including modules, controllers, providers, dependency injection, middleware, guards, pipes, interceptors, exception filters, configuration, databases, validation, caching, queues, GraphQL, microservices, WebSockets, OpenAPI/Swagger, CLI, or platform adapters (Express/Fastify), especially when they need official NestJS documentation, exact links, or docs-grounded TypeScript guidance.

Use when users ask how to install, configure, proxy, load-balance, secure, reload, or troubleshoot NGINX as a web server, reverse proxy, mail proxy, or TCP/UDP stream proxy, including nginx.conf syntax, server blocks, location matching, upstreams, SSL/TLS, HTTP/2, HTTP/3, QUIC, rewrite rules, rate limiting, caching, FastCGI, WebSocket proxying, njs scripting, or module directives, especially when they need official NGINX documentation, exact links, or docs-grounded guidance.

Use when users ask how to deploy, index, search, map, secure, scale, monitor, ingest, aggregate, or troubleshoot OpenSearch clusters and OpenSearch Dashboards, including Query DSL, vector search, k-NN, ML Commons, Data Prepper, security plugin, index management, ISM, snapshots, clients, or migration from Elasticsearch, especially when they need official OpenSearch documentation, exact links, or docs-grounded guidance.

Use when users ask how to instrument, collect, process, export, or troubleshoot OpenTelemetry traces, metrics, and logs, including language SDKs, the OpenTelemetry Collector, zero-code instrumentation, semantic conventions, OTLP, platforms, security, compatibility, or reference architectures, especially when they need official OpenTelemetry documentation, exact links, or docs-grounded guidance.

Use when users ask how to build, explain, configure, route, secure, test, deploy, or troubleshoot Phoenix web applications and APIs, including routers, controllers, contexts, Ecto, LiveView, channels, plugs, HEEx templates, authentication, PubSub, generators, or Elixir releases, especially when they need official Phoenix documentation, exact links, or docs-grounded Elixir guidance.

Use when users ask how to write, explain, configure, tune, secure, replicate, extend, or troubleshoot PostgreSQL 16 SQL, schemas, indexes, transactions, roles, authentication, backups, replication, monitoring, procedural languages, extensions, or server settings, especially when they need official PostgreSQL documentation, exact links, or docs-grounded SQL and configuration guidance.

Use when users ask how to write, explain, configure, tune, secure, replicate, extend, or troubleshoot PostgreSQL 17 SQL, schemas, indexes, transactions, roles, authentication, backups, replication, monitoring, procedural languages, extensions, or server settings, especially when they need official PostgreSQL documentation, exact links, or docs-grounded SQL and configuration guidance.

Use when users ask how to write, explain, configure, tune, secure, replicate, extend, or troubleshoot PostgreSQL 18 SQL, schemas, indexes, transactions, roles, authentication, backups, replication, monitoring, procedural languages, extensions, or server settings, especially when they need official PostgreSQL documentation, exact links, or docs-grounded SQL and configuration guidance.

Use when users ask how to install, configure, publish to, consume from, cluster, secure, monitor, or troubleshoot RabbitMQ brokers and messaging applications, including AMQP 0-9-1, AMQP 1.0, queues, exchanges, bindings, routing, streams, publishers, consumers, management UI, plugins, or production operations, especially when they need official RabbitMQ documentation, exact links, or docs-grounded guidance.

Use when users ask how to build, explain, configure, tune, secure, scale, monitor, or troubleshoot Redis applications and deployments, including data types, commands, clients, pipelining, transactions, pub/sub, streams, JSON, search, vector search, AI/RAG patterns, clustering, replication, persistence, Redis Open Source, Redis Cloud, Redis Software, or Redis for Kubernetes, especially when they need official Redis documentation, exact links, or docs-grounded guidance.