ontario-data-mcp: Skill for Claude Code

Refresh Site Examples

Generate real, source-backed examples for the site/index.html landing page. Examples are stored in site/examples.json and fetched at runtime by site/carousel.js. SQL is highlighted by site/sql-highlight.js.

NON-NEGOTIABLE: Factual Correctness

Every number, statistic, and finding on the site MUST be verified by querying real data. Hallucinations = mistrust. This is the #1 rule.

• NEVER write a number you haven't queried from real data
• NEVER use "plausible" or "realistic" numbers — only VERIFIED numbers
• If data can't be queried (XLSX-only, 0 resources, rate-limited), write the finding WITHOUT specific numbers — describe what the query reveals instead
• If a cross-dataset claim can't be verified (e.g. one dataset has no downloadable resources), rewrite to use only verifiable data
• After writing any claim, ask yourself: "Did I run a query that returned this exact number?" If no, delete the number.

When to use

• User asks to update, refresh, add, or replace examples on the site
• User wants new examples for a specific topic or section
• User wants to make examples "real" or add sources

JSON schema

Each example is an object in the array:

{
  "tag": "Time series",
  "question": "Natural language question a person would ask?",
  "answer": "Narrative of what the tool does — dataset name, resource count, analysis technique.",
  "punchline": "The bold finding, verified by real query.",
  "sources": [
    {
      "title": "Exact Dataset Title from get_dataset_info",
      "url": "https://data.ontario.ca/dataset/{slug}",
      "org": "Organization Name from get_dataset_info"
    }
  ],
  "hood": {
    "steps": [
      { "tool": "search_datasets", "description": "dataset_id_first_8_chars" },
      { "tool": "download_resource", "description": "17 CSVs" },
      { "tool": "query_cached", "description": "" }
    ],
    "sql": "SELECT col_name,\n  SUM(TRY_CAST(other_col AS INTEGER)) AS total\nFROM table_name\nGROUP BY col_name\nORDER BY total DESC"
  },
  "followup": {
    "question": "Follow-up question?",
    "answer": "Follow-up narrative.",
    "punchline": "Follow-up finding (if verified).",
    "sources": [{ "title": "...", "url": "...", "org": "..." }]
  }
}