← ClaudeAtlas

exasol-databaselisted

Exasol database interaction via exapump CLI and Exasol SQL. Covers SQL queries, schema inspection, table design, query profiling, analytics, and Exasol-specific SQL behavior outside exasol-import and exasol-export.
exasol-labs/exasol-agent-skills · ★ 10 · API & Backend · score 72
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