exasol-itde

name	exasol-itde
description	Use notebook-connector's itde_manager to run a local Docker-based Exasol database. Covers bring_itde_up, get_itde_status, restart_itde, take_itde_down, and how ITDE populates notebook-connector configuration automatically.

Exasol ITDE Skill

Trigger when the user mentions ITDE, docker-db, local Exasol Docker database, bring_itde_up, restart_itde, take_itde_down, or local notebook-connector database setup.

Routing Algorithm

1. Start local Docker DB

   • Trigger phrases: bring_itde_up, start local exasol, docker-db
   • Load: references/itde-lifecycle.md
   • Use scripts from: scripts/

2. Check status / restart / tear down

   • Trigger phrases: get_itde_status, restart_itde, take_itde_down, container status
   • Load: references/itde-lifecycle.md
   • Use scripts from: scripts/

3. Config not present yet

   • Activate exasol-ai-setup

Validation

Use the lifecycle scripts to validate the stored ITDE setup:

• run scripts/check_itde_status.py after setup changes
• after bring_itde_up, expect ItdeContainerStatus.READY
• if the next step is the shared exasol-ai-setup validation flow, save storage_backend=onprem first because bring_itde_up(...) does not populate that key itself
• set db_schema yourself before handing off to schema-dependent workflows such as SQLAlchemy, Ibis, TE, or TXAIE validation
• after teardown, expect ABSENT or a clean no-container state

Expected failure mode:

• scripts/restart_itde.py should raise a runtime error if the Docker-DB container does not exist yet
• shared setup validation can fail with missing storage_backend or db_schema even when ITDE itself is healthy, because those keys are not written by bring_itde_up(...)
• if status checks fail because the store is missing, switch back to exasol-ai-setup

Notes

• ITDE is the easiest local development database path for notebook-connector.
• bring_itde_up populates the secure config store with the generated DB and BucketFS connection details automatically.
• bring_itde_up does not populate storage_backend or db_schema.
• After ITDE is ready, other notebook-connector connection APIs can be used without manual DB/BucketFS entry.