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 VIR
SKILL.mdplugins/exasol/skills/exasol-jdbc-virtual-schemas/SKILL.md
GitHubExasol 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
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
- Trigger phrases:
Refresh, explain, or troubleshoot a JDBC virtual schema
- Trigger phrases:
EXPLAIN VIRTUALwith JDBC context,ALTER VIRTUAL SCHEMAwith JDBC context,REFRESH TABLES,partial refresh,connection validation,pushdown - Load:
references/jdbc-virtual-schemas.md
- Trigger phrases:
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
- Trigger phrases:
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.