Vanna.ai: Chat with your SQL database

• vanna

  21 6,474 9.5 Python

  🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.

  

This is a good idea. I think what you'd want to do is override the generate_sql function and store the question with the "related" metadata and the generated sql somewhere:

https://github.com/vanna-ai/vanna/blob/main/src/vanna/base/b...

We're going to be adding a generic logging function soon and fairly soon what you're talking about could just be a custom logger.

• ibis

  23 4,074 10.0 Python

  the portable Python dataframe library

  

Please add Ibis Birdbrain https://ibis-project.github.io/ibis-birdbrain/ to the list. Birdbrain is an AI-powered data bot, built on Ibis and Marvin, supporting more than 18 database backends.

See https://github.com/ibis-project/ibis and https://ibis-project.org for more details.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• LLMStack

  20 1,089 9.9 Python

  No-code platform to build LLM Agents, workflows and applications with your data

  

We have recently added support to query data from SingleStore to our agent framework, LLMStack (https://github.com/trypromptly/LLMStack). Out of the box performance performance when prompting with just the table schemas is pretty good with GPT-4.

The more domain specific knowledge needed for queries, the harder it has gotten in general. We've had good success `teaching` the model different concepts in relation to the dataset and giving it example questions and queries greatly improved performance.

• MindsDB

  78 21,223 10.0 Python

  The platform for customizing AI from enterprise data

  

• vanna-flask

  2 47 4.5 Python

  Web server for chatting with your database

  

• vanna-streamlit

  2 100 6.4 Python

  Vanna AI Streamlit App

  

• vanna-chainlit

  1 15 4.4 Python

  A chainlit app that you can use to chat with your SQL database

  

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• vanna-slack

  2 12 4.9 Python

  Slack bot for Vanna AI

  

• prql

  106 9,427 9.9 Rust

  PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

  

https://prql-lang.org/ might be an answer for this. As a cross-database pipelined language, it would allow RAG to be intermixed with the query, and the syntax may(?) be more reliable to generate

Suggest a related project