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.

This guide details comprehensive detection methods for DCSync attacks (MITRE T1003.006) in Active Directory. Attackers abuse legitimate directory replication protocols to extract sensitive password hashes. Detection relies on auditing Windows Event ID 4662 for unauthorized access attempts to critical Directory Service GUIDs, specifically flagging non-domain-controller accounts attempting replication calls. Essential for threat hunting and incident response.

This guide details how to hunt for DCSync attacks (MITRE ATT&CK T1003.006) in Active Directory environments. It focuses on analyzing Windows Security Event ID 4662, specifically looking for DS-Replication-Get-Changes requests originating from non-domain-controller accounts. This technique is critical for incident response, purple teaming, and detecting unauthorized credential theft via Active Directory replication abuse.

This skill provides a comprehensive audit framework for securing process historian servers (e.g., OSIsoft PI, Honeywell PHD) within industrial Operational Technology (OT) environments. It guides users through assessing network exposure, implementing Purdue Model segmentation, and establishing secure data replication through a DMZ, ensuring process data integrity and preventing unauthorized access.

Provides comprehensive guidance on determining the optimal scaling strategy for Qdrant vector databases. Covers when to transition from vertical to horizontal scaling, how to select the right number of nodes and shards, and best practices for setting replication factors to ensure zero-downtime operation and fault tolerance. Also details proper shard management and common scaling pitfalls to avoid.

Provides comprehensive guidance on upgrading your Qdrant vector database version while ensuring data integrity and maintaining application availability. It covers compatibility rules for major/minor versions, recommends step-by-step migration plans, and details how to perform zero-downtime rolling upgrades using replication factors.

This guide assists in structuring the design of Environmental Science & Technology (ES&T) studies, including lab, mesocosm, field sampling, or modeling experiments. It ensures methodological rigor by planning for environmental relevance, necessary controls (e.g., abiotic loss, sorption), proper replication, mass/energy balance, and a comprehensive QA/QC plan from the outset, helping the study withstand expert peer review.

A comprehensive guide for ensuring robust scientific reproducibility in robotics research (RSS). It structures evidence into distinct 'Replication Tiers' (e.g., Rerunnable, Auditable), distinguishing between the computational half (code, seeds) and the physical half (robot, environment, human protocol). It mandates the use of platform ledgers and raw trial logs to convert claims of trust into verifiable, auditable evidence.

The Azure CLI command group for managing Azure Container Registry (ACR). This tool allows users to perform the entire ACR lifecycle, including creating registries, authenticating credentials, building and pushing container images (using cloud builds), importing images from other sources, and configuring advanced features like geo-replication, private endpoints, and webhooks. Essential for CI/CD pipelines and container deployment workflows in Azure.