Asterisk call forwarding with input from user

I want to enable call forwarding, user will input the number he wants to forward the call to, i will store this input in a db table through AGI and will use this number in my dial plan to enable call forwarding.

Can someone please guide me here?

I am new to asterisk, looking for ideas how to do this.

I believe there are guides out there for doing so, but my general advice for this kind of thing is to always break it down step by step to what you need to do and then look for an Asterisk application or dialplan function that will help you do each step.

Thank you for advice.

To take input should i use read application?

That is what the Read application is for, yes.