本文へ移動
cccskills
無料GitHub で公開

exasol-notebook-connector-config

Set up notebook-connector configuration for Exasol AI workflows through the Secrets Python API. Covers secure config store (`scs`) creation, the `AILabConfig` and `StorageBackend` key sources, backend-specific config values such as `db_host_name`, `db_schema`, `storage_backend`, and `huggingface_token`, Python validation, and handoff to downstream notebook-connector skills.

インストール方法を見る

含まれるファイル(6)

  • SKILL.md3.5 KB
  • references/secrets-python.md5.3 KB
  • references/validation.md929 B
  • scripts/setup_onprem.py1.6 KB
  • scripts/setup_saas.py1.3 KB
  • scripts/validate_config.py3.1 KB

SKILL.md(原文)

インストールする前に、エージェントに与えられる指示の中身を確認できます。

Exasol Notebook-Connector Config Skill

Trigger when the user mentions notebook-connector, secure config store, Secrets, configure notebook-connector, set up credentials for TE, set up credentials for TXAIE, first-time notebook-connector setup, or similar setup tasks.

Purpose

This skill establishes the Python-managed secure configuration that later notebook-connector skills depend on.

After configuration is complete:

  • activate exasol-itde for local Docker DB lifecycle
  • activate exasol-notebook-connections for Python DB and BucketFS helper APIs
  • activate exasol-transformers for Transformers Extension setup and usage
  • activate exasol-text-ai for Text AI Extension setup and usage
  • activate exasol-bucketfs or exasol-udfs only for deeper BucketFS or SLC work beyond notebook-connector setup

Routing Algorithm

Choose the narrowest path that matches the user request:

  1. Python-based configuration

    • Trigger phrases: Secrets, AILabConfig, StorageBackend, save config in python, notebook cell, script
    • Load: references/secrets-python.md
    • Use scripts from: scripts/
  2. Validation / smoke tests

    • Trigger phrases: check config, verify connection, validate notebook-connector, smoke test
    • Load: references/validation.md
    • Use scripts from: scripts/
  3. Downstream notebook-connector work

    • Trigger phrases: bring_itde_up, open_pyexasol_connection, open_sqlalchemy_connection, open_ibis_connection, open_bucketfs_bucket, initialize_te_extension, initialize_text_ai_extension, deploy_license
    • Hand off to exasol-itde, exasol-notebook-connections, exasol-transformers, or exasol-text-ai after setup validation succeeds

Multiple routes can apply. Load all matching references before responding.

Default Guidance

  • Prefer the Python path when the user wants notebook cells, automation, or agent-generated code.
  • Before handing off to DB helpers, BucketFS helpers, TE, or TXAIE work, run scripts/validate_config.py to confirm the Secrets store is populated for the expected backend.
  • Use AILabConfig as the source of the common key names stored in Secrets.

Validation

After writing or updating config, verify it before handing off to downstream skills:

  • run scripts/validate_config.py

Success signals:

  • the backend resolves to the expected value (onprem or saas)
  • the required setup values for this skill are present in the store so downstream notebook-connector workflows can proceed

Expected failure mode:

  • if required setup values for this skill such as storage_backend, db_schema, backend-specific connection values, or real credentials are missing, or the store still contains template values such as my-db-host or placeholder SaaS IDs/PATs, setup validation should fail until the user replaces them with real values

Safety Rules

  • Do not guess SaaS account IDs, PATs, passwords, or BucketFS credentials.
  • Do not read secrets from config files unless the user explicitly provides them.

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

exasol

無料

Top-level router for Exasol work. Use for any Exasol database, exapump, SQL, BucketFS, extension, integration, UDF, Script Language Container, or Exasol Personal setup task, then route to the narrowest specialized Exasol skill.

日本語の概要は準備中です。原文の説明を表示しています。

exasol-labs/exasol-agent-skills102026年9月25日 更新

Exasol BucketFS file system management via the `exapump bucketfs` CLI. Covers listing, uploading, downloading, and deleting files and directories in BucketFS, the `bfsdefault` service and other bucket services, bucket structure, `bfs_*` profile settings, the `/buckets/<service>/<bucket>/<path>` UDF path, and staging JARs, models, and Script Language Containers for UDFs.

日本語の概要は準備中です。原文の説明を表示しています。

exasol-labs/exasol-agent-skills102026年9月25日 更新

Use Exasol Cloud Storage Extension workflows for moving structured object-storage files through extension UDFs. Covers setup prerequisites, the fixed `CLOUD_STORAGE_EXTENSION.IMPORT_PATH` and `CLOUD_STORAGE_EXTENSION.EXPORT_PATH` entrypoints used with `FROM SCRIPT` and `INTO SCRIPT`, Parquet, Avro, ORC, and Delta files on S3, Google Cloud Storage, Azure Blob Storage, Azure Data Lake, HDFS, and Alluxio, connection-object credential patterns, and routing away from native IMPORT or EXPORT when the extension path is the right fit.

日本語の概要は準備中です。原文の説明を表示しています。

exasol-labs/exasol-agent-skills102026年9月25日 更新

Exasol database interaction via the exapump CLI and Exasol SQL. Covers SQL queries and DML/DDL such as `SELECT`, `INSERT`, `UPDATE`, `DELETE`, `MERGE`, `CREATE TABLE`, `ALTER TABLE`, and `DROP TABLE`, `CREATE CONNECTION` connection objects without import or export intent, schema inspection, table design, `exapump sql` and `exapump profile`, query profiling, analytics, and Exasol-specific SQL behavior outside exasol-import and exasol-export.

日本語の概要は準備中です。原文の説明を表示しています。

exasol-labs/exasol-agent-skills102026年9月25日 更新

Distributed machine learning, data mining, and iterative HPC with Exasol. Covers end-to-end ML pipelines (DISTRIBUTE BY + SET scripts + BucketFS), per-entity federated training with partial_fit and ctx.reset(), batch inference, map-reduce ensemble training, distributed ensemble and SON algorithm for frequent itemset mining (Apriori, FP-Growth, association rules, market-basket analysis), Lua execute script orchestration for iterative algorithms (k-means, SGD, gradient descent), scikit-learn model training, parallel hyperparameter search, per-entity forecasting, anomaly detection, model lifecycle in BucketFS (pickle/joblib/ONNX versioning), GPU acceleration via CUDA SLCs (PyTorch/TensorFlow/RAPIDS), and ML-specific performance tuning (skew, OOM, multi-pass chunking).

日本語の概要は準備中です。原文の説明を表示しています。

exasol-labs/exasol-agent-skills102026年9月25日 更新

Use Exasol document-file virtual schemas for federated read-only access to object and file storage — S3, Google Cloud Storage, Azure Blob Storage, and Azure Data Lake Storage Gen2 document files. Covers document-file adapter family selection, the EDML `MAPPING` definition, `CREATE VIRTUAL SCHEMA` usage, refresh workflows, and query-side troubleshooting.

日本語の概要は準備中です。原文の説明を表示しています。

exasol-labs/exasol-agent-skills102026年9月25日 更新

exasol-labs のスキルをすべて見る

このスキルの問題を報告する