Hello Vineet,
Simple solution is to modify corresponding VSM. Add Database step in your VSM just before response selection step. Enter required connection details along with SQL query [select superhero from Movies where Name='{{requestPara}}']. As you would expect dynamic Name to pass in SQL query so you'll have to capture that from the incoming request message.
Use testExec.getStateValue("Argument Name as shown in VSI") to capture incoming request Argument in any variable say 'requestPara'. It can be done by adding Java Script step or scripted assertion in Listener step.
Now, next step would be to add filter to the database step to store step response which anyway is really simple; thanks to CA's intelligent minds to provide simplified solution.
Alright, so you have captured expected data from database successfully. Next step is to update VSI file to send captured dynamic data in response message. Simply open VSI and pass variable/ property name wherein you have captured SQL result. You can update VSI node like <Superhero>{{dbSuperHero}}</Superhero> and you are all set to run dynamic service.
Hope, it helps !
Thanks,
Kumar
Please ignore typos.