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.1.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-reviewLint 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-profilerProfile 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-authorWrite 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-builderBuild, 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-planPlan 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-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.

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.