Skill UI

This comprehensive guide provides blueprints for implementing optimal Snowflake data architectures. It covers diverse patterns, including traditional data warehouses, Lakehouse designs using Iceberg tables, decentralized Data Mesh structures, and advanced data sharing and Snowpark native patterns. Use this when designing enterprise data platforms across varying scales.

Master the creation of robust ELT (Extract, Load, Transform) data pipelines within Snowflake. This guide demonstrates advanced data orchestration using Snowflake Streams for Change Data Capture (CDC), Tasks for scheduled transformations and DAG management, and Dynamic Tables for declarative, auto-refreshing data models. Ideal for building sophisticated, scalable data warehousing solutions.

This guide provides a comprehensive methodology for load testing and capacity planning within Snowflake data warehouses. It covers optimizing query performance by adjusting warehouse sizes (Scale UP), simulating high concurrency using multi-threading (Scale OUT), and configuring advanced scaling policies (Standard, Economy, Maximized). Users can benchmark critical queries using SQL and simulate real-world user traffic using Python, ensuring robust and cost-efficient production environments.

TileDB-VCF is a high-performance library for scalable storage and retrieval of genomic variant-call data (VCF/BCF). Built on TileDB's sparse array technology, it enables efficient ingestion of large datasets, supports incremental sample additions, and allows for highly optimized parallel queries across genomic regions and multiple samples. Ideal for building population genomics databases, cohort studies, and conducting large-scale association studies.

A comprehensive server providing research-grade access to arXiv. Users can search papers by topic, author, or date, download full texts, and analyze the scientific landscape by traversing citation graphs. It also supports local semantic search over downloaded documents and enables monitoring for new papers with real-time alerts. Ideal for academic research and literature review.

This comprehensive guide covers essential operations for handling PDF documents, including text, table, and metadata extraction using libraries like pdfplumber. It details document creation with reportlab, merging/splitting with pypdf/qpdf, and advanced OCR for scanned PDFs. Ideal for automating complex document workflows and structured data ingestion.

Provides a structured workflow for systematically accessing and analyzing official intellectual property data from the USPTO. This skill covers patent search (PatentSearch API), trademark status checks (TSDR), ownership transfer tracking, and building reproducible IP landscape logs. It is designed for data collection and record verification, emphasizing the use of official APIs and rigorous logging practices. (Warning: Not for legal advice.)

A specialized intelligence tool for comprehensive patent prior-art and landscape analysis. Unlike generic searches, this skill forces commitment to one of five critical sub-use-cases (Novelty Search, Freedom-to-Operate, Competitive Landscape, etc.) before conducting searches across major patent databases (Google Patents, Espacenet, USPTO). It outputs a detailed, editable report containing claim-aware analysis, risk flags, and strategic recommendations.

This powerful router analyzes complex document types (scanned, medical, table-heavy, etc.) and determines the optimal conversion pipeline (tools, flags, cleanup) to extract data into various formats like Markdown, JSON, or DOCX. It goes beyond simple text extraction by prioritizing the preservation of document structure, relational data, and high fidelity, ensuring the generated output is accurate for downstream machine processing.

Nextflow is a powerful workflow language and runtime for building reproducible, portable, and scalable data pipelines. It is dominant in bioinformatics, enabling complex dataflow programming and managing workflows across diverse environments, including local machines, HPC clusters (SLURM), and cloud platforms (AWS, Azure). This skill covers the full lifecycle: running established pipelines (like nf-core), developing custom modular workflows, configuring containerization, and ensuring computational reproducibility.