sql-dynamic-pattern-analyzer

Official

Identify and classify dynamic SQL patterns for seamless migration.

AuthorSnowflake-Labs
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps developers analyze dynamic SQL code, classify patterns, and assess migration complexity when transforming database scripts between platforms.

Core Features & Use Cases

  • Pattern Detection: Recognizes various dynamic SQL patterns like unsafe concatenation, parameter-driven queries, and object name variables.
  • Migration Assessment: Guides users through mapping redshift and SQL Server patterns to Snowflake functions, highlighting potential challenges.
  • Use Case: A database administrator reviews a large stored procedure with dynamic code and determines which parts need refactoring for Snowflake compatibility.

Quick Start

Input your SQL scripts and trigger the analysis to classify dynamic SQL constructs automatically.

Dependency Matrix

Required Modules

None required

Components

referencesscripts

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sql-dynamic-pattern-analyzer
Download link: https://github.com/Snowflake-Labs/cortex-code-migrations/archive/main.zip#sql-dynamic-pattern-analyzer

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.