rule-engine-search

Find applicable migration rules for Snowflake SQL files using regex and semantic search.

1|1|Updated Apr 15, 2026
One-click install
npx skills add https://github.com/Snowflake-Labs/cortex-code-migrations --skill rule-engine-search
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: rule-engine-search
Source: https://github.com/Snowflake-Labs/cortex-code-migrations/tree/main/plugin/skills/migration/migrate-objects/rule-engine/search
Command: npx skills add https://github.com/Snowflake-Labs/cortex-code-migrations --skill rule-engine-search

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill enables users to find relevant migration rules for SQL files by combining regex pattern matching with semantic search within Snowflake, streamlining database migration workflows.

Core Features & Use Cases

  • Rule Matching: Uses regex patterns to identify specific code patterns in SQL files, allowing deterministic detection of known issues or transformations.
  • Semantic Search: Performs Cortex-powered semantic searches based on code descriptions and structural fingerprints to discover more complex or pattern-based rules.
  • Use Case: A database administrator wants to quickly identify all SQL scripts that contain deprecated syntax or require specific transformations before migration.

Quick Start

Describe the SQL file content and patterns, then run search_rules with the file path and description to get applicable rules.

Frequently Asked Questions about rule-engine-search

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find applicable migration rules for Snowflake SQL files?

To find applicable migration rules for Snowflake SQL files, provide the file path and a description of the content to run search rules. This combines regex pattern matching with semantic analysis to detect relevant code transformations.

What is the best way to detect deprecated SQL syntax before a database migration?

Detecting deprecated SQL syntax before a database migration is best handled by combining regex pattern matching with Cortex-powered semantic search. This approach identifies specific code patterns and structural fingerprints to discover required transformations.

How does semantic search identify SQL code patterns for migration?

Semantic search identifies SQL code patterns for migration by using Cortex-powered analysis on code descriptions and structural fingerprints. This allows the discovery of complex rules beyond deterministic regex matching.

Can I use regex pattern matching to find specific code transformations in SQL scripts?

Yes, you can use regex pattern matching to find specific code transformations in SQL scripts. This provides deterministic detection of known issues and deprecated syntax to ensure migration safety and consistency.

Do I need Snowflake Cortex to perform semantic searches for SQL migration rules?

Yes, performing semantic searches for SQL migration rules requires Snowflake Cortex to analyze code descriptions and structural fingerprints. This enables the discovery of complex or pattern-based rules during the migration process.

How do I ensure migration consistency when transforming multiple SQL files?

To ensure migration consistency when transforming multiple SQL files, apply combined regex and semantic rule matching. This guarantees accurate detection of applicable rules and code patterns across all scripts during review.