oracledb

Usage

All scripts can be executed using Node.js. Replace <param_name> and <param_value> with actual values.

Bash: node <skill_dir>/scripts/<script_name>.js '{"<param_name>": "<param_value>"}'

PowerShell: node <skill_dir>/scripts/<script_name>.js '{\"<param_name>\": \"<param_value>\"}'

Note: The scripts automatically load the environment variables from various .env files. Do not ask the user to set vars unless skill executions fails due to env var absence.

Scripts

execute_sql

Executes one read-only SELECT or WITH query by default. The wrapper rejects multiple statements, DDL, DML, transaction control, PL/SQL, CALL, COPY, DO, SELECT INTO, and row-locking queries before starting the database tool.