Skill UI

This skill manages comprehensive identity verification using the Persona API. It covers government ID checks (passport, driver's license), selfie liveness detection, and database lookups (SSN, watchlist). Use this when implementing Know Your Customer (KYC) workflows, reviewing detailed verification results, or building custom approval logic based on multi-source identity data.

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.

This guide provides comprehensive guidelines for performing vertical scaling on Qdrant instances. Vertical scaling involves upgrading the computational resources (CPU, RAM, or disk) of existing nodes rather than adding new nodes. It is the recommended first step when single nodes experience resource exhaustion (e.g., RAM usage > 80%, CPU saturation). The guide covers sizing guidelines, best practices for cloud deployment, and clearly defines the thresholds when horizontal scaling becomes necessary.

This guide details how to use Shopify Metafields and Metaobjects via the GraphQL Admin API. Metafields allow attaching key-value custom data to existing resources (like products or orders), while Metaobjects enable defining entirely new, structured content types. Together, they provide a powerful way for developers to model complex custom data, often eliminating the need for external databases to extend e-commerce functionality.

This comprehensive guide demonstrates how to establish a robust Continuous Integration/Continuous Deployment (CI/CD) pipeline for Snowflake data warehousing. It integrates SchemaChange for managing version-controlled database migrations, GitHub Actions for automated testing and deployment triggering, and Terraform for provisioning and managing underlying Snowflake infrastructure (databases, warehouses, roles). Use this when setting up reliable, repeatable, and automated deployment workflows.

This guide provides minimal working examples for connecting to Snowflake and executing core SQL operations. It comprehensively covers connection setup, running simple SELECT queries, creating databases and tables, and performing parameterized inserts using both Python and Node.js. It is ideal for initial environment setup, testing the Snowflake SDK, or learning fundamental data warehouse interactions.

This guide details how to configure the VS Code Port Monitor extension. It allows developers to monitor the port status (in use or free) for development servers (like Vite, Next.js) and databases in real time directly on the status bar. Use this skill to set up multi-service or full-stack development environments, prevent port conflicts, and troubleshoot running services.

A comprehensive guide for building high-performance GraphQL servers using Golang. This skill covers everything from choosing between gqlgen and graphql-go, designing robust schemas (nullability, pagination), implementing clean resolver patterns, and critically, preventing N+1 database query issues using DataLoaders. Essential for backend engineers building enterprise-grade APIs.

This router serves as the main entry point for comprehensive injection testing. It helps security professionals classify dangerous input flows—such as XSS, SQLi, SSRF, XXE, etc.—by determining the final sink or interpreter (e.g., browser context, database, XML parser, shell). Use it when unsure which specific injection vector to prioritize.

A comprehensive playbook detailing advanced techniques for bypassing core macOS security features, including TCC, Gatekeeper, SIP, and sandbox restrictions. This guide is essential for authorized red team operations and penetration testing targeting macOS endpoints, covering methods like direct database manipulation, extended attribute removal, and privilege escalation paths.

A comprehensive and advanced playbook for mastering SQL injection techniques. It covers critical areas including WAF bypass, out-of-band data exfiltration, second-order injection, and exploitation strategies across major database systems (MySQL, MSSQL, Oracle, PostgreSQL). Essential for professional penetration testing and security auditing.

Provides essential database abstractions and utility classes for robust API development. This module includes components like FilterUtil, ValueFilter, and ValueFilterRegistry, allowing developers to implement standardized, efficient, and complex data querying and filtering logic across various database contexts.