Backup strategies and disaster recovery across all database engines. Full, incremental, differential backups. PITR (Point-in-Time Recovery). PostgreSQL (pg_dump, pgBackRest, Barman, WAL archiving), MySQL (mysqldump, XtraBackup, Clone Plugin), MongoDB (mongodump, Atlas backup), Redis (RDB, AOF). R...
Full skill instructions
Load from references/ based on what's needed:
Backup types comparison (full/incremental/differential/continuous) with speed and storage tradeoffs. RPO/RTO planning tiers (critical/important/standard/archive) with strategies. PostgreSQL: pg_dump, pg_basebackup, pgBackRest config and commands, Barman. MySQL: mysqldump, XtraBackup (full + incremental + prepare + restore), MySQL Shell dump/load. MongoDB: mongodump with oplog, mongorestore with oplog replay, fsync lock for snapshots. Redis: RDB config, AOF config, hybrid mode recommendation. Load when: implementing backup for a specific database engine.
Automated restore testing bash script with row count comparison and alerting. Backup monitoring checklist (job alerts, size trends, WAL lag, disk space). Cloud-native backup services table (AWS Backup, Cloud SQL, Azure Backup, Atlas). Disaster recovery patterns comparison (backup/restore, pilot light, warm standby, multi-site active). Anti-patterns: untested backups, no encryption, single-region storage, missing retention policy. Load when: setting up backup verification, choosing DR patterns, or reviewing backup compliance.
IoT security practices covering device identity with X.509 and secure elements, secure boot chains, encrypted communication (TLS/DTLS), firmware signing, network segmentation, device attestation, and vulnerability management for resource-constrained devices.
Migration planning expertise including strangler fig pattern, parallel run strategy, data migration techniques, feature parity tracking, rollback plans, phased timelines, risk mitigation, and zero-downtime migration.
State management expertise including local vs global state decisions, Redux Toolkit, Zustand, Jotai, MobX, Context API patterns, server state (React Query, SWR) vs client state, optimistic updates, and state machines with XState.
Terraform and Infrastructure as Code expertise covering HCL module design, state management, workspaces, provider configuration, drift detection, Terragrunt, infrastructure testing, and resource lifecycle management.
Test data management with factory patterns (Faker.js, Fishery, Factory Bot), database seeding, test data isolation (transactions, cleanup), anonymization and masking for production data, synthetic data generation, fixture management, and shared test state risks. Use when designing test data strat...
Flutter 3.27+ patterns — Riverpod 2 state with codegen, GoRouter 14+ navigation, Impeller rendering (default on all platforms), WASM web, extension types, on-device AI (firebase_ai, MediaPipe), Patrol 3.x testing, platform channels, performance
GCP architecture expertise including Google Cloud Architecture Framework, project and organization structure, VPC and networking design, data and analytics architecture, Kubernetes and serverless patterns, AI/ML platform design, security architecture, and cost optimization strategies. Use proacti...
CI/CD test integration: parallel test execution (sharding), test splitting strategies, flaky test quarantine, test reporting (Allure, ReportPortal, JUnit XML), quality gates (coverage thresholds, no new failures), test result caching, and pre-commit hooks. Use when configuring test pipelines, opt...
Monitoring and observability expertise covering Prometheus/Grafana stack, Datadog, CloudWatch, PagerDuty integration, custom metrics, dashboard design using USE/RED methods, alert routing, uptime monitoring, and log aggregation.
Vue.js expertise including Composition API, Pinia state management, Nuxt.js 3, Vue Router, custom directives, provide/inject patterns, transition system, and Volar tooling configuration.
Sets up observability: structured logging, metrics collection, distributed tracing, alerting rules, dashboard design, SLI/SLO/SLA definition. Covers ELK, Prometheus, Grafana, Datadog, OpenTelemetry. Use when implementing monitoring, debugging production issues, or designing observability architec...
Russian language calibration for Billy Milligan agents. Load when session language is RU. Contains native speech patterns, swearing vocabulary, pet name styles, and anchor examples for all 5 agents.
Generate, edit, and beat-sync AI video with leading models in one workspace.
The world's fastest calendar for remote work
Transform Your Design with AI Designer by ImgCreator.ai
Revolutionizing Video Production with AI-Powered Creativity
Extend an image past the frame and let AI fill the new aspect ratio.
Discover your celebrity doppelgänger with StarByFace!
ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.
Opus.ai: Revolutionize Your Web Experience
