How to use third-party programs (HTTP access) to filter SQL queries？

[KAgBMan]

Now I need to control the database query and want to use a third-party program (providing an HTTP interface) to control it. I will use HTTP to return results to decide whether to allow the SQL query.
I found that the Lua function can be configured in the apply field of mysql_query_rules, but I couldn't find a specific method. Need help!
vision 2.0.15

[JavierJF]

Hi @KAgBMan,

this statement doesn't make sense to me:

I found that the Lua function can be configured in the apply field of mysql_query_rules, but I couldn't find a specific method. Need help!

There is no bindings feature or anything like that for mysql_query_rules. This looks like a misunderstanding of how ProxySQL works and how to perform query filtering using mysql_query_rules. There is plenty of material for that, I'm closing this for now since it doesn't appear to be any issue.

Please feel free to elaborate on this issue, even if closed in case I misunderstood something.

Regards, Javier.