← ClaudeAtlas

exasol-jdbc-virtual-schemaslisted

Use Exasol JDBC-based virtual schemas for federated read-only access to external databases. Covers database-source adapter selection, CREATE VIRTUAL SCHEMA, EXPLAIN VIRTUAL, metadata refresh, and query-side troubleshooting.
exasol-labs/exasol-agent-skills · ★ 10 · API & Backend · score 70
Install: claude install-skill exasol-labs/exasol-agent-skills
# 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 **ex