User macros are stored in the bandana table:

select * from bandana as b where b.bandanakey = 'atlassian.confluence.user.macros';

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.