fcakyon/claude-codex-settings / plugins/cloudflare-skills/skills/basin
basin
VerifiedBuild and troubleshoot Cloudflare Basin analytics workflows with Basin Pipelines, Basin Catalog, and Basin SQL. Use for streaming data into R2 Iceberg tables, managing catalogs, or querying those tables; also use for requests using the former Data Platform, Pipelines, R2 Data Catalog, or R2 SQL names.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 2.9 KB |
| references/catalog/README.md | markdown | 1.2 KB |
| references/catalog/api.md | markdown | 3.3 KB |
| references/catalog/configuration.md | markdown | 2.1 KB |
| references/catalog/gotchas.md | markdown | 2.2 KB |
| references/catalog/patterns.md | markdown | 1.7 KB |
| references/pipelines/README.md | markdown | 4.5 KB |
| references/pipelines/api.md | markdown | 5.0 KB |
| references/pipelines/configuration.md | markdown | 6.1 KB |
| references/pipelines/gotchas.md | markdown | 3.0 KB |
| references/pipelines/patterns.md | markdown | 4.6 KB |
| references/skill-feedback.md | markdown | 2.7 KB |
| references/sql/README.md | markdown | 3.4 KB |
| references/sql/api.md | markdown | 4.8 KB |
| references/sql/configuration.md | markdown | 1.7 KB |
| references/sql/gotchas.md | markdown | 2.0 KB |
| references/sql/patterns.md | markdown | 4.3 KB |
references/sql/gotchas.md
View on GitHub# Basin SQL Gotchas
Operational pitfalls. For the authoritative list of supported features, unsupported features, and recommended workarounds, pull `https://developers.cloudflare.com/basin-sql/reference/limitations-best-practices/index.md` and `https://developers.cloudflare.com/basin-sql/troubleshooting/index.md`.
## Access
- **No Workers binding.** There is no `env.R2_SQL`. Query the REST endpoint via `fetch()` from a Worker ([patterns.md](patterns.md#dashboard-worker)), or use D1 / an external DB for OLTP.
- Wrangler needs `WRANGLER_BASIN_SQL_AUTH_TOKEN` — it does **not** reuse the `wrangler login` OAuth session.
- R2 Storage **Admin Read & Write is currently required even for read-only** queries. Verify this in the live authentication docs.
## Type Safety
```sql
-- ❌ wrong -- ✅ right
WHERE status = '200' WHERE status = 200
WHERE ts > '2026-01-01' WHERE ts > '2026-01-01T00:00:00Z' -- need time + tz
WHERE method = GET WHERE method = 'GET'
```
No implicit conversions. Timestamps must be RFC3339 with timezone; dates ISO 8601.
## Performance
- **File count dominates latency** — enable automatic compaction.
- **Partition-filter + narrow time windows + always `LIMIT`.**
- **Multi-way JOINs on large tables** can exceed resource limits — filter heavily, join through dimension tables.
- Per-query `metrics` (`files_scanned`, `bytes_scanned`, `cache_hits`) are the primary observability signal; `bytes_scanned` ≈ billable data. For LIMIT bounds, pagination, and other guidance, see the limitations-best-practices doc.
## Debug Checklist
1. `wrangler basin catalog enable <bucket>` — catalog on?
2. `echo $WRANGLER_BASIN_SQL_AUTH_TOKEN` — token set?
3. `SHOW DATABASES` → `SHOW TABLES IN ns` → `DESCRIBE ns.table`
4. `SELECT COUNT(*) FROM ns.table` — data present?
5. Add filters incrementally; read `metrics` to tune.
## See Also
- [api.md](api.md) · [patterns.md](patterns.md) · [configuration.md](configuration.md)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deployment | Stars: 321k | Updated | Claude CodeCodex | Verified | Install |
| xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved. | Stars: 197k | Updated | Claude CodeCodex | Verified | Install |
| shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |