Skill UI

Cross-database SQL performance optimization assistant offering query tuning, indexing strategies, pagination, batch operations, and monitoring guidance for MySQL, PostgreSQL, SQL Server, Oracle, and other relational systems.

This comprehensive geospatial science skill covers remote sensing, GIS, spatial analysis, and machine learning for Earth observation. It supports satellite imagery processing, vector and raster data operations, spatial statistics, and point cloud processing. Users can utilize cloud-native workflows and 8 programming languages with 500+ code examples. Ideal for terrain analysis, hydrological modeling, and marine spatial analysis tasks.

Guidance and local audit tooling for Python workflows using GeoPandas GeoSeries, GeoDataFrame, spatial operations, and vector data I/O, covering reproducible environments, CRS and antimeridian rules, correctness gates, and privacy safeguards.

Securely inspect and automate microscopy data workflows against OMERO.server using omero-py, BlitzGateway, CLI, tables, annotations, ROIs, rendering, and documented APIs. Support scoped inventory, metadata export, and reviewed write operations.

High-performance genomic interval operations and bioinformatics file I/O on Polars DataFrames. Supports overlap, nearest, merge, coverage, complement and subtract for BED/VCF/BAM/GFF files, with streaming and cloud-native access as a faster bioframe alternative.

A Python library for reading, querying, filtering, and writing genomic file formats including SAM/BAM/CRAM, VCF/BCF, FASTA/FASTQ, and tabix data. Supports pileup, coverage analysis, indexing, and CRAM reference operations with HTSlib integration. Ideal for bioinformatics workflows requiring low-level streaming access to genomic data.

Vaex is a high-performance Python library designed for processing and analyzing large tabular datasets that exceed available RAM. It supports out-of-core DataFrame operations, lazy evaluation, fast aggregations, and efficient visualization of big data. Ideal for working with massive CSV, HDF5, Arrow, or Parquet files, performing statistics on billions of rows, and building machine learning pipelines without memory constraints.

A comprehensive tool for managing annotation datasets, supporting full CRUD operations, label management, and advanced export functionality. It specifically handles COCO format export and facilitates uploading datasets to platforms like Kaggle, streamlining the data pipeline for AI model development.

Provides comprehensive programmatic control over Apify's core data infrastructure, including Datasets, Key-Value Stores, and Request Queues. This skill allows users to perform CRUD operations on various storage types, manage data persistence, and orchestrate complex, multi-stage data pipelines (e.g., scrape -> transform -> export). Ideal for building robust, end-to-end web scraping and data processing automation workflows.

A comprehensive workflow for managing employee lifecycles within BambooHR. This skill enables CRUD operations (Create, Read, Update, Delete) on employee records, synchronizing directory data to external systems, generating custom reports, and interacting with structured tables like job history and compensation. Ideal for building robust HR data pipelines and integrating HR data into external applications.

This comprehensive guide details techniques for optimizing Linktree API integrations in high-traffic, volatile environments. It covers implementing Redis caching strategies, managing rate limits with exponential backoff, and optimizing batch operations and connection pooling to ensure data freshness, reliability, and cost efficiency.

Provides a minimal working example for integrating with the BambooHR API. It demonstrates fetching the complete employee directory, retrieving details for a single employee, and running custom reports. This guide is ideal for users starting new HR system integrations, testing API connectivity, or learning core HR data operations.