84 tagged data modeling, measured the same way as everything else here.
Browse within: data 36database-migrations 36business-intelligence 33data-transformation 33data-visualization 33schema 6migrations 5
Skill Claude CodeCodex
Schema migration strategies for evolving applications including adding new fields, backfilling data, removing deprecated fields, index migrations, and zero-downtime migration patterns.
Skill Claude CodeCodex
Read from a UModel object-graph semantic layer with the umctl CLI (MCP alternative noted). Three kinds of read: (1) entities & relationships / topology (.entity, .topo) and (2) the model itself (.umodel, and .entityset methods, including entity-linked listskills) return real rows; (3) metrics & logs (getmetrics /…
Skill Claude CodeCodex
Model-guided autonomous root-cause analysis over a UModel object-graph semantic layer. Use with umodel-query when diagnosing service degradation, SLO breach, latency/error spikes, incidents, outages, or questions like why a service is slow, degraded, erroring, or timing out. The skill guides evidence collection across…
Skill Claude CodeCodex
Use when an EntitySet exposes listskills, a user requests a UModel or RunbookSet Skill, or an entity task supplies SKILL.md. Triggers: listskills, listknowledge, RunbookSet Skill, UModel Skill, execute skill, run skill, 执行技能, 运行技能, Runbook 技能.
Skill Claude CodeCodex
Cut a Malloy Publisher release, and write the RELEASENOTES.md entries a release ships. Use when asked to release, cut a release, ship a version, or publish Publisher to npm/Docker — and when a change needs a release note, or you are deciding whether it does and what version to stamp on it.
Skill Claude CodeCodex
Build or modify a Malloy Publisher dashboard, a tagged .malloy file in a package's dashboards/ directory, with auto-rendered filter controls, a grid layout, and # drill click-through. Use when the user asks for a dashboard, a filterable operational view, or drill-through between views, and no code is wanted.
Skill Claude CodeCodex
Common Malloy modeling mistakes and how to avoid them. Read BEFORE writing source definitions, dimensions, measures, or joins. Covers reserved words, NULL checks, date functions, type casts, field management (extend except/accept/rename vs include public/internal/private), and query-based source gotchas.
Skill Claude CodeCodex
Guide for designing, building, and maintaining reliable data pipelines.
Skill Claude CodeCodex
Design database schemas, write efficient SQL queries, create migrations, and optimize database performance. Use when working with databases, writing queries, or designing data models.
Skill Claude CodeCodex
Audit concurrency correctness — transaction isolation level, lost-update / read-modify-write races, queue-worker contention (SKIP LOCKED), and idempotency for key-value / document / wide-column writes. Module M14. Feeds the Performance & Scale score.
Skill Claude CodeCodex
Audit connection management — serverless functions opening direct Postgres connections, transaction-mode pooler misuse (PgBouncer / Supabase / prepared statements), and pool sizing against backend maxconnections. Module M15. Feeds the Performance & Scale score.
Skill Claude CodeCodex
Audit data-integrity constraints — missing NOT NULL on required columns, absent CHECK constraints for domain rules, missing UNIQUE on natural keys, and the over-nullable UNIQUE trap where NULLs silently permit duplicates. Module M5. Feeds the Design & Integrity score (Constraints category).
Skill Claude CodeCodex
Schema rules for ERD Studio data model files — the .erd-studio/ directory uses a two-file system (YAML model definitions + JSON domain diagrams) with strict format rules you must read before editing. Use this skill whenever the task touches files in .erd-studio/ (domain JSON, logical-models YAML, or .sync-plan.json)…
JStaRFilms/deprecated-Takomi_Code
Skill Claude CodeCodex
Schema migration strategies for evolving applications including adding new fields, backfilling data, removing deprecated fields, index migrations, and zero-downtime migration patterns.
Skill Claude CodeCodex
Expert-level Power BI, DAX, M language, data modeling, Power Query, report design, and paginated reports.
Skill Claude CodeCodex
Model structured Python data with dataclasses and Pydantic — immutable value objects, validation, serialization, migration between the two.