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 | Lint an OpenAPI 3.x document (YAML or JSON) with a bundled script for missing operationIds, undeclared path parameters, responses without schemas or error cases, servers over http, missing security schemes, unused or dangling components and naming inconsistencies; then review the contract for consistency, versioning and client friendliness. | yes |
| csv-profiler | Profile a CSV or TSV file with a bundled script (column types, nulls, distinct counts, ranges and statistics, candidate keys, ragged and duplicate rows, mixed types, whitespace) and turn the profile into import decisions: column types for a table or schema, cleaning steps and validation rules. | yes |
| json-schema-author | Write a JSON Schema (draft 2020-12) for an API payload, configuration file or event by inferring a draft from sample documents with a bundled script (types, required fields, nullability, formats, enums, bounds) and then hand-finishing it: tightening constraints, adding descriptions and examples, and deciding additionalProperties and versioning. | yes |
| regex-builder | Build, explain and test regular expressions against labelled cases with a bundled script that reports which cases match, the captured groups, and warnings for patterns that can backtrack catastrophically, with timing on adversarial inputs. | yes |
| schema-migration-plan | Plan a database schema change as a sequence of backwards-compatible, reversible migration steps (expand, migrate data, contract) that work with the running application version, with lock and downtime analysis per step, a batched backfill for large tables, and a rollback plan. | 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.
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.