Skill UI

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.

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.

TileDB-VCF is a high-performance library built on TileDB's sparse array technology, designed for the efficient storage and retrieval of large-scale genomic variant-call data (VCF/BCF). It supports scalable, incremental ingestion of single-sample VCF/BCF files and enables highly efficient parallel querying across vast genomic regions and multiple samples. This tool is essential for building robust population genomics databases, conducting GWAS, and performing large-scale cohort studies.

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 robust GraphQL APIs using Golang. Covers critical best practices including advanced schema design (nullability, pagination, mutations), optimizing resolvers, and preventing N+1 database queries using DataLoaders. Ideal for engineers building high-performance, production-grade backend services.

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.