Skill UI

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.

This comprehensive guide details advanced strategies for managing time-series data and data retention in vector databases (like Qdrant). It is designed for scenarios where only recent data is relevant (e.g., social media feeds, news articles). Three core methods are presented: Shard Rotation (recommended for natural time boundaries), Collection Rotation (for per-period configuration needs), and Filter-and-Delete (for simple cleanup). The guide also covers hot/cold tiering to optimize performance.

This guide provides comprehensive guidelines for performing vertical scaling on Qdrant instances. Vertical scaling involves upgrading the computational resources (CPU, RAM, or disk) of existing nodes rather than adding new nodes. It is the recommended first step when single nodes experience resource exhaustion (e.g., RAM usage > 80%, CPU saturation). The guide covers sizing guidelines, best practices for cloud deployment, and clearly defines the thresholds when horizontal scaling becomes necessary.

This guide details how to use Shopify Metafields and Metaobjects via the GraphQL Admin API. Metafields allow attaching key-value custom data to existing resources (like products or orders), while Metaobjects enable defining entirely new, structured content types. Together, they provide a powerful way for developers to model complex custom data, often eliminating the need for external databases to extend e-commerce functionality.

This comprehensive guide demonstrates how to establish a robust Continuous Integration/Continuous Deployment (CI/CD) pipeline for Snowflake data warehousing. It integrates SchemaChange for managing version-controlled database migrations, GitHub Actions for automated testing and deployment triggering, and Terraform for provisioning and managing underlying Snowflake infrastructure (databases, warehouses, roles). Use this when setting up reliable, repeatable, and automated deployment workflows.

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.

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.

This skill acts as a technical translator, helping Product Managers understand complex systems, codebases, APIs, and technical concepts. It goes beyond simply explaining technology by connecting technical details to real-world product implications (the 'so what'). It structures findings into summaries, workings, product impacts, and crucial questions for engineering, ensuring all insights are immediately actionable for product decisions.

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.

This guide outlines robust architectural patterns for building complex administrative extensions within a React environment. It enforces strict separation of concerns by dividing logic into two main layers: Headless Features (business logic, using UseCase/Repository/Gateway) and Presentation Features (UI components, Presenters, and hooks). Following these patterns ensures highly maintainable, testable, and scalable codebases, promoting clean architecture principles for web applications.

This skill generates comprehensive, tailored instruction files for AI coding assistants like GitHub Copilot and Claude. It supports multiple strategies (flat or nested) and is specifically designed for managing complex monorepos by creating area-scoped instructions using `applyTo` globs. Use it to standardize AI tooling usage across large codebases.