Agave's Support Skill causes her to deal Electrical DMG + Paraylze (for 2s) in an AoE in front of her.
Note that the stun and damage from her Support Skill are not really very useful - you're using it for the ATK buff [below] only, really.
This uses 20% of Agave's S-Energy. If this causes Agave to use more than 10 S-Energy, Agave gives the entire squad a 2% ATK bonus for 15s per S-Energy over 10 she used.
Given that this skill has a 15s duration, Agave will always be at full S-Energy when it is used.
With Agave's passive +30 max S-Energy and her 4* or 5* weapons +20 max S-Energy, Agave has a max S-Energy of 100, meaning 20% of her S-Energy is 20 S-Energy.
Using 20 S-Energy means Agave uses 10 more than 10, so her Support Skill gives the entire team a 10 * 2% = 20% ATK buff.
Given that this is a 15s buff on a 15s CD, provided you spam it off-cooldown it's basically permanent.
ATK tends to get quite a few buffs (Logistics, Logistics substats, Manifestation levels, other support operatives....) and is quite a saturated category, but despite this, 20% ATK is a good bonus considering it's basically permanent and doesn't require much investment.
Agave also gives a pure-ATK boost, which almost every main DPS operative in the game benefits from.
Many other operatives like Celestial Swan, Nightglow, Starshine, Phantasia, Kaguya, Exuvia, etc. all have some restriction on who can use their buffs.
Provided Agave has her 4* or 5* weapon, she can provide this full 20% ATK buff, which is a very low barrier to entry.
(Without one of her signature weapons that increases her max S-Energy, it's still a 12% buff due to her +30 base S-Energy.)
Agave doesn't get any bonus to her Support Skill from her Manifestations, and her Neuronics and Deiwos also don't functionally change it, so Agave having her 4* or 5* weapon is all that she actually needs to be a decent support, and even without any investment at all it's again a 12% buff, which can benefit all operatives.
Is Agave a great support?
Not really - compared to other support operatives like Celestial Swan, Nightglow, Riptide, Kaguya, Starshine, etc., Agave does fall extremely short, but Agave provides a useful benefit with 100% uptime and zero investment outside of just having Agave and hopefully having one of her signature weapons.
Will Agave make it onto an endgame team as a support? Not unless Parts Breaking is needed, no.
What Agave will do though is provide an extremely easy-to-get buff that benefits basically all dps operatives, with 100% uptime, which is enough to make her an ok support for new players, or for newer players who haven'to put investment into supports yet.
I don't recommend you pull Agave unless you either like her as a character or need Parts Breaking, but if you are a new player and trip over her then she can potentially be a competent support.