DIO is a Visual Studio Code extension scaffold for data-driven automation.
Current capability
Upload a single .xlsx file using the command:
DIO: Upload XLSX
Stores the last accepted file path in extension workspace state.
Prompts for one or more project types to generate (currently sqlproj, API sln).
Prompts for one of the user-available Copilot language models.
Uses the selected model to parse the workbook into a normalized domain spec.
Uses deterministic code generation in the extension to scaffold API solutions from the normalized domain spec.
Uses deterministic code generation in the extension to scaffold SQL projects from the normalized domain spec.
For sqlproj, creates a project folder named <xlsx_name>_DB in the workspace, writes <xlsx_name>_DB.sqlproj, and writes one SQL file per table under Tables/ with generated keys and relationships included.
For API sln, creates a solution folder named <xlsx_name>.API in the workspace and writes a Clean Architecture .NET Web API solution where project names follow <solution>.<project> (for example Sales.API.Presentation).
API solution target framework is configurable via setting dio.apiTargetFramework (default: net10.0).
Future capability (not implemented yet)
Generate files from uploaded spreadsheet data.
Development
Install dependencies:
npm install
Build:
npm run compile
Run extension host:
Press F5 in VS Code (Run Extension)
Notes
Generated artifacts are intended as an editable scaffold and should be reviewed before use.
