analyze-data-modelAnalyze an existing data layer: entities and relationships, database design quality and the current ER diagram. Runs after analyze.
analyze-uiInventory an existing UI: screens with their inputs, actions and access, components, user tasks, business logic in the view layer, and design tokens. Runs after investigate when there is a UI.
analyzeExtract the ubiquitous language, the actor-role-permission matrix and the domain-to-code mapping from an investigated codebase. Runs after investigate.
build-appBuild a complete ScalarDB application from a domain description: schema, configuration, Java service code and a runnable scaffold.
capture-followupQueue follow-up work found during delivery (deferred tasks, out-of-scope findings, doc drift), then register approved entries as Issues under the Epic.
configGenerate ScalarDB configuration (database.properties, Gradle dependencies) for a backend, edition and interface; also for debugging connection or configuration errors.
create-domain-storyWrite domain stories (Domain Storytelling) per domain, showing business processes as actors, work objects and activities; facilitated or generated. Runs after redesign.
crud-opsScalarDB CRUD API patterns (Get, Scan, Insert, Upsert, Update, Delete) with examples, for writing or reviewing transactional code without SQL.
define-requirementsDefine requirements from documents and an interview: FR/NFR, data and transaction needs, an example map per requirement, ScalarDB / Saga applicability. Greenfield entry point; also takes over product pipeline output.
deliver-backlogDrive each Issue of an Epic through implement, review, human approval and merge, resuming where it stopped and pausing at every human gate.
design-aggregateDesign each bounded context's tactical model with the user: aggregates, entities, value objects, invariants with examples, commands and events, plus the Domain Event Catalog. Runs after redesign.
design-apiWrite the API contract (REST, GraphQL, gRPC or AsyncAPI): named schemas, every status code, RFC 9457 errors, and per-operation authorization, idempotency and timeouts. Runs after design-microservices.
design-data-layerDesign the database layer of a project that does not use ScalarDB: schema, keys, transactions and read models. For ScalarDB projects, use design-scalardb.
design-disaster-recoverySet RTO and RPO, and design backups, failover and recovery procedures.
design-graphqlDesign a schema-first Spring for GraphQL API once design-api chose GraphQL or a hybrid: SDL, resolver contracts, authorization, batching, query limits and transport.
design-implementationWrite coding-ready specs: the API layer (controllers, DTOs, validation), domain services, repository ports and their Fakes, value objects and exception mapping. Runs after the design phase.
design-infrastructureDesign the logical infrastructure: Kubernetes, Terraform, networking and per-environment configuration. For a concrete multi-cloud setup, infra:design follows.
design-microservicesDesign the target microservice architecture and the step-by-step transformation plan from the current system. Runs after redesign.
design-observabilityDesign SLIs and SLOs, monitoring, alerting, distributed tracing and log aggregation.
design-scalardb-analyticsDesign an HTAP analytics platform on ScalarDB Analytics with Apache Spark, a separately contracted Enterprise Option that Premium does not include.
design-scalardbDesign the ScalarDB schema, transaction boundaries and storage backend. ScalarDB projects only; without ScalarDB, use design-data-layer.
design-securityDesign authentication, authorization, secrets, network security and tenant isolation, mapped to the OWASP API Security Top 10.
design-sql-migrationPlan moving an application's SQL to ScalarDB statement by statement: inventory, convert, and decide one route per statement in a validated manifest. Runs after the database investigation and design-scalardb.
design-state-machineModel the lifecycle of aggregates with the user: states, events, guarded transitions, the state x event matrix and each transition's consistency class. Runs after redesign.
docsAnswer ScalarDB / ScalarDL questions that need an authoritative or version-specific source, from the version-pinned knowledge bundle first, then the official docs.
error-handlerWrite or review ScalarDB exception handling with correct retry logic.
estimate-costEstimate cloud infrastructure, ScalarDB licensing and operating costs, with sizing.
estimate-token-costEstimate the tokens and USD cost of running the architect pipeline on a codebase, from its size and any recorded actuals.
evaluate-dddScore how closely an existing system follows DDD, on 12 criteria in 3 layers. Runs after analyze, alongside evaluate-mmi.
evaluate-mmiScore modularity per module with the Modularity Maturity Index: cohesion, coupling, independence, reusability. Runs after analyze, alongside evaluate-ddd.
evaluate-uxEvaluate an existing UI's UX from its inventory: Nielsen heuristics, WCAG 2.2, task efficiency, consistency and navigation, scored with source-cited findings. Runs after analyze-ui.
explainExplain a generated design or code (reports, generated code, UI mocks) from its files, and on request teach the terms, functions and patterns it uses.
export-backlogTurn the reports into Epics, Sub-Epics and Issues on GitLab or GitHub, after a plan the user approves.
generate-acceptance-testsMake the Gherkin scenarios an executable Cucumber-JVM acceptance suite, the outer loop of TDD. Runs after generate-test-specs.
generate-api-codeGenerate the REST API layer from the OpenAPI contract, bound one to one to operationIds: controllers, DTOs, validation, mappers and the RFC 9457 error handler.
generate-characterization-testsPin a legacy system's current behaviour in golden-master tests before a transformation step refactors or strangles it.
generate-contract-testsTurn the API contract into executable tests: schema validation, Problem Details, authorization, idempotency and ArchUnit layering rules.
generate-docsWrite and update READMEs and docs/ pages for generated or implemented code, regenerating only its own marked sections.
generate-graphql-codeGenerate a Spring for GraphQL API layer from the approved SDL and resolver contracts, with authorization, batch loading, query limits and a contract map.
generate-infra-codeGenerate Kubernetes manifests, Terraform, Helm charts and the quality-gate CI workflow as a scaffold under generated/. For merge-bound infrastructure code, use infra:implement.
generate-scalardb-codeGenerate a Spring Boot service on ScalarDB from the design: domain layer, repositories, Fakes, and unit, property and transaction integration tests. ScalarDB projects only.
generate-test-specsSpecify the tests before the code: Gherkin scenarios from the example maps, and contract, unit, property-per-invariant, integration and performance tests. Runs after design-implementation.
implement-backlogImplement a backlog item test-first in the project's real source tree, consistent with its Epic and siblings, and update the docs it changes.
implement-sql-migrationGenerate the code the SQL migration manifest decided (ScalarDB SQL, schema, Core API and application-side code) as a Gradle module behind an offline gate. Runs after design-sql-migration.
designDesign a multi-cloud, four-environment infrastructure: design document, environment matrix and ADRs, no code. Use for "design the infrastructure" or "compare the approaches".
implementWrite Terraform, Kubernetes, Helm, Kustomize and CI definitions from an agreed design into a real infrastructure repository. For a scaffold under generated/, use architect:generate-infra-code.
reviewReview infrastructure code or a design against the platform bundle: ownership overlap, image digest continuity, secret exposure, cloud and environment parity. Use for "review this Terraform".
startEntry point for infrastructure work on AWS, Azure or GCP across local, test, staging and production: fixes the environment and cloud, then routes to design, implement or review. - Bash(${CLAUDE_PLUGIN_ROOT}/tools/update-okf-bundle.sh *) - 'Bash("${CLAUDE_PLUGIN_ROOT}/tools/update-okf-bundle.sh" *)
init-outputCreate the architect output directories and work/pipeline-progress.json for a new project.
integrate-evaluationsMerge the MMI, DDD and, when present, UX evaluations into one prioritized improvement plan.
investigate-db-designInvestigate an existing Oracle, PostgreSQL or MySQL database offline, from DDL, schema exports or design documents: structure, relationships, design findings and an ER diagram. - Bash(python3 ${CLAUDE_PLUGIN_ROOT}/skills/common/database-investigation/scripts/investigate.py design *) - 'Bash(python3
investigate-db-liveInvestigate a live Oracle, PostgreSQL or MySQL database through its catalogs and statistics, read-only, telling unavailable data apart from empty results.
investigate-securityAssess an existing system's security posture: OWASP Top 10, access control and zero-trust readiness.
investigateInvestigate an existing codebase: technology stack, structure, technical debt and DDD readiness. First step of legacy analysis.
jdbc-opsScalarDB SQL/JDBC patterns (SELECT, INSERT, UPSERT, UPDATE, DELETE, JOIN, aggregates) with examples, and what ScalarDB SQL does not support.
local-envSet up ScalarDB locally: docker-compose and commands for a dev backend (PostgreSQL, MySQL, Cassandra, DynamoDB Local). Use for "how do I try ScalarDB on my machine".
map-domainsClassify an existing system's domains (core, supporting, generic), its business structure and service boundary types, and map the relationships between bounded contexts.
merge-issueMerge an approved Issue's PR/MR after preflight (approvals, CI, conflicts) and confirmation, then close the Issue and roll status up.
migrate-databaseMove an existing Oracle, MySQL or PostgreSQL database to ScalarDB: schema analysis, migration documents, stored procedures and triggers converted to Java. Use for any database-to-ScalarDB migration.
migrate-mysqlMySQL-to-ScalarDB migration: schema extraction, analysis, stored procedure and trigger conversion to Java.
analyze-mysql-schemaAnalyzes MySQL database schema and generates a comprehensive Markdown report for sharing. Use when you need to document MySQL schema objects including tables, triggers, stored procedures, views, and object dependencies.
migrate-mysql-sp-trigger-to-scalardbGenerates ScalarDB Java application code from MySQL stored procedures, functions, and triggers. Produces Java Transaction API implementations plus a summary migration report.
migrate-mysql-to-scalardbGenerates ScalarDB migration documentation from MySQL schema analysis. Consumes the MySQL schema analysis Markdown file from the configured output directory as input and produces migration analysis and step-by-step migration guides.
migrate-oracleOracle-to-ScalarDB migration: schema extraction, analysis, AQ integration, stored procedure and trigger conversion to Java.
analyze-oracle-schemaAnalyzes Oracle database schema and generates a comprehensive Markdown report for sharing. Use when you need to document Oracle schema objects including tables, triggers, custom types, PL/SQL code, and object dependencies.
migrate-oracle-aq-to-scalardbGenerates Oracle AQ setup SQL (payload types, queues, enqueue triggers/SPs) and Java consumer files that dequeue messages and process them using the ScalarDB Java Transaction API.
migrate-oracle-sp-trigger-to-scalardbGenerates ScalarDB Java application code from Oracle PL/SQL stored procedures, functions, packages, and triggers. Produces Java Transaction API implementations plus a summary migration report.
migrate-oracle-to-scalardbGenerates ScalarDB migration documentation from Oracle schema analysis. Consumes the Oracle schema analysis Markdown file from the configured output directory as input and produces migration analysis and step-by-step migration guides.
migrate-postgresqlPostgreSQL-to-ScalarDB migration: schema extraction, analysis, stored procedure and trigger conversion to Java.
analyze-postgresql-schemaAnalyzes PostgreSQL database schema and generates a comprehensive Markdown report for sharing. Use when you need to document PostgreSQL schema objects including tables, triggers, custom types, PL/pgSQL code, and object dependencies.
migrate-postgresql-sp-trigger-to-scalardbGenerates ScalarDB Java application code from PostgreSQL PL/pgSQL functions, procedures, triggers, and trigger functions. Produces Java Transaction API implementations plus a summary migration report.
migrate-postgresql-to-scalardbGenerates ScalarDB migration documentation from PostgreSQL schema analysis. Consumes the PostgreSQL schema analysis Markdown file from the configured output directory as input and produces migration analysis and step-by-step migration guides.
migrateAdvise on moving between ScalarDB interfaces: Core and Cluster, CRUD and JDBC, one-phase and two-phase commit. To migrate from another database, use architect:migrate-database.
modelDesign a ScalarDB data model with the user: tables, partition keys, clustering keys and indexes for the access patterns.
pipelineRun every architect pipeline phase in dependency order, unattended, each as a sub-agent; questions are recorded instead of asked.
adapt-changePropagate a change: find the affected artifacts through the traceability graph, confirm them with the user, rerun only those skills and check coherence.
define-data-modelDerive the data model from the UI mocks and features, including implicit entities (joins, history, audit, lifecycle) found through a feature x entity CRUD matrix; outputs an ER diagram.
define-featuresDefine features from the UI mocks, one per screen action, reconciled with scope, prioritized with MoSCoW, and traced to a job, journey stage and metric.
define-nfrTurn SLOs into measurable non-functional requirements (availability, p95/p99 latency, throughput, error rate, durability, RPO/RTO), each traced to its SLO.
define-scopedefine-success-metricsdefine-visiondesign-architecturedesign-positioningdesign-revenuedesign-sladesign-systemexample-mapgenerate-frontendgenerate-personagenerate-ui-mockmap-journeyname-productreport-statusreportresearch-landscapevalidate-assumptionsredesignrender-mermaidreport-backlog-statusreport-token-costreview-api-securityreview-businessreview-codereview-consistencyreview-data-integrityreview-issuereview-operationsreview-reportreview-riskreview-scalardbreview-synthesizerrevise-knowledgescaffoldselect-scalardb-editionupdate-knowledgeverify-implementationverify-sql-migration