I want to make my bot access to all the tables in my database to make a sql query to give what the user asks for in the tables but in the mysql tool it only lets me access to one table, not all of them at the same time, how can i do it without making 100 tools of mysql or without downloading the tables?
It looks like your topic is missing some important information. Could you provide the following if applicable.
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- Operating system:
Hi @Jose_Lopez,
For your use case, where you want your bot to query multiple tables dynamically without creating multiple MySQL nodes, a vector database could be a great solution. Vector databases are optimized for handling large sets of unstructured data and allow fast, efficient searches across multiple sources of information.
You can read more about what a vector database is here: What are vector databases? | n8n Docs.
Let me know if it helped!
I resolved it giving the bot all the columns from all the tables, and then making chatgpt give me the query and executed it
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.