Example flow that shows how to pass SQL select query to HTTP flow against a database (Mule 3.x)

pass-sql-query-mule.xml

<flow name="query-dbFlow1">
        <http:listener config-ref="HTTP_Listener_Configuration" path="/query" doc:name="HTTP"/>
        <set-variable variableName="query" value="#[message.payloadAs(java.lang.String)]" doc:name="Variable"/>
        <db:select config-ref="MySQL_Configuration" doc:name="Database">
            <db:dynamic-query><![CDATA[#[flowVars.query]]]></db:dynamic-query>
        </db:select>
        <json:object-to-json-transformer doc:name="Object to JSON"/>
</flow>