Skill UI

A comprehensive guide to reducing expenses on ClickHouse Cloud. Learn advanced techniques for storage optimization (compression, TTL), compute resource tuning (scaling, thread limits), and query efficiency improvements. Use this when managing data budgets or analyzing high ClickHouse billing charges.

A comprehensive skill designed for finance-related information retrieval. It provides dual search capabilities: real-time web searching across multiple engines (Jina, DDG, Baidu) for general market knowledge, and Retrieval-Augmented Generation (RAG) for querying local, proprietary document stores (e.g., daily news). Ideal for financial analysts needing both broad market context and specific internal data insights.

This guide details how to set up and execute large-scale, distributed GPU training jobs on the CoreWeave platform. It covers both single-node multi-GPU setups and multi-node training utilizing PyTorch DDP and Kubernetes resources (A100/H100). This workflow is ideal for fine-tuning large language models (LLMs) or running complex deep learning models that require high-performance, shared-storage compute clusters.

Provides a systematic guide for diagnosing and improving poor search quality in vector databases like Qdrant. This guide covers troubleshooting issues such as low recall, when approximate search degrades, selecting optimal embedding models, and correctly tuning HNSW parameters, quantization, and filtering strategies. Essential for optimizing RAG and semantic search pipelines.

A comprehensive guide for executing core Snowflake data loading workflows. This covers setting up stages (S3, GCS, Azure), defining file formats (CSV, JSON, Parquet), and using COPY INTO for bulk loading. It also details advanced continuous ingestion using Snowpipe, enabling real-time data synchronization from cloud storage into Snowflake tables.

A comprehensive guide detailing the process of migrating data warehouses to Snowflake from major sources like Amazon Redshift, Google BigQuery, or on-premise databases. This resource covers critical steps including schema conversion (handling dialect differences like STRUCT/ARRAY to VARIANT), robust data transfer methods (S3/Cloud Storage, Python/Pandas), data validation techniques (checksums, row counts), and essential SQL syntax translation patterns.

This guide provides a comprehensive method for setting up Snowflake observability. It teaches how to leverage built-in ACCOUNT_USAGE views to monitor critical metrics such as query performance (latency, error rates), credit consumption, and storage growth. Furthermore, it demonstrates how to implement automated alerts for operational issues (e.g., high failure rates, stuck warehouses) and export metrics to external monitoring systems like Grafana or Prometheus.

A high-performance library built on TileDB for scalable ingestion, efficient storage, and retrieval of genomic variant data (VCF/BCF). It supports incremental sample addition, parallel querying across vast genomic regions, and robust data export for population genomics and cohort studies.

This powerful tool compares identical tables across two SQL Server instances (e.g., Production vs. Staging). It efficiently detects missing rows, extra columns, schema drifts, and data mismatches. Leveraging Python and Apache Arrow for fast columnar data transfer, it provides a comprehensive reconciliation report, making it essential for data migration validation and ETL verification.

LiteParse is a fast, open-source tool for local, layout-aware text extraction from PDFs, Office files, and images. It provides structured JSON output with precise bounding boxes and supports OCR, making it ideal for building robust RAG systems, citation grounding, and multimodal agents. All processing is done locally without needing cloud APIs.

A comprehensive tool for extracting YouTube transcripts, searching videos, browsing channels, and monitoring new uploads. It supports detailed transcript analysis, content summarization, and playlist management by leveraging the TranscriptAPI. Ideal for researchers, content strategists, and market analysts who need structured data from video content without downloading files.

This guide demonstrates how to use the pycti Python client to model complex cyber threat intelligence within the OpenCTI platform. It structures threat actors, intrusion sets, campaigns, and TTPs into a unified STIX 2.1 knowledge graph. The skill is essential for correlating fragmented data from multiple sources (IOCs, reports) into a comprehensive, queryable adversary picture, supporting advanced threat hunting and detection engineering.