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.

1. 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. Local files (upload CSV/Parquet, export to local files):

• Load: references/exapump-reference.md
• Load: references/import-export.md (decision tree, connection objects)

1. Remote files / bulk loading (S3, Azure, GCS, FTP, HTTP — IMPORT/EXPORT):

• Load: references/import-export.md

1. SQL execution (queries, DDL, DML, schema inspection):

• Load: references/exapump-reference.md (CLI usage)
• Load: references/exasol-sql.md (core SQL behavior)

1. Table design (DISTRIBUTE BY, PARTITION BY, CREATE TABLE layout):

• Load: references/table-design.md

1. Query profiling / performance (slow queries, data skew, REORGANIZE):

• Load: references/query-profiling.md

1. Analytics / window functions (ROW_NUMBER, RANK, LAG/LEAD, QUALIFY, GROUPING SETS):

• Load: references/analytics-qualify.md

1. Virtual Schemas (external data sources, adapter scripts):

• Load: references/virtual-schemas.md

1. BucketFS file management (upload/download/list/delete files in BucketFS, bfsdefault, bucket paths):

• Activate the exasol-bucketfs skill for guidance

1. UDF development (CREATE SCRIPT, ExaIterator, SCALAR/SET, Script Language Containers, SLC, exaslct):

• Activate the exasol-udfs skill for guidance

Multiple routes can apply — load all that match.

1. Before writing any SQL (applies to routes 2–7):

• Always double-quote every identifier (column names, table names, schema names) in SELECT, FROM, WHERE, GROUP BY, ORDER BY, and JOIN clauses — without exception
• This preserves mixed-case names and prevents reserved-keyword errors in a single rule
• Do NOT quote SQL keywords, functions, or aliases — only object identifiers
• If a query fails with a syntax error, fetch the live reserved keyword list: exapump sql "SELECT KEYWORD FROM EXA_SQL_KEYWORDS WHERE RESERVED ORDER BY KEYWORD"

Related Skills

This skill handles core database interaction: connecting, uploading/exporting files, SQL execution, and table design. For BucketFS file management (upload, download, list, delete), the exasol-bucketfs skill provides specialized guidance and will activate automatically when relevant. For UDF development and Script Language Containers, the exasol-udfs skill provides specialized guidance and will activate automatically when relevant.