exasol-databaselisted
Install: claude install-skill exasol-labs/exasol-agent-skills
# Exasol Database Skill
Trigger when the user asks for **Exasol database interaction**, **exapump**, **Exasol SQL**, **EXA_** system views, schemas, tables, or query execution outside **exasol-import** and **exasol-export**.
## 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:
1. **SQL execution** (queries, DDL, DML, schema inspection):
- Load: `references/exapump-reference.md` (CLI usage)
- Load: `references/exasol-sql.md` (core SQL behavior)
- Load: `references/exasol-grammar.md` for the **exact statement syntax** (SELECT/DQ