LLM generates SQL queries randomly and not based on the specified tables.

[anonymously-coded]

I am trying to create a SQL chatbot that can communicate with the live database. I am using MySQL. I followed all the steps given in the SQL Q&A Guide by the flowise documentation. The chain is the same as the document. But instead of one table I used 3 tables, The llm generates queries randomly and not based on the given tables, for example I have table called app_user, when a question like "Who is ramesh?" is asked it queries like "select * from users where name ='ramesh'". Even thought the table it should look is app_user it looks for users tables and when executing the query it fails. Can anyone help me with this??

This is the code I use to create the schema for my prompt.
const HOST = 'localhost';
const USER = 'root';
const PASSWORD = 'toor';
const DATABASE = 'customerdb';
const TABLES = ['app_user', 'company', 'user_company'];
const mysql = require('mysql2/promise');

let sql_schema_prompt_for_all_tables = '';

function get_sql_schema_prompt() {
return new Promise(async (resolve, reject) => {
try {
const db_conn = mysql.createPool({
host: HOST,
user: USER,
password: PASSWORD,
database: DATABASE,
});

        // Get the schema info for the tables
        for (const table of TABLES) {
            const [schema_info] = await db_conn.execute(
                `SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = "${table}"`
            );

            const column_names = new Set();

            for (const schema_data of schema_info) {
                column_names.add(`${schema_data['COLUMN_NAME']}`);
            }


            const array_column_names = [];
            for (const col_name of column_names) {
                array_column_names.push(col_name);
            }
            sql_schema_prompt_for_all_tables += `Table: \`${table}\`\n`;
            sql_schema_prompt_for_all_tables += `Columns: ${array_column_names.join(', ')}\n\n`;
        }
        resolve();
    } catch (e) {
        console.error(e);
        return reject(e);
    }
});

}

async function main() {
await get_sql_schema_prompt();
console.log(sql_schema_prompt_for_all_tables);
}

main();

Thanks in advance for you help.