Vanna AI Customization for better SQL execution #5903

Closed
opened 2026-02-21 18:13:09 -05:00 by yindo · 0 comments
Owner

Originally created by @ytjhai on GitHub (Oct 2, 2024).

Self Checks

  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
  • [FOR CHINESE USERS] 请务必使用英文提交 Issue,否则会被关闭。谢谢!:)
  • Please do not modify this template :) and fill in all the required fields.

1. Is this request related to a challenge you're experiencing? Tell me about your story.

I was originally going to mark this as a bug report because I received an error when using Vanna AI on my local database. The error told me to enable the allow_llm_to_see_data flag. Then I went down several rabbit holes and stumbled across Vanna.ai documentation that references this flag. My main use case was being able to query data from an SQL database, and I noticed you are already working on this through #8045

So why not add more feature completeness to the Vanna.ai integration? It should allow conversation tools built with Dify to query data effectively through SQL and has several features such as introspection, SQL extraction, among others.

2. Additional context or comments

Potentially, a good starting point is to customize the Vanna.ai URL to a locally hosted instance using its Flask API: https://github.com/vanna-ai/vanna-flask

Another option is to somehow expose the Vanna.AI class customization options for changing the Vector DB - https://vanna.ai/docs/behavior-customization/

This could allow one to host Vanna.ai locally or point to a remotely hosted URL with the desired settings.

3. Can you help us with this feature?

  • I am interested in contributing to this feature.
Originally created by @ytjhai on GitHub (Oct 2, 2024). ### Self Checks - [X] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones. - [X] I confirm that I am using English to submit this report (我已阅读并同意 [Language Policy](https://github.com/langgenius/dify/issues/1542)). - [X] [FOR CHINESE USERS] 请务必使用英文提交 Issue,否则会被关闭。谢谢!:) - [X] Please do not modify this template :) and fill in all the required fields. ### 1. Is this request related to a challenge you're experiencing? Tell me about your story. I was originally going to mark this as a bug report because I received an error when using Vanna AI on my local database. The error told me to enable the `allow_llm_to_see_data` flag. Then I went down several rabbit holes and stumbled across Vanna.ai documentation that [references this flag](https://vanna.ai/docs/base/). My main use case was being able to query data from an SQL database, and I noticed you are already working on this through #8045 So why not add more feature completeness to the Vanna.ai integration? It should allow conversation tools built with Dify to query data effectively through SQL and has several features such as introspection, SQL extraction, among others. ### 2. Additional context or comments Potentially, a good starting point is to customize the Vanna.ai URL to a locally hosted instance using its Flask API: https://github.com/vanna-ai/vanna-flask Another option is to somehow expose the Vanna.AI class customization options for changing the Vector DB - https://vanna.ai/docs/behavior-customization/ This could allow one to host Vanna.ai locally or point to a remotely hosted URL with the desired settings. ### 3. Can you help us with this feature? - [ ] I am interested in contributing to this feature.
yindo added the 💪 enhancement label 2026-02-21 18:13:09 -05:00
yindo closed this issue 2026-02-21 18:13:09 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#5903