Exasol Database Skill

Trigger when the user mentions Exasol, exapump, database import/export, CSV/Parquet upload, Exasol SQL, IMPORT INTO, EXPORT INTO, EXA_, or any Exasol database interaction.

Step 0: Establish Connection

Ensure a working exapump profile before proceeding:

1. If the user mentions a specific profile name → test it: exapump sql --profile <name> "SELECT 1" (always place --profile after the subcommand). On success, use --profile <name> on all subsequent commands.
2. Otherwise → test the default profile: exapump sql "SELECT 1".
3. On success → proceed. No further connection setup needed.
4. On failure → run exapump profile list to check available profiles.
   • If profiles exist → present the list and ask the user which to use, then retry with exapump sql --profile <name> "SELECT 1" (always place --profile after the subcommand).
   • If no profiles → tell the user to run exapump profile add default to create one, then retry.
5. Never read or reference the exapump configuration file — it contains credentials.

Routing Algorithm

After the connection is established, determine the task type and load only the references needed: