OK..promise to not laugh....but....I wanted a similar arrangement last week...just before I went fishing the next day.
Around the house, I had a 3/8th's inch brass curtain rod that was left over from some redecorating. I save stuff like that.
We are talking about something like this...but 8 feet long.
https://www.amazon.com/Brass-C360-Round-ASTM-B16-Length/dp/B000FN192U
You can probably buy one at a thrift store or a garage sale for a buck or two. Alternatively, you could use a copper grounding rod.... but they are probably expensive, considering how much copper has gone up lately.
I needed some sort of a handle to pull on when the rod got stuck in the mud. I had an old golf Stainless Steel iron around. I cut it off; and drilled it for an eye bolt. If I had one handy, I would have used a putter, since it is normally square ...but...this golf shaft was handy. You can buy one from a thrift store for a buck or two. Use a putter ......
Viola! My almost costless stick it anchor....
I tried it the other day in some pretty good wind. It held my 160W Lowe very well.
Soft bottom, stuck it way down deep. I haven't tried it yet in an oyster shell reef, but I can't see how anything could dig in better than this rod. Total length is about nine feet.
regards, Rich