Autonomous core
Durable state, orchestration, retrieval, skill composition, evaluation, recovery, and learning remain live without a user session.
I kept running into the same architecture. Let the system reason, then make it wait for a person before anything interesting happens. It looks cautious. In practice it turns uncertainty into a queue and calls the queue governance. This is my attempt at a better control plane.
A self-improving migration operating system that can discover, reason about, build, execute, validate, recover, and optimize healthcare data migrations end to end, while proving that each action satisfied its contracts.
This was the first thing I had to get straight. A frequent approval dependency creates latency, diffuses accountability, and eventually becomes ceremonial. So the normal execution graph has no person-shaped node in it.
Agents can form hypotheses, retrieve context, compose skills, generate transformations, and choose experiments. They cannot advance authoritative state or cause effects directly. The deterministic runtime owns that job.
Durable state, orchestration, retrieval, skill composition, evaluation, recovery, and learning remain live without a user session.
PHI-bearing execution, detailed evidence, credentials, and source connectivity stay inside the customer-controlled environment.
The authoritative controller stays outside the target workspace so it can diagnose, pause, repair, or replace impaired workloads.
Not implementation details. Not a transcript. The controller needs different stores for current truth, historical evidence, retrievable knowledge, and evolving capability. Shoving all of that into chat history or one vector database makes recovery and learning feel magical right up until they fail.
| Layer | Stores | Invariant | Technology shape |
|---|---|---|---|
| Authoritative state | Migration, plan, run, wave, resource, checkpoint, lease, budget | Strongly consistent, versioned transitions. No model writes directly. | Relational store + deterministic reducer |
| Event history | Commands, observations, effects, failures, recoveries, model and tool versions | Append-only and reconstructable | Event log + content-addressed artifacts |
| Working context | Current objective, dependencies, recent observations, retrieved contracts | Built per decision, disposable, and provenance attached | Context assembler with strict token and data budgets |
| Project memory | Approved mappings, source behavior, exceptions, decisions, runbooks | Tenant-isolated, versioned, and expiration-aware | Structured facts + documents + retrieval index |
| Skill registry | Capabilities, contracts, evals, permissions, known failure modes | Executable only after certification | Signed packages + benchmark results |
| Learning corpus | Adjudicated outcomes, failures, counterexamples, synthetic cases | No raw cross-tenant PHI. No unverified production feedback. | Curated replay and adversarial corpus |
It is a versioned, testable, permissioned capability with explicit preconditions, effects, evaluation, and recovery. This is how source-specific expertise stays out of the kernel without becoming an ungoverned bag of tools.
No certified skill satisfies the current contracts and state.
Reuse proven subskills before generating a new implementation.
Run golden cases, seeded faults, differential checks, and recovery tests.
Promote inside the meta-contract only when every declared benchmark passes.
Compare predicted and observed behavior. Demote automatically on regression.
Permitted objectives, autonomy limits, data boundaries, risk budget, evidence, and recovery requirements.
globalAuthority, schema, semantics, consistency, CDC, deletes, versions, defects, access, and volume.
connectorCatalog ownership, schema, quality, performance, lineage, retention, and consumer guarantees.
databricksMeaning, terminology, identity, temporal rules, amendments, reversals, and accepted transformations.
healthcarePlan DAG, capabilities, budgets, checkpoints, retry, idempotency, isolation, and rollback.
runtimeGround truth, invariants, tolerances, anomaly handling, evidence, promotion, and demotion thresholds.
truthFluency is cheap evidence. Confidence is worse. If this system is supposed to replace routine, and eventually advanced, data-engineering labor, it needs to beat expert baselines on held-out migrations and seeded failures.
| Capability benchmark | Expert baseline | System must demonstrate | Failure signal |
|---|---|---|---|
| Source discovery | Senior engineer inventory and dependency map | Equal or greater asset and flow recall with fewer unsupported assumptions | Hidden source, consumer, PHI path, or source-of-truth ambiguity |
| Snapshot and CDC | Migration engineer's no-gap design | Exact cutoff proof, deletes, ordering, replay, drift, and restart correctness | Gap, overlap, duplicate logical effect, lost delete, or corrupt checkpoint |
| Transformation | Reviewed production mapping | Schema and semantic equivalence across golden and counterexample corpora | Silent coercion, unit, status, or time change, or unexplained record loss |
| Healthcare identity | MDM steward decisions | Better precision and recall with calibrated abstention on ambiguous merge and split cases | Patient or member conflation, or irreversible unsupported merge |
| Claims reconciliation | Finance and claims control pack | Exact claim, line, billed, allowed, paid, and reversal totals at repeatable cutoffs | Unexplained financial variance |
| Clinical semantics | Clinical informatics review | Correct status, units, terminology, provenance, amendment, and temporal behavior | Patient-safety-relevant semantic divergence |
| Recovery | SRE runbook and rehearsal | Faster deterministic diagnosis, checkpoint recovery, rollback, or forward repair | Unknown write outcome, state divergence, or inability to reconstruct |
| Operational optimization | Platform engineer tuning | Meet correctness and SLA at lower cost and variance without weakening contracts | Regression hidden by aggregate success |
Inventory, profiling, code generation, deployment, test construction, reconciliation, diagnosis, retries, recovery selection, evidence, and optimization when contracts are complete.
Unknown source behavior, mappings, drift, performance, and failure semantics through experiments, differential execution, historical retrieval, and bounded probes.
If two interpretations are observationally equivalent but mean different things to the business, the system cannot discover the intended one. It needs an authoritative contract or it must carry the ambiguity.
Production execution is allowed when a plan compiles against current contracts and the runtime can prove bounded authority, independent evaluation, and a valid recovery strategy. Nothing here says “the model felt confident.”
Read-only discovery, profiling, lineage, telemetry, drift, and hypothesis formation.
Autonomous synthetic or isolated tests, skill synthesis, counterfactuals, and adversarial evaluation.
Production-data mirroring into isolated targets with no downstream authority.
Autonomous bounded production waves, expansion, quarantine, rollback, and recovery.
Autonomous source-of-truth transition when the operating constitution permits it and every declared condition is current. Customer policy can still require manual signoff.
Autonomous skill generation, benchmarking, promotion, and demotion inside an immutable meta-contract. The system cannot quietly rewrite its own constitution.
Wave size grows only when observed correctness, anomaly rate, recovery freshness, cost, and latency stay inside contract. Expansion is an algorithmic state transition, not a calendar milestone.
Unknown state, missing evidence, stale capability, unexplained discrepancy, control-plane partition, or regression triggers bounded retry, isolation, rollback, alternate skill selection, or forward repair.
Databricks can host live services and agents. I still prefer an external controller because it spans source systems, accounts, workspaces, failures, and long-lived migration state. The target cannot be its own only lifeboat.
| Surface | Use | Do not make it |
|---|---|---|
| SDK / REST | Authoritative typed lifecycle control for account and workspace resources | An unbounded generic tool exposed directly to a model |
| Jobs | Bounded extraction, transformation, validation, repair, and rollback stages | The cross-system migration state machine |
| Lakeflow Pipelines | Checkpointed ingestion, streaming, CDC, and declarative transformations | The human and physical task coordinator |
| Unity Catalog | Target access control, governance, lineage, audit, and asset ownership | The only evidence ledger or external-source authority |
| Apps | Workspace-local API and UI, agent service, or custom MCP server | The sole failure-recovery authority |
| Model Serving | Private request-driven model or agent inference | Durable workflow state |
| MCP | Narrow governed retrieval and tool interface for agents | A scheduler, transaction system, or unrestricted mutation API |
| Notebooks / Git folders | Generated artifacts, investigation, and source-controlled implementation | Production orchestration or memory |
| Genie | Read-only migration and operations analytics where useful | A core dependency for correctness |
This matches a literal private-boundary requirement. The control plane, relay, evidence, secrets, models, and detailed context stay customer-side and outside the target workspace failure domain.
This is the preferable commercial topology when outbound signed, PHI-free status and digests are permitted. Detailed execution and credentials remain customer-side.
The first goal is not a demo that generates a notebook. That is a neat trick, not a control plane. The first goal is a complete loop that survives faults, explains itself through evidence, and improves a skill without an approval queue.
Define contracts, task, run, and wave transitions, capability envelopes, budgets, evidence schema, connector protocol, evaluator protocol, and recovery semantics.
Plan, stage, evaluate, restore, and reconstruct the run autonomously. Inject duplicate dispatch, crash-after-write, stale capability, malformed records, missing lineage, and evidence failure.
Detect a capability gap, synthesize a candidate, benchmark it against a fixed corpus, promote it inside the meta-contract, then demote it on an injected regression.
Prove that a new connector changes no scheduler, state, authority, or evidence code. Exercise schema drift, deletes, late events, checkpoint loss, and replay.
Choose payer claims or provider clinical, not both. Add exact standards, semantics, golden cases, expert baseline, anomaly corpus, and acceptance metrics.
Expand authority only from observed evidence. Keep the source read-only and authoritative until the cutover contract becomes true. Demonstrate automatic rollback and forward recovery.
I do not want to copy a sample architecture literally. I want to extract its invariants, capabilities, assumptions, failure behavior, and expert decisions. Those become the migration contract and the skill benchmark.
The architecture is my engineering proposal. The platform and regulatory facts underneath it come from the official material below, reviewed on 20 July 2026.