🔍 Search results for "query-optimization"
Database Mastery
---
name: database-mastery
description: 'Production database mastery — MySQL/MariaDB, PostgreSQL, Redis, backup strategies, replication, and query optimization'
version: 1.0.0
category: devops
tags: [database, mysql, postgresql, redis, mariadb, sql,
Html Css Mastery
---
name: html-css-mastery
category: coding
description: "Production-grade front-end engineering: semantic HTML5, scalable CSS architecture, responsive design, performance optimization, and security hardening."
version: 1.0.0
tags: [html, css, fronte
React Mastery
---
name: react-mastery
category: coding
description: "React mastery: hooks deep dive, state management, component patterns, security, performance optimization, and testing."
version: 1.0.0
tags: [react, hooks, state-management, components, security,
Ai Agent Mastery
### MCP Architecture
```
┌──────────────────────────────────────────────────────────┐
│ MCP Architecture │
│ │
│ ┌──────────────┐ ┌─────────────
Hermes Agent Mastery
Definitive mastery-level skill for Hermes Agent internals, configuration, and operations. Covers architecture, multi-provider LLM routing, gateway ops, skill authoring, cron/background jobs, memory/hi
Lemp Lamp Mastery
```mermaid
sequenceDiagram
C->>N: GET /app.php
N->>N: Location match
alt Static Asset
N-->>C: 200 + file
else PHP Script
N->>FPM: FastCGI :9000
FPM->>DB: Query
DB-->>FPM: Result
FPM-->>N: Respon
Php Mastery
Comprehensive PHP mastery covering modern PHP 8+, OOP & design patterns, security, frameworks, database/ORM, testing, performance, deployment, and production operations.
Python Mastery
Comprehensive Python mastery skill covering architecture, idiomatic code, design patterns, security, testing, performance, and deployment for production-grade Python applications.
Monitoring Observability Mastery
| Pillar | Purpose | Key Tools | Query Language |
|--------|---------|-----------|----------------|
| **Metrics** | Numeric time-series data, aggregation, alerting | Prometheus, Thanos | PromQL |
| **Logs** | Discrete events, debugging context | Loki
Networking Ssl Mastery
### DNS Resolution Flow
```
Browser requests ──→ Local cache ──→ OS cache ──→ Router cache ──→ ISP DNS
│
Recursive query
System Design Mastery
Design scalable distributed systems using structured approaches — load balancing, caching, message queues, databases, and microservices
Terraform Iac Mastery
Infrastructure as Code mastery — Terraform, Pulumi, CloudFormation, and multi-cloud provisioning with state management and GitOps
Openclaw Mastery
Complete mastery of OpenClaw — the open-source AI agent platform. Covers Docker gateway deployment, ClawHub skill ecosystem, browser automation (CamoFox/Patchright/Scrapling), multi-provider LLM confi
Mobile Mastery
Mobile development mastery: Flutter, React Native, cross-platform patterns, security, testing, and deployment.
Nextjs Mastery
Comprehensive Next.js skill covering App Router architecture, rendering strategies, data fetching patterns, security hardening, testing, and production deployment.
Secure Coding
```php
// PHP SAFE ✅
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$userId]);
// PHP UNSAFE ❌
$pdo->query("SELECT * FROM users WHERE id = " . $userId);
```
Ci Cd Mastery
End-to-end CI/CD pipeline mastery — GitHub Actions, GitLab CI, Jenkins, deployment strategies, and release automation
Docker Manager
## When to Use
- User mentions Docker, containers, images, or Dockerfiles
- User wants to containerize an application
- User needs docker-compose orchestration
- User asks about container debugging or optimization
Hermes Skills Upgrade
Full skill library upgrade workflow for Hermes Agent. Audits installed skills, pulls latest from all tracked repos, clones new repos from awesome-hermes-agent curated list, installs missing skills, va
Hermes Webui Install
Install and configure Hermes WebUI (nesquena/hermes-webui) with nginx reverse proxy, SSL, and password auth.
Kanban Orchestrator
Decomposition playbook + anti-temptation rules for an orchestrator profile routing work through Kanban. The "don't do the work yourself" rule and the basic lifecycle are auto-injected into every kanba
Kanban Worker
Pitfalls, examples, and edge cases for Hermes Kanban workers. The lifecycle itself is auto-injected into every worker's system prompt as KANBAN_GUIDANCE (from agent/prompt_builder.py); this skill is w
Kubernetes Mastery
Comprehensive Kubernetes mastery guide covering architecture, core objects, networking, security, Helm, Kustomize, debugging, monitoring, GitOps, and production best practices.
Server Hardening Mastery
Production server hardening — SSH, fail2ban, UFW/iptables, auditd, kernel tuning, intrusion detection, and compliance