foundation-worker

You can automate database migrations and TypeScript type generation by defining a structured workflow that creates migration SQL, applies it, and generates corresponding typings for new data models. This ensures backend feature development maintains reliable migration workflows and strong type safety.

The best way to set up Vitest test infrastructure is to bootstrap a ready-to-run testing environment that includes Vitest configuration and a typecheck pass using npx tsc. This guarantees your TypeScript project has reliable test coverage and type safety before feature deployment.

Yes, the workflow supports generating TypeScript type definitions directly from database migrations. It enforces a process where migration SQL creation and application are immediately followed by TypeScript typings generation for new data models, ensuring database schemas and types remain synchronized.

You run a typecheck pass with tsc after setting up test infrastructure by executing npx tsc within the configured project workspace. This validates the generated TypeScript type definitions and ensures strong type safety across your new data models and Vitest testing setup.

You can use this migration workflow for both existing projects and new backend feature development. It applies to any project requiring reliable migration workflows, strong type safety for new data models, and a ready-to-run testing environment using Vitest, regardless of current project age.