Home / data
Data
Six skills for data and API work: SQL query review, schema migration planning, CSV profiling, JSON Schema inference from samples, regex building with test cases, and OpenAPI 3 contract review.
Install
In Claude Code, add the marketplace and install the plugin:
/plugin marketplace add basitalisandhu/claude-skills
/plugin install data@claude-skills
Or copy the skill files into ~/.claude/skills/ from a clone:
git clone https://github.com/basitalisandhu/claude-skills
cd claude-skills
python3 install.py --user --only data
Skills
| Skill | What it does | Scripts |
|---|---|---|
| api-contract-review | Review an OpenAPI 3.x spec (openapi.yaml or JSON) for consistency, versioning, error responses and client friendliness after a bundled script lints it: missing operationIds, undeclared path parameters, responses without schemas, http servers, missing security schemes, dangling components, naming. | yes |
| csv-profiler | Profile a CSV or TSV file with a bundled script (column types, nulls, distinct counts, ranges, candidate keys, ragged and duplicate rows, mixed types, whitespace) and turn it into import decisions: column types for a table, cleaning steps and validation rules. | yes |
| json-schema-author | Write a JSON Schema (draft 2020-12) for an API payload, config file, webhook or event: a bundled script infers a draft from sample documents (types, required fields, nullability, formats, enums, bounds), then it is tightened by hand with constraints, descriptions, examples and additionalProperties. | yes |
| regex-builder | Write and test regular expressions that match what they should and nothing else: a bundled script runs a pattern against labelled sample lines, shows each match and captured group, and warns on patterns that can backtrack catastrophically. | yes |
| schema-migration-plan | Plan a database schema migration on a live database as an expand and contract sequence of backwards-compatible, reversible steps that work with the running app version: lock and downtime per step, batched backfills for large tables, rollback. | no |
| sql-query-review | Review SQL queries, ORM-generated SQL and query plans for correctness and performance: injection, implicit casts, NULL logic, non-sargable predicates, missing indexes, N+1 patterns, unbounded result sets, lock contention and transaction scope, using a fixed checklist and EXPLAIN reading notes for PostgreSQL, MySQL and SQLite. | no |
Plugin README
Six skills for data and API work: SQL query review, schema migration planning, CSV profiling, JSON Schema inference, regex building with test cases, and OpenAPI 3 contract review.
Find this when you search for: zero-downtime migration, ReDoS, validate JSON against a schema.
Install
/plugin marketplace add basitalisandhu/claude-dev-skills
/plugin install data@claude-dev-skills
Skills then appear as /data:<skill>. Scripts need Python 3.11 or newer on PATH as python3; they use the standard library only and make no network calls.
Skills
| Skill | Triggers on | Produces |
|---|---|---|
sql-query-review | why is this query slow, review this SQL | checklist findings and plan reading with the fix |
schema-migration-plan | add, rename, drop or change a column on a live table | expand, migrate, contract steps with locks and rollback |
csv-profiler | what is in this file, load this CSV | csv_profiler.py profile, types, cleaning steps, schema |
json-schema-author | validate this JSON, schema from examples | json_schema_infer.py draft, hand-finished schema |
regex-builder | write a regex, why does it not match | regex_tester.py case results, backtracking warnings |
api-contract-review | review the OpenAPI spec, client generator fails | openapi_lint.py findings, contract review |
Tests for every script live in the repository's tests/ directory; run python3 -m pytest -q at the repository root.