Skill UI

Automates designing and implementing table partitioning strategies to keep large databases performant, optimize time-series workloads, and shorten maintenance windows, with guidance on key selection, SQL scripts, and query tuning.

A comprehensive utility designed to monitor, analyze, and predict blockchain gas costs across multiple major chains (e.g., Ethereum, Polygon, Arbitrum). It fetches real-time pricing, estimates transaction costs in both ETH and USD, and identifies the optimal time windows for executing DeFi or NFT transactions, ensuring maximum cost efficiency.

This skill guides the process of analyzing Windows Prefetch (.pf) files to reconstruct a detailed program execution history. By parsing these system artifacts, users can determine which applications were run, how many times, and when. It is crucial for building forensic timelines, confirming suspicious binary execution during malware investigations, and localizing evidence in a Windows system.

Analyzes Windows Security EVTX logs to detect Kerberos golden ticket assaults by correlating event IDs 4768, 4624, and 4672, flagging long-lived TGTs, privilege escalations without group changes, SID inconsistencies, and outputting a timeline-based report.

This automated toolkit streamlines memory forensics using the Volatility3 framework. It is designed to analyze raw memory dumps from Windows, Linux, and macOS, revealing complex threats such as process injection, hidden rootkits, malicious code artifacts, and illicit network connections that traditional disk-based methods cannot detect. Essential for real-time incident response and deep security auditing.

A comprehensive guide for resolving complex timezone issues in .NET and C# applications. It provides production-safe patterns for handling location lookups, converting between Windows and IANA timezone IDs, managing Daylight Saving Time (DST), and ensuring cross-platform compatibility. Includes ready-to-use code snippets for TimeZoneInfo, NodaTime, and DateTimeOffset.

This comprehensive guide details advanced strategies for managing time-series data and data retention in vector databases (like Qdrant). It is designed for scenarios where only recent data is relevant (e.g., social media feeds, news articles). Three core methods are presented: Shard Rotation (recommended for natural time boundaries), Collection Rotation (for per-period configuration needs), and Filter-and-Delete (for simple cleanup). The guide also covers hot/cold tiering to optimize performance.

Provides comprehensive guidelines for integrating the Wispr Flow voice-to-text API into development environments. This skill covers both low-latency WebSocket streaming and simpler REST endpoint usage. It is essential for building voice-powered applications, including real-time dictation, command-line interactions, and context-aware code transcription across multiple platforms (Mac, Windows, iOS).

A comprehensive guide to high-performance analytical database patterns using ClickHouse. Covers advanced topics including MergeTree engine types (Replacing, Aggregating), efficient query optimization techniques (filtering, window functions), bulk data insertion strategies, and setting up materialized views for real-time analytics. Ideal for data engineers and analysts building OLAP systems.

A comprehensive guide for red team operators detailing techniques to manipulate, clear, or destroy digital evidence on Windows and Linux systems. Covers clearing Windows Event Logs (wevtutil), manipulating Linux system logs, timestamp forgery, file system scrubbing, and memory artifact removal. Essential for understanding advanced evasion methods and achieving operational security during authorized engagements.

Details comprehensive methods to maintain unauthorized access (persistence) on both Windows and Linux operating systems. Covers registry manipulation, scheduled tasks (schtasks), WMI event subscriptions, cron jobs, systemd timers, and advanced Active Directory abuses. Essential for authorized red team engagements and simulating advanced threat activity.

Use Upstash Redis over HTTP in serverless and edge runtimes with @upstash/redis. Covers client setup, cache-aside with TTLs, sliding-expiration sessions, and 429 rate limiting via fixed window, sliding window, or token bucket.