So with the latest Power Platform Canvas Apps plugin enabling the fairly smooth experience of vibe coding canvas apps, I was wondering if anyone had built a SharePoint List "database" migration tool to enable easy declarative manifest-driven generation and evolution of SharePoint lists in a SharePoint site.
I've been working on building one myself for work using the SharePoint REST API as part of a broader SharePoint AI plugin, as currently replicating a set of lists and keeping their schemas in sync across dev/test/prod makes proper development practices and schema versioning a headache despite solutions supporting SharePoint sites and lists as envieonment variables. Declarative data import capabilities with batch queries are also planned.
I'm thinking with this and a Power Automate plugin/MCP server (for which a few already exist), non-premium Power Platform development has a lot to offer still and opens up a lot of possibilities: generating flows that use batch requests for multi-table/multi-record inserts/updates, applying and managing RLS via SharePoint security groups, fetching of item version history, and so much more that was previously too impractical to wire up.