chaterm's skills equip an AI agent for database and server administration, with the most popular ones covering SQL query optimization for MySQL and PostgreSQL through EXPLAIN plans, index design and slow query analysis. Other skills address Google Cloud resource management with gcloud and gsutil, VPN setup with WireGuard, OpenVPN and strongSwan, SSL/TLS certificate handling with OpenSSL and Let's Encrypt, and Linux kernel tuning. Their work also includes MySQL operations and Kubernetes Deployment management, giving the collection a strong focus on infrastructure reliability and performance.
Terminal Skills
62 skills · 59 stars · Apache-2.0
Aliyun Cli 阿里云 CLI 操作
Ansible Writes and runs Ansible automation including ad-hoc module commands, static and dynamic inventory su
Apache Apache HTTP Server 配置
Audit Linux security auditing: auditd rules and reports (auditctl, ausearch, aureport), auth and journal l
Aws Cli Runs AWS CLI (aws) commands to manage EC2 instances and security groups, S3 buckets and objects, IAM
Azure Cli Operates Microsoft Azure through the az CLI: logs in and switches subscriptions, manages resource gr
Backup Strategy Designs backup strategies with tar, rsync, mysqldump, gzip and AWS CLI S3 sync, covering the 3-2-1 c
Benchmarking Runs performance and load benchmarks using sysbench (CPU, memory, fileio and MySQL oltp tests), fio
Ci Cd Configures CI/CD pipelines for GitHub Actions, GitLab CI and Jenkins, writing YAML workflow files (.
Cloud Backup Backs up files, directories, and MySQL or PostgreSQL dumps to AWS S3, Alibaba Cloud OSS, Azure Blob,
Compose Manages multi-container Docker Compose projects via docker-compose.yml files, covering service defin
Configmap Secret Kubernetes ConfigMap 与 Secret
Configuration OpenClaw 配置管理
Container Ops Docker 容器操作与管理
Cron Manages Linux cron jobs: edits user and system crontab files, /etc/cron.d entries, and /etc/cron.dai
Deployment Kubernetes Deployment 管理
Disaster Recovery 灾难恢复技能,涵盖 RTO/RPO 规划、冷备/温备/热备策略、MySQL(mysqlbinlog 时间点恢复、主从切换)、PostgreSQL(pg_restore、PITR、pg_ctl prom
Dns DNS 配置与排查指南,涵盖 dig、nslookup、host 查询工具,/etc/resolv.conf、/etc/hosts 与 systemd-resolved 本地配置,BIND named
Dockerfile Dockerfile 编写最佳实践
Elasticsearch Elasticsearch 集群管理
File Operations Linux file and directory operations
Firewall Configures Linux firewalls with iptables, firewalld, or ufw, including opening ports, allowing or de
Gcloud Runs gcloud and gsutil commands for Google Cloud: Compute Engine instances, disks and firewall rules
Git Advanced Advanced Git operations for branch management, interactive rebase, squash and fixup, cherry-pick, st
Hardening Hardens Linux systems through sshd_config, sysctl kernel parameters, login.defs and pwquality passwo
Helm Runs Helm CLI workflows for Kubernetes: adding chart repos, installing, upgrading, rolling back and
Image Management Manages Docker images through the docker CLI and Dockerfiles: listing, inspecting, tagging, pulling
Installation Installs OpenClaw, a distributed task scheduling and workflow platform, via Docker Compose, Helm or
Kubectl Basics kubectl 基础操作与常用命令
Load Balancer Configures HAProxy and Nginx load balancing, including haproxy.cfg frontends and backends, TCP and H
Log Analysis Analyzes log files on Linux with tail, grep, ripgrep, awk, sed, sort and uniq, journalctl, and GoAcc
Maintenance OpenClaw 运维与故障修复
Mongodb Covers MongoDB administration with mongosh and the mongodump, mongorestore, mongoexport and mongoimp
Monitoring Covers monitoring and alerting with Prometheus (PromQL queries, prometheus.yml scrape and rule confi
Mysql MySQL 数据库管理与运维
Network Tools Linux network tools and diagnostics
Networking Docker container networking: bridge (default and user-defined), host, none, overlay for Docker Swarm
Nginx Nginx configuration and optimization
Optimize slow SQL queries with EXPLAIN plans and indexes in MySQL and PostgreSQL Find slow queries, read execution plans, and fix the indexes and query patterns that cause them.
Pod Management Kubernetes Pod 管理与调试
Postgresql PostgreSQL 数据库管理
Process Management Linux process management and control
Profiling Profiles Linux processes with perf (CPU sampling, perf stat, perf top), FlameGraph SVG flame charts,
Proxy 代理服务器配置
Redis Manages Redis databases with redis-cli: key and data-type commands (strings, hashes, lists, sets, so
Rsync rsync 文件同步与备份
Service Ingress Kubernetes Service 与 Ingress
Shell Scripting Writes, debugs and reviews Bash shell scripts (.sh files), covering variables, arrays, conditionals,