Explore

Name: explore
Author: exmergo

exmergo/dex

Use this whenever you need to know what is actually in a database, warehouse, or DuckDB file before you trust it: ranked inventory of what exists, column profiles, PII detection, grain and data-quality problems, verified join inference, Mermaid ER diagrams, guarded ad-hoc SQL probes, and k-means segmentation, producing a draft map without dumping the whole schema into context. Trigger it on an unmet precondition, not on any particular 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. Th...

★ 24 Synced 1 hour ago View SKILL.md

At a glance

Data & Analytics Manual install Python Actively maintained

This skill is for Data & Analytics and helps you explore a database schema, profile data columns, and detect personally identifiable information.

Install

git clone --depth 1 https://github.com/exmergo/dex
cp -r dex/skills/explore ~/.claude/skills/explore

Can use Not declared by the author

Good for Generate an entity relationship diagram Explore a database schema Profile data columns Detect personally identifiable information Infer table join keys Diagnose data quality problems

Setup, runtime and requirements describe exmergo/dex, the repo this skill ships in.

duckdb sql Data Profiling Pii Detection Erd data-exploration

Also in exmergo/dex

View the repo

Maintain Data & Analytics

Use this to keep a dbt project correct as the warehouse and the business change. It detects drift on four axes and proposes the fix: schema...

Transform Data & Analytics

Use this to author and change a dbt project: bootstrap a project in a repo that has none (`transform init`), write or refactor model SQL fro...

Other Data & Analytics skills

D3 Visualization nexu-io/open-design

Teaches the agent to produce D3 charts and interactive data visualizations. A comprehensive D3.js skill with examples across chart types and...

Eng Runbook nexu-io/open-design

An engineering runbook — service overview, alerts table, dashboards links, common procedures with copy-pasteable commands, on-call rotation,...

Dating Web nexu-io/open-design

A consumer-feeling dating / matchmaking dashboard — left rail navigation, ticker bar of community signals, headline KPIs, a 30-day mutual-ma...

Live Dashboard nexu-io/open-design

Notion-style team dashboard rendered as a Live Artifact. A single-page, self-contained HTML dashboard with KPIs, a 7-day sparkline, a real-t...

Trading Analysis Dashboard Template nexu-io/open-design

Professional trading analysis dashboard template (single-file HTML) with light/dark theme switch, dense market panels, chart interactions, d...

Dashboard nexu-io/open-design

Admin / analytics dashboard in a single HTML file. Fixed left sidebar, top bar with user/search, main grid of KPI cards and one or two chart...