Query Optimization has been a crucial and headache issue for SQL storage engines. Databricks, Snowflake, Microsoft, and Oracle all have big teams dedicated to this field. Meanwhile, insufficient SQL queries are still everywhere and wasting tons of time and computing resources. Currently, there are various ways to rewrite an inefficient SQL query, there are even startups just to help you write good queries. But their approaches are still mostly by rules and heuristics. ChatGPT is able to rewrite some queries, but firstly the current results are not good enough, and secondly, it would be hard to incorporate data schema information such as table, index, etc. However, these obstacles are not unsolvable. We should believe LLM can play a bigger role in this field. This project leverages the power of PaLM and LangChain, demonstrating the first step towards this goal.

Google Vertex AI Hackathon

This is a query optimization tool that incorporates both state-of-the-art technology and various domain knowledge. So that engineers and data scientists can feel truly excited using this tool.

SuperCouch

PaLM

Google

LangChain

Langchain

SQL Query Optimizer by LLM

InheriBot is an innovative web application designed to simplify the complex and often confusing inheritance laws within Islamic jurisprudence. Built using vectara, llamaindex, and tonic.ai, InheriBot leverages state of the art technology to provide users with easy access to comprehensive information about inheritance in Islamic law.

Islamic inheritance laws are deeply rooted in tradition and can be challenging to navigate, especially for those unfamiliar with legal terminology and interpretations. InheriBot addresses this challenge by offering a user-friendly interface that allows users to search for specific queries related to inheritance, such as distribution of assets among family members, calculation of shares, and understanding of key terms and concepts.

An Islamic Inheritance Bot simplifying complex inheritance laws, ensuring fair and accurate distribution. InheriBot is a RAG based web application that allows users to search for information about inheritance in Islamic law and provides responses.



Stella

RAG-as-a-service API-driven generative AI platform.

Vectara

LlamaIndex connects data sources to large language models, providing tools to ingest, index, and query data for building powerful AI apps augmented by your knowledge.

LlamaIndex

OpenAI is an AI research and deployment company

OpenAI

Automating data synthesis, advancing data privacy

Tonic.ai

GPT-3.5 stands for Generative Pre-trained Transformer and is fine-tuned version of GPT-3. It is an autoregressive language model that uses deep learning to produce human-like text. There are many models in GPT-3.5 family as gpt-3.5-turbo or gpt-3.5-turbo.

GPT-3.5

InheriBot

SUMMARY :: Imagine having a friendly and knowledgeable partner who can answer your questions in a conversational way, tailoring responses based on your specific interests and needs only - SYSTEMiX is your partner - a personal assistant for all things about systems innovation. 
Engage with complex topics through a user-friendly chatbot interface, drawing from the vast knowledge of the Vectara AI database.
This responsive chatbot sparks short conversations on Systems Thinking, Systems Theory, Systemic Design, and Systems Innovation based on your specific data. Utilizing AI Retrieval Augmented Generation (RAG) technology, this app indexes and queries information from an uploaded corpus in the Vectara database. 


SUMMARY :: Imagine having a friendly an.d knowledgeable partner who can answer your questions in a conversational way, tailoring responses based on your specific interests and needs only - SYSTEMiX is your partner

AIR Rider

Unstructured IO

Discover the power of Together AI and empower AI innovation together!

Together AI

SYSTEMiX ChatBot 

Introducing a cutting-edge personal assistant designed to revolutionize the support and care for individuals living with diabetes. Leveraging state-of-the-art research and advanced technologies, this personal assistant is poised to enhance the quality of life for diabetic patients by providing accurate, relevant, and personalized information while minimizing the risks of misinformation.

A personal assistant updated with state-of-the-art research surrounding Diabetes, to enhance Diabetic patients' quality of life by summarizing important information while minimizing misinformation. RAG chatbot combining semantic search with vector database, keyword databases, and summary index.

RAG powered chatbot to enhance a Diabetes patient's life.

SpaceCats

Empowering AI enthusiasts with cutting-edge Mistral AI models.

Mistral AI

Chroma is an AI-native open-source embedding database. The fastest way to build Python or JavaScript LLM apps with memory

Chroma

Snowflake

Crafting compelling social media copy is a cornerstone of modern marketing strategies, particularly for large brands with substantial online presence. Yet, this essential task can become burdensome as brands churn out a constant stream of content, requiring both creativity and strategic alignment with brand values. Herein lies an opportunity for AI to assist, albeit with certain limitations.

Traditional generative AI, while capable of generating text, often lacks the contextual understanding necessary to produce copy that authentically reflects a brand's identity. This limitation poses a challenge for marketers seeking precise alignment between their brand values and the content they distribute across social media platforms.

A social media post generator with RAG ai - myneflow

myneflow

myneflow marketing ai

 Dr. Green, a 

revolutionary project that leverages the power of AI 
to bridge the communication gap between humans 
and plants. Dr. Green empowers everyone to become 
a plant whisperer, fostering a healthier and more 
sustainable relationship with the natural world
by Leverages Gemini Pro Vision, Vectara and a state-of-the-art AI model for 
image analysis.
• Analyzes plant images to identify diseases, deficiencies, and 
stress factors.
• Provides clear diagnoses and suggests actionable treatment 
options.

 Dr. Green, a 
revolutionary project that leverages the power of AI 
to bridge the communication gap between humans 
and plants. Dr. Green empowers everyone to become 
a plant whisperer, fostering a healthier and more 
sustainable relationship with the natural world
by Leverages Gemini Pro Vision, Vectara and a state-of-the-art AI model for 
image analysis.
• Analyzes plant images to identify diseases, deficiencies, and 
stress factors.
• Provides clear diagnoses and suggests actionable treatment 
options.


With  Dr Green you can talk and hear to you plant . So no more dead plants!

Dr Green

Large language models (LLMs) have transformed the way we approach machine learning and artificial intelligence. These models are incredibly powerful, but their true potential lies in their ability to work in harmony with other sources of data and computation. This library has been developed to assist developers in building applications that combine LLMs with other technologies, allowing them to create truly intelligent and innovative products.

Explore Gemini, Google DeepMind's most advanced AI model, blending multimodality and high efficiency.

Gemini AI

Discover Alphabet Inc.'s gem: Google LLC! A global multi-tech marvel offering internet-focused services – search engines, online ads, cloud prowess, software savvy, and hardware innovation.