Skill UI

This skill manages the complexities of Clari API version changes, ensuring smooth transitions (e.g., v3 to v4). It guides developers through detecting schema drift, performing data field compatibility checks, and executing necessary database migrations (SQL/Python), ensuring reliable data pipelines after platform updates.

This comprehensive guide details best practices for securing a ClickHouse deployment. It covers essential security measures including role-based access control (RBAC) for granular user permissions, implementing row-level security for multi-tenancy, configuring network IP restrictions, enabling TLS encryption, and setting up detailed audit logging. Use this when hardening a production ClickHouse instance or enforcing strict data governance.

Conduct comprehensive systematic literature reviews across biomedical and scientific domains using multiple academic databases. Synthesize findings, verify citations, and generate professional markdown or PDF documents. Includes AI-generated scientific schematics for visual enhancement. Ideal for research synthesis, meta-analyses, and thesis writing.

A comprehensive guide for migrating data to, from, and between Notion workspaces. This skill covers complex data pipelines, including rate-limited bulk imports (CSV/JSON), full database exports with pagination, cross-database syncing, and data transformation patterns for integrating content from sources like Confluence and Google Docs. Essential for building robust Notion ETL workflows.

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 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.

A comprehensive guide to implementing production-grade reliability patterns for Snowflake environments. Covers advanced techniques like Time Travel for point-in-time recovery, cross-region database replication, account failover groups for disaster recovery, and application-level resilience coding (e.g., connection failover logic). Essential for building fault-tolerant, highly available data pipelines.

This skill performs a structured Systematic Literature Review (SLR) by analyzing multiple academic papers on a given topic. It searches academic databases (like arXiv), extracts structured metadata (research questions, methodologies, key findings, limitations) from the entire set of papers, and synthesizes overarching themes and research trends. It is ideal for creating comprehensive literature surveys, annotated bibliographies, and cross-paper comparisons, outputting reports in professional citation formats like APA, IEEE, or BibTeX.

Generate data analysis reports by exploring database tables, running multidimensional SQL queries, performing deep attribution analysis, and outputting dynamic HTML visual reports with ECharts for business, trend, and KPI scenarios.

This guide provides a comprehensive workflow for searching and retrieving biomedical literature from PubMed and NCBI. It covers advanced query construction using MeSH terms and specific field tags, advanced filtering (date, publication type), and a repeatable programmatic workflow using NCBI E-utilities (esearch, efetch). Essential for researchers conducting systematic reviews and literature monitoring.

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.)

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.