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

Ready to run

npx skills add https://github.com/Snowflake-Labs/cortex-code-migrations --skill extract-code-units

💬 Prompt for ChatGPT / Claude Chat▼

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.