Skill UI

Guides safe OT/ICS vulnerability scanning workflows with Tenable OT Security, combining passive monitoring, native protocol queries, and controlled active checks to avoid disrupting industrial processes while gathering compliance-ready risk data.

Performs proactive threat hunting inside Elastic Security SIEM by crafting KQL/EQL hunting queries, translating findings into detection rules, and using Timelines to investigate anomalies that evade automated alerts.

tRPC allows developers to build highly type-safe APIs in a full-stack environment without needing to write or maintain separate schemas. It provides end-to-end type safety from server routers to client components, supporting queries, mutations, subscriptions, and robust middleware. Ideal for building modern TypeScript monorepos, Next.js, or Remix applications.

polars-bio accelerates genomic interval math and bioinformatics I/O by combining Polars, Arrow, and DataFusion to handle BED/VCF/BAM/GFF/FASTA streams, SQL queries, and cloud storage with overlap, coverage, and nearest APIs plus streaming fallbacks.

Master the use of the `gh` CLI to interact with core GitHub features. This guide covers managing issues, checking Pull Request statuses, listing and debugging CI workflow runs, and executing advanced data queries via the GitHub API. Essential for automating DevOps workflows and debugging CI/CD pipelines directly from the terminal.

A powerful operational companion for database developers. This skill assists with the daily lifecycle of database interactions, including translating natural language requirements into optimized SQL queries, generating database migrations, performing comprehensive schema introspection across multiple dialects (PostgreSQL, MySQL, SQLite, SQL Server), and identifying performance bottlenecks through detailed query optimization and index recommendations. It also supports ORM patterns like Prisma and SQLAlchemy.

Uses AWS Athena to define forensic tables and run queries against CloudTrail, VPC Flow, S3 access, and ALB logs, helping security teams detect unauthorized access, data exfiltration, lateral movement, and privilege escalation during incident investigations.

A comprehensive guide on integrating Firebase Data Connect into Flutter applications. Learn how to define schemas using GraphQL, implement typed queries and mutations, set up real-time listeners, handle offline scenarios, and apply best practices for performance and robust security within a mobile environment.

Guides multi-round investigation of any GitHub repository, combining API queries, discovery searches, and deep dives to produce structured markdown reports with summaries, timelines, metrics tables, and Mermaid diagrams for executive-ready briefs.

A comprehensive guide for writing safe, explicit, and observable database access code in Go. Covers parameterized queries, transaction management, context propagation, connection pooling, and best practices using sqlx/pgx, while strongly advising against using ORMs. Focuses on writing high-integrity, production-grade backend code.

This comprehensive guide covers best practices for building robust database systems. It teaches crucial concepts like schema normalization, effective indexing strategies, selecting the right database (e.g., SQLite vs PostgreSQL) and ORM, and optimizing queries to prevent common performance issues like N+1 problems. It emphasizes making context-aware architectural decisions.

This guide provides comprehensive patterns for migrating Enzyme unit tests to React Testing Library (RTL), especially when upgrading to React 18. It emphasizes the crucial philosophical shift from testing internal implementation details (like state or props) to asserting visible user behavior. Learn best practices for rewriting shallow/mount/simulate calls into modern, accessible, and resilient RTL queries, ensuring your tests reflect how a user genuinely interacts with the component.