Individual skill
explore
Use this whenever you need to know what is actually in a database, warehouse, or DuckDB file before you trust it: inventory, column profiles, PII detection, grain and data-quality problems, verified joins, ER diagrams, ad-hoc SQL probes, segmentation, and the semantic layer a repo declares (dbt, Ossie, SLayer, or Cube). Trigger it on an unmet precondition, not on phrasing: if you are about to write or fix SQL against tables whose columns, types, grain, or join keys you have not verified in this session, use this FIRST. That includes dbt work (building a model, fixing one, debugging wrong numbers) whenever the ticket names source tables without spelling out their schema. It applies mid-task too: on reaching a table you have not inspected, stop and use this rather than guess column names. Also for "what's in my duckdb", "is this data any good", "how do these tables relate". Read-only; writes only the .dex/ cache. It does not author the model: transform does, and maintain reconciles a project that has drifted.
plugins/exmergo/dex/skills/explore/SKILL.md
Source commit d780783eba4ecc7c8b9429f95c9362df95f07c61
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- Yes
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Network or broad shell
- Last checked
- Nov 4, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 1,532
- Repository last updated
- Nov 6, 2026
- License
- Apache-2.0
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- ai-coding Repository topic
- awesome Repository topic
- awesome-list Repository topic
- codex Repository topic
- codex-plugins Repository topic
- openai Repository topic
- codex-skill Repository topic
- codex-skills Repository topic
- marketplace Repository topic
- codex-marketplace Repository topic
- data Derived category
- testing Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 26,331 bytesSKILL.mdcore · 26,331 bytesSKILL.mdcore · 26,331 bytesSKILL.mdcore · 26,331 bytesSKILL.mdcore · 26,331 bytesSKILL.mdcore · 26,331 bytesSKILL.mdcore · 26,331 bytesSKILL.mdcore · 26,331 bytesSKILL.mdcore · 26,331 bytesevals/evals.jsonasset · 13,885 bytesreferences/commands.mddoc · 28,047 bytesreferences/connectors.mddoc · 7,040 bytesreferences/probe-playbook.mddoc · 9,231 bytesreferences/semantic-playbook.mddoc · 17,924 bytesscripts/run.pyruns · 28,333 bytes
Read excerpt
# Explore
Make sense of a warehouse or a local DuckDB database the way an analytics
engineer does: rank what matters, drill selectively, and persist a draft map in
`.dex/`. This skill is read-only: it writes nothing but the `.dex/` cache.
<!-- dex:procedure:begin -->
## Procedure
Dex works in one loop: explore, transform, maintain. `dex <command>` below is
the `dex` CLI; where it is not installed, run the same command through the
skill's `scripts/run.py` wrapper. Each command prints one JSON envelope: read
it and decide the next step from it. Step 1 only reads. Steps 2 to 5 change the
project, so take them only when the task asks for a change; a question about the