Hi everyone! I'm new here and still getting my bearings with Windsurf. I've been exploring it for automating some of our CRM data cleanup tasks, and the agent workflow seems really powerful for that. 😊
I'm trying to understand a specific use case: creating a custom agent to help with database migration scripts. In our email marketing setup, we sometimes need to move customer segments between tables or merge fields after a platform update. Doing this manually is error-prone.
Could someone walk me through the step-by-step process of building an agent for this? I'm particularly fuzzy on how you define the agent's "instructions" or scope so it knows which tables or schemas to work with. Do you usually give it direct database access, or feed it sample SQL first?
Also, are there any pitfalls to watch out for when using an agent for actual database changes? I'd hate to accidentally mess up our customer data. Any guidance from those who've tried this would be so appreciated!