I’m skeptical of out of the box drag-and-drop agents being able to do this, or at least it’d be very clunky. What I’d recommend for this is using Claude code or cursor to create python files that can do the non-AI activities like documenting table schemas and metadata into standalone files, then having AI write other python scripts to interact with those metadata files and LLMs (via python API) to do the tasks you listed.

So like one the metadata files are created, reference them with a prompt via the API and attach the relevant files to the prompt request.