Skip to content

Standard Skill: Explore a Data Source

Explore a Data Source is a Standard Skill: it profiles a table, or a Data Source table by table, so that you understand its shape, quality and patterns before you ask questions of it. The agent loads it when you meet an unfamiliar table or Data Source, or ask what is in it, whether its data is any good, which columns matter or how its tables join. To pick it yourself, type / and choose explore-a-data-source.

  1. It reads the Semantic Layer first: the Data Model and the Rules and Terms that name the table. The profile checks what they say rather than guessing again, and every place where the data disagrees with an entry is a finding.
  2. It looks at the structure: the tables, the columns and their types, what one row is, and which columns should be unique.
  3. It profiles in the database, with as few aggregating queries as it can, never by fetching whole tables. For a very large table it may sample and says so. Each query says in its question what it checks, because it goes to the Query Log.
  4. It finds quality issues, such as null rates, surprising numbers of distinct values, placeholder and impossible values, duplicate keys and inconsistent formats, and says what each might mean and how sure it is.
  5. It finds relationships: candidate join keys, which it checks by counting rows without a partner and whether the join multiplies rows, and hierarchies such as country, region and city.
  6. It reports an overview, the grain and key, the columns grouped by kind, the issues by severity, the checked joins and three to five analyses worth doing next, often with a Card of one distribution.

When it finds something the Semantic Layer should say, such as a missing Rule or a join the Data Model gets wrong, it suggests a Context Change Request in a sentence or two, but never opens one in this Skill: you decide.

This Skill is adapted from the explore-data Skill of Anthropic’s Data plugin, under the Apache License 2.0. Its folder holds the licence and a notice of what we changed; ask the agent to show you /skills/standard/explore-a-data-source/NOTICE.md.