I am looking to connect multiple tables and queries from a dynamic MySQL database to several datagrids in a Ext JS web application.

It appears that Ext JS cannot directly connect to a MySQL database, and must use a JSON that is generated from PHP for each and every table or query in the MySQL database.

Is there a quicker way to do this? Perhaps an application that generates the PHP JSON scripts automatically?