Skip to content

davidbirchall/squad-skills-data

v0.1.0

Data engineering skills distinct from general backend work: SQL conventions, data modelling, database migrations, query optimisation, data integrity, search indexing, and data import and export.

squad-skills-data

Data engineering skills distinct from general backend work: SQL conventions, data modelling, database migrations, query optimisation, data integrity, search indexing, and data import and export.

Version 0.1.0, 7 skills.

Install

copilot plugin install ./plugins/data

Skills

SkillPurposeLoad when
data-import-exportStreaming, row-level errors, idempotent imports, CSV injectionBuilding imports or exports
data-integrityConstraints, transactions, idempotency, reconciliation, backups, PIIProtecting data correctness
data-modellingNormalisation, keys, history, multi-tenancy, analytics modellingDesigning schemas
database-migrationsForward-only migrations, expand/contract, batched backfills, lock awarenessChanging a live schema
query-optimisationEXPLAIN, index design, keyset pagination, N+1, statisticsDiagnosing slow queries
search-indexingPostgres full-text vs search engines, sync strategies, reindexingAdding or maintaining search
sql-conventionsNaming, formatting, NULLs, timestamps, parameterised queriesWriting or reviewing SQL

Related plugins

Works well with: backend, shared, platform-engineering. Skills may mention skills from other plugins in a short "See also" note; each skill stands on its own if those plugins are not installed.