search

vanna-ai / vanna

🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.
https://vanna.ai/docs/
MIT License
9.97k stars 737 forks source link

module 'vanna' has no attribute 'connect_to_mysql' #371

Closed Abhinav0905 closed 3 months ago

Abhinav0905 commented 3 months ago

Describe the bug unable to connect to MySQL. When printing the directory of Vanna, connect_to_mysql wasn't listed. Even tried using pip install vanna[mysql]

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Error logs/Screenshots If applicable, add logs/screenshots to give more information about the issue.

Desktop (please complete the following information where):

Additional context Add any other context about the problem here. image

zainhoda commented 3 months ago

Upgrade your vanna installation please

pip install -U vanna

Abhinav0905 commented 3 months ago

Tried doing on the vanna colab official page . Still facing the same issue

image

Abhinav0905 commented 3 months ago

even tried like this -- image

zainhoda commented 3 months ago

Ah it's the "import vanna as vn" that's the issue. That's deprecated.

Try this setup to instantiate vn as a class:

https://vanna.ai/docs/mysql-openai-standard-chromadb/

image