| name | oracle-connection |
| description | Connect to a source Oracle database for migration to Snowflake using scai CLI. Requires a user-provided Oracle driver (NuGet package). Triggers: oracle, source connection, source database, connect to oracle, add oracle connection. |
Oracle Connection Skill
On Entry
Tell the user:
Setting up Oracle connection — I'll configure and test a connection to your source Oracle database. This requires a driver download on first use.
Prerequisites
- Network access to the Oracle database instance
- Oracle credentials (username/password)
- The
scai CLI installed and available
- The Oracle .NET driver NuGet package (
Oracle.ManagedDataAccess.Core.nupkg) — not the JDBC driver — see Step 1
Required Connection Details
| Parameter | Required | Description |
|---|
-c, --connection | Yes | Friendly name for this connection |
--auth | Yes | Authentication method (standard) |
--host | Yes | Oracle hostname or IP |
--port | No | Port number (default: 1521) |
--service-name | Yes | Oracle service name |
--user | Yes | Oracle username |
--password | Yes | Oracle password (prompted securely) |
--connection-timeout | No | Connection timeout in seconds (default: 30) |
Workflow
Step 1: Provision the Oracle Driver
The required driver is the Oracle.ManagedDataAccess.Core NuGet package. Resolve it by following the canonical bootstrap flow:
Driver bootstrap: see ../references/driver-bootstrap.md with parameters
<dialect>=oracle, <package>=Oracle.ManagedDataAccess.Core, <driver_file>=Oracle.ManagedDataAccess.Core.nupkg,
<cache_dir>=~/.snowflake/scai/drivers/oracle/,
<nuget_url>=https://www.nuget.org/api/v2/package/Oracle.ManagedDataAccess.Core.
That doc walks through cache check → ask-on-miss → user-provided path or download → first SCAI invocation with --driver-path if needed. Follow it silently — don't narrate "the bootstrap flow" or step labels to the user.
Naming guard: the driver is a .NET NuGet package, not a JDBC driver. Refer to it only as "the Oracle driver" or "the Oracle NuGet package" when talking to the user.
For this skill specifically, the first SCAI invocation called out by the bootstrap is the configure tool call in Step 4 below — pass driver_path=<PATH> there if the driver wasn't already cached. The MCP server invokes scai connection test --driver-path <PATH> internally, which seeds the driver cache.
Step 2: Ask How to Provide Credentials
Ask the user:
"I need the following to connect to Oracle:
- Host (hostname or IP)
- Service name
- Username and Password
How would you like to provide these?"
Options:
- Enter manually - Provide values interactively
Step 3: Add the Connection (Manual Entry)
Interactive mode (recommended):
scai connection add-oracle
Inline mode:
scai connection add-oracle \
-c <CONNECTION_NAME> \
--auth standard \
--host <HOST> \
--port 1521 \
--service-name <SERVICE_NAME> \
--user <USERNAME>
Password will be prompted securely.
Step 4: Save and Test Source Connection
This is the "first SCAI invocation" called out as 1e in the bootstrap reference. Use the path resolved in Step 1.
Call the configure tool with source_connection set to <CONNECTION_NAME>. The MCP server runs scai connection test internally and only persists the connection if the test passes.
-
First use (driver not yet cached): also pass driver_path=<PATH_TO_NUPKG>. The first call copies the driver into ~/.snowflake/scai/drivers/oracle/, so every subsequent configure call (in this project or any other) can omit driver_path.
configure(source_connection=<CONNECTION_NAME>, driver_path=<PATH_TO_NUPKG>)
-
Driver already cached: omit driver_path.
configure(source_connection=<CONNECTION_NAME>)
-
On success: the response includes connection_test: ok.
-
On failure: the tool returns an error containing the scai message. Surface it to the user, help them fix the issue, then re-run configure(...). See ./references/REFERENCE.md for detailed troubleshooting.
Common errors:
| Error | Cause | Solution |
|---|
ORA-12154: TNS:could not resolve the connect identifier | Invalid host or service name | Verify host, port, and service name |
ORA-01017: invalid username/password | Wrong credentials | Check username and password |
ORA-12541: TNS:no listener | Listener not running or wrong port | Verify port number and that the listener is running |
Connection timed out | Network/firewall issue | Check VPN, firewall rules, security groups |
Driver not found | Missing or invalid driver_path | Re-download the NuGet package and verify the file path |
CHECKPOINT
Confirm with user:
On Completion
After the CHECKPOINT passes, tell the user:
Connection configured — Successfully connected to Oracle using connection <connection_name>.
Then return to the calling skill.
Security Rules
- NEVER log or display passwords in plain text
- NEVER include passwords in command-line arguments that might be logged
- Use interactive mode to avoid password exposure
Quick Reference
| Action | Command |
|---|
| Check driver cache | List .nupkg/.dll files in ~/.snowflake/scai/drivers/oracle/ (POSIX) or %USERPROFILE%\.snowflake\scai\drivers\oracle\ (Windows) |
| Use existing local driver | scai project defaults set -s <CONNECTION_NAME> --driver-path <PATH_TO_NUPKG> |
| Download driver (macOS/Linux) | curl -L -o Oracle.ManagedDataAccess.Core.nupkg https://www.nuget.org/api/v2/package/Oracle.ManagedDataAccess.Core |
| Download driver (Windows PowerShell) | curl.exe -L -o Oracle.ManagedDataAccess.Core.nupkg https://www.nuget.org/api/v2/package/Oracle.ManagedDataAccess.Core |
| Add connection (interactive) | scai connection add-oracle |
| Add connection (inline) | scai connection add-oracle -c NAME --auth standard --host HOST --service-name SVC --user USER |
| Test connection (first time) | configure(source_connection=NAME, driver_path=<PATH_TO_NUPKG>) |
| Test connection (driver cached) | configure(source_connection=NAME) |
| List connections | scai connection list -l oracle --json |
| Set default | scai connection set-default -l oracle -c NAME |
| Extract code | scai code extract -s NAME --json |
