Installation and Prerequisites

Installation and Prerequisites

This page covers the tools, environment variables, and verification steps needed before running the migration utility.

Required Tools

Tool	Version	Purpose
Claude Code CLI	Latest	Agent runtime that executes all plugin commands
uv	Latest	Python package manager and runner used by every CLI tool
Python	3.11+	Runtime for shared library, MCP server, and CLI tools
gh CLI	Latest	GitHub operations (PRs, branch management, worktree cleanup)
git	2.x+	Version control; worktree support required for batch commands

Required Tools (SQL Server)

Tool	Version	Purpose
FreeTDS	Latest	Open-source ODBC driver for SQL Server connectivity. Install: brew install freetds

Optional Tools

Tool	When needed	Purpose
genai-toolbox (toolbox)	Live SQL Server extraction via /setup-ddl	HTTP-mode MCP server that bridges Claude Code to SQL Server
SQLcl (sql)	Oracle source projects	CLI tool that provides the Oracle MCP server via sql -mcp; requires Java 11+. sql must be on PATH — the plugin invokes it directly. If another sql binary conflicts, override command in your local .mcp.json with the absolute path to the SQLcl binary.
Java 11+	Oracle source projects	Runtime required by SQLcl
direnv	Recommended for all projects	Auto-loads .envrc credentials when you enter the project directory; keeps secrets out of shell history

Environment Variables

The variables required depend on your source technology. The /init-ad-migration command scaffolds a .envrc with only the variables for the selected source.

SQL Server

Variable	Description	Example
MSSQL_HOST	SQL Server hostname or IP	localhost
MSSQL_PORT	SQL Server port	1433
MSSQL_DB	Default database	KimballFixture
SA_PASSWORD	SQL login password	(from env)
MSSQL_DRIVER	(optional) ODBC driver override	FreeTDS (default)

MSSQL_DRIVER defaults to FreeTDS. Set it to ODBC Driver 18 for SQL Server if you prefer the Microsoft driver (requires brew install msodbcsql18 with interactive EULA acceptance).

All four connection variables are required for /setup-ddl, /setup-sandbox, /generate-tests, /refactor, and any other live-database skill.

Oracle

Variable	Description	Example
ORACLE_HOST	Oracle hostname or IP	localhost
ORACLE_PORT	Oracle listener port	1521
ORACLE_SERVICE	Oracle service name	FREEPDB1
ORACLE_USER	Oracle username	sh
ORACLE_PASSWORD	Oracle password	(from env)

Setting variables with direnv (recommended)

The /init-ad-migration command scaffolds a .envrc template containing only the variables for your selected source. Fill in your values and run:

direnv allow

Setting variables manually

Export them in your shell before launching claude:

# SQL Server
export MSSQL_HOST=localhost
export MSSQL_PORT=1433
export MSSQL_DB=KimballFixture
export SA_PASSWORD=<your-password>

# Oracle
export ORACLE_HOST=localhost
export ORACLE_PORT=1521
export ORACLE_SERVICE=FREEPDB1
export ORACLE_USER=sh
export ORACLE_PASSWORD=<your-password>

Python Dependencies

The shared library depends on pydantic, sqlglot, and typer as its key runtime libraries. All Python dependencies (including transitive ones) are managed by uv and pinned in plugin/lib/pyproject.toml. Running uv sync in the plugin/lib directory installs everything needed.

Loading the Plugin

Install from the Vibedata marketplace:

/plugin marketplace add accelerate-data/vibedata-plugins-official
/plugin install ad-migration@vibedata-plugins-official

Alternatively, for local development, load the plugin directly:

claude --plugin-dir plugin/

The ad-migration plugin provides all pipeline commands and skills in a single package.

Verifying Setup

Run the initialization command inside your Claude Code session:

/init-ad-migration

This prompts for source technology selection, then checks every prerequisite silently and presents a status display grouped by source. See Stage 1 Project Init for full details on the status display format and what each check covers.

Next Step

Once verification passes, proceed to the Quickstart for a complete walkthrough.