Incoming DDI provisioning via mysql

Hi I am looking at creating an incoming ddi database so I can provision new numbers without having to restart asterisk.

The database will also hold variables to pass to dialplan like macro, language, MOH etc.

To replicate this:
exten => 1001,1,Macro(bridge,gb-f)

I’ve been looking at asterisk real time database but I’m not sure it’s a good fit.

Has anyone else tackled this kind of database integration before and have any good ideas?

Thanks