Skill UI

This skill provides comprehensive expertise for senior database administrators to optimize and manage PostgreSQL databases at an advanced level. Use it for deep query analysis via EXPLAIN ANALYZE, implementing advanced features like JSONB indexing, configuring streaming or logical replication, and maintaining database health through VACUUM tuning and monitoring pg_stat views. Ideal for building highly available, high-performance, and resilient system architectures.

A comprehensive checklist guide for deploying Algolia search services to a production environment. It covers critical steps including index configuration (attributes, ranking), securing API keys (admin vs. search-only), setting up replicas for multiple sort orders, implementing monitoring, and defining graceful degradation/fallback mechanisms. Ideal for go-live and major deployments.

This comprehensive runbook provides detailed procedures for diagnosing and resolving critical incidents within the Glean enterprise search platform. It covers all severity levels (P1-P4) and failure modes, including API outages, connector synchronization failures, indexing backlogs, and permission drift. It includes diagnostic steps, advanced troubleshooting playbooks, and communication templates for technical support and engineering teams.

A comprehensive playbook detailing advanced techniques for post-exploitation security bypass on Linux systems. Covers escaping restricted shells (rbash), evading noexec/read-only filesystems using in-memory execution (DDexec, memfd_create), and circumventing mandatory access controls like AppArmor and SELinux. Essential for penetration testing and red team operations.