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.

Plugin data, version 0.4.1, 6 skills, MIT licence. Source: claude-dev-skills. Synced .

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

SkillWhat it doesScripts
api-contract-reviewReview 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-profilerProfile 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-authorWrite 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-builderWrite 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-planPlan 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-reviewReview 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

SkillTriggers onProduces
sql-query-reviewwhy is this query slow, review this SQLchecklist findings and plan reading with the fix
schema-migration-planadd, rename, drop or change a column on a live tableexpand, migrate, contract steps with locks and rollback
csv-profilerwhat is in this file, load this CSVcsv_profiler.py profile, types, cleaning steps, schema
json-schema-authorvalidate this JSON, schema from examplesjson_schema_infer.py draft, hand-finished schema
regex-builderwrite a regex, why does it not matchregex_tester.py case results, backtracking warnings
api-contract-reviewreview the OpenAPI spec, client generator failsopenapi_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.