Guide ScalarDB schema design with partition and clustering key selection.
npx skills add https://github.com/wfukatsu/nexus-architect --skill model-wfukatsu
Please help me install this Agent Skill. Skill: model Source: https://github.com/wfukatsu/nexus-architect/tree/main/skills/model Command: npx skills add https://github.com/wfukatsu/nexus-architect --skill model-wfukatsu
This Skill solves the complex challenge of designing effective ScalarDB schemas, guiding users through partition keys, clustering keys, and indexes with precision and efficiency.
Run the /scalardb:model command to start the schema design wizard.
High-intent search queries and answers about installing and using this skill.
Designing an efficient ScalarDB schema requires selecting partition keys for even data distribution and clustering keys for ordering. This Skill provides an interactive wizard to guide you through entity definition and key optimization based on your access patterns.
Clustering keys in ScalarDB data modeling determine the sort order of records within a partition. This Skill assists in selecting appropriate clustering keys and secondary indexes to optimize query performance without degrading write throughput.
Mapping domain entities to a ScalarDB schema involves defining your entities and their relationships before translation. This Skill helps define these domain relationships and automatically generates the corresponding schema files for ScalarDB.
ScalarDB CRUD API limitations can restrict certain schema design choices and access patterns. This Skill explicitly warns you about these API constraints during the schema generation process to prevent structural mismatches with your application logic.
The best way to generate a schema file for ScalarDB is through a guided step-by-step design process. This Skill acts as an interactive wizard, taking your domain definitions and partitioning logic to output a ready-to-use schema file.
wfukatsuIdentify domain types and apply ScalarDB design patterns for schema design.
wfukatsuDemonstrate ScalarDB CRUD operations using a fluent builder API.
wfukatsuConvert MySQL stored procedures and triggers into ScalarDB Java application code.
zero3041Optimize ClickHouse schema design, query performance, and data ingestion.
