Learn to Connect MySQL database and Query in Natural Language with Vanna AI+Ollama and get automated Visualization with Plotly, Other Important Tools/Database/LLM in this Video are ChromaDB/Jupyter Notebook/Mistral.
Vanna AI
[ Ссылка ]
[ Ссылка ]
Chat with your SQL database. Accurate Text-to-SQL Generation via LLMs using RAG
Let Vanna.AI write your SQL for you
The fastest way to get actionable insights from your database just by asking questions
Why Vanna
Open-Source
The Vanna Python package and the various frontend integrations are all open-source. You can run Vanna on your own infrastructure.
High accuracy on complex datasets
Vanna’s capabilities are tied to the training data you give it. More training data means better accuracy for large and complex datasets.
Designed for security
Your database contents are never sent to the LLM unless you specifically enable features that require it. The metadata storage layer only sees schemas, documentation, and queries.
Self learning
As you use Vanna more, your model continuously improves as we augment your training data.
Supports many databases
Snowflake , BigQuery, Postgres, and many others. You can easily make a connector for any database.
Choose your front end
Start in a Jupyter Notebook. Expose to business users via Slackbot, web app, Streamlit app, any other frontend. Even integrate in your web app for customers.
Ollama: Large Language Model Runner.
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
ChromaDB:
[ Ссылка ]
[ Ссылка ]
the AI-native open-source embedding database
Simple: Fully-typed, fully-tested, fully-documented == happiness
Integrations: LangChain (python and js), LlamaIndex and more soon
Dev, Test, Prod: the same API that runs in your python notebook, scales to your cluster
Feature-rich: Queries, filtering, density estimation and more
Free & Open Source: Apache 2.0 Licensed
Use case: Chat
For example, the "Chat your data" use case:
1. Add documents to your database. You can pass in your own embeddings, embedding function, or let Chroma embed them for you.
2. Query relevant documents with natural language.
3. Compose documents into the context window of an LLM like GPT3 for additional summarisation or analysis.
MySQL
[ Ссылка ]
MySQL is an open-source relational database management system.
[ Ссылка ]
JupyterLab is the latest web-based interactive development environment for notebooks, code, and data. Its flexible interface allows users to configure and arrange workflows in data science, scientific computing, computational journalism, and machine learning. A modular design invites extensions to expand and enrich functionality.
[ Ссылка ]
Plotly's Python graphing library makes interactive, publication-quality graphs. Examples of how to make line plots, scatter plots, area charts, bar charts, error bars, box plots, histograms, heatmaps, subplots, multiple-axes, polar charts, and bubble charts. Plotly.py is free and open source and you can view the source, report issues or contribute on GitHub
