跳到正文
cccskills
免费在 GitHub 公开

exasol-jdbc-virtual-schemas

Use Exasol JDBC-based virtual schemas for federated read-only access to external databases such as PostgreSQL, Oracle, MySQL, SQL Server, and DB2. Covers database-source adapter selection, `CREATE VIRTUAL SCHEMA`, `ALTER VIRTUAL SCHEMA`, `EXPLAIN VIRTUAL`, metadata refresh, and query-side troubleshooting.

中文简介正在准备中。当前显示原文说明。

集成工具PostgreSQLMySQL

实测评分 未实测

查看安装方法

包含的文件(2)

  • SKILL.md2.4 KB
  • references/jdbc-virtual-schemas.md5.7 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

Exasol JDBC Virtual Schemas Skill

Use this skill only for JDBC or database-source virtual schemas where Exasol queries external data in place.

Trigger when the user mentions JDBC virtual schema, database-source federation, query external database through a virtual schema, JDBC source adapter, supported JDBC dialect, or EXPLAIN VIRTUAL together with a JDBC/database-source virtual schema context.

Routing Algorithm

  1. Create or query a JDBC virtual schema

    • Trigger phrases: JDBC virtual schema, query external database, database-source virtual schema, JDBC source adapter
    • Load: references/jdbc-virtual-schemas.md
  2. Refresh, explain, or troubleshoot a JDBC virtual schema

    • Trigger phrases: EXPLAIN VIRTUAL with JDBC context, ALTER VIRTUAL SCHEMA with JDBC context, REFRESH TABLES, partial refresh, connection validation, pushdown
    • Load: references/jdbc-virtual-schemas.md
  3. Choose a JDBC adapter family

    • Trigger phrases: supported JDBC dialect, dedicated adapter, PostgreSQL virtual schema, Oracle virtual schema, SQL Server virtual schema, MySQL virtual schema, DB2 virtual schema
    • Load: references/jdbc-virtual-schemas.md

Notes

  • Use this skill for federated access through JDBC/database-source virtual schemas.
  • Use exasol-import or exasol-cloud-storage-extension when the user wants to efficiently bulk-copy data into Exasol instead of querying it in place.
  • Use exasol-export when the user wants to move Exasol data out to another system.
  • Use exasol-virtual-schema-adapter-development when no maintained JDBC dialect fits and the user needs custom dialect code, packaging, or adapter-side debugging.
  • Use exasol-extension-catalog when the source is not clearly JDBC/database-based or the user is still choosing between Virtual Schema, extension, connector, or integration families.
  • Use exasol-bucketfs when the task is specifically about uploading, listing, or removing adapter and driver JARs in BucketFS.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

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年10月14日 更新

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年10月14日 更新

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年10月14日 更新

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年10月14日 更新

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年10月14日 更新

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年10月14日 更新

查看 exasol-labs 的全部技能

报告此技能的问题