infra: Claude Code ingest/publish skills

[bbest]

Summary

Claude Code skills for systematizing CalCOFI dataset ingestion and publication workflows.

Skills Created

• /explore-dataset — Profile new CSV/ERDDAP datasets before ingestion
• /generate-metadata — Create metadata redefinition files (tbls_redefine.csv, flds_redefine.csv)
• /ingest-new — Scaffold ingest workflow from parameterized template
• /validate-ingest — Post-ingest validation (PKs, FKs, NULLs, ranges, cross-dataset)
• /publish-template — Scaffold publish workflow for OBIS, ERDDAP, or EDI

Templates Created

• ingest_template.qmd — Parameterized ingest notebook
• publish_obis_template.qmd — OBIS Darwin Core Archive
• publish_erddap_template.qmd — ERDDAP NCCSV format
• publish_edi_template.qmd — EDI EML data package

Supporting Files

• scripts/explore_dataset.R — R profiling script for /explore-dataset

Refinement Needed

• Test each skill on DIC dataset (Phase 0+1)
• Refine templates based on DIC experience
• Add R helper functions to calcofi4db if needed