skills.rest
Snowflake-Labs
Snowflake-LabsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

extract-code-units

Extract DDL and source code from source databases using command-line tools.

1|1|Updated Apr 15, 2026
Search Tags:#data extraction#SQL#database#migration#oracle#DDL#teradata
One-click install
npx skills add https://github.com/Snowflake-Labs/cortex-code-migrations --skill extract-code-units
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: extract-code-units
Source: https://github.com/Snowflake-Labs/cortex-code-migrations/tree/main/plugin/skills/migration/register-code-units/extract-code-units
Command: npx skills add https://github.com/Snowflake-Labs/cortex-code-migrations --skill extract-code-units

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the challenge of extracting DDL and source code from various source databases, enabling seamless migration preparation.

Core Features & Use Cases

  • Database Object Extraction: Connects to source databases such as Oracle, SQL Server, Teradata, and Redshift to pull tables, views, procedures, functions, and other objects.
  • Flexible Querying: Allows users to specify object types, schemas, and name patterns to extract only relevant data.
  • Use Case: For a migration project, generate DDL scripts for all tables and views in a schema, then review or modify them before deployment in Snowflake.

Quick Start

Ask the user for connection details and object preferences, then specify extraction parameters in plain language to initiate the process.

Frequently Asked Questions about extract-code-units

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

FAQPage Schema
How do I extract DDL and source code from Oracle or Teradata for database migration?▼

To extract DDL and source code for database migration, this tool connects to source systems like Oracle, SQL Server, Teradata, and Redshift using command-line utilities. It pulls tables, views, procedures, and functions to prepare your migration workflow.

Can I filter database object extraction by schema and name patterns?▼

Yes, you can filter database object extraction by specifying object types, schemas, and name patterns. This flexible querying allows you to extract only relevant data from your source database instead of pulling every object.

What is the best way to generate DDL scripts for tables and views before moving to Snowflake?▼

Generating DDL scripts for migration is best handled by extracting tables and views from your source schema. You can specify your object preferences in plain language to initiate the extraction and review the scripts before deploying to Snowflake.

Does this database migration extraction tool support SQL Server and Redshift?▼

Yes, SQL Server and Redshift are supported alongside Oracle and Teradata. The extraction process connects to these source databases to pull database objects, enabling seamless migration preparation across multiple database dialects.

How do I specify extraction parameters for targeted database object retrieval?▼

You specify extraction parameters by providing connection details and stating your object preferences in plain language. The tool translates these inputs into targeted retrieval commands to pull only the specified database objects.

Related Skills

Explore More Software Engineering Skills→
JuanMS20JuanMS20

github-auth

Configure GitHub authentication for Hermes Agent using git, gh CLI, or SSH credentials.

Community
Intermediate
ncksolncksol
1

snowflake-semanticview

Create, alter, and validate Snowflake semantic view DDL via Snowflake CLI.

Community
Advanced
Codecaine-AICodecaine-AI
1

docs-framework

Generate and maintain structured codebase documentation using a three-layer framework.

Official
Advanced
diegoliriodiegolirio

sql-extract-ddl-oracle-mcp

Export Oracle schema DDL via MCP into Flyway-compatible SQL migrations.

Community
Advanced