README.md

---
title: Datasets Text to SQL/Chart
emoji: 📈
colorFrom: indigo
colorTo: green
sdk: gradio
sdk_version: 4.31.3
app_file: app.py
pinned: false
---

# Datasets Text to SQL / Chart

**Chat with any HF Dataset**
Powered by [Hermes-2-Pro-Llama-3-8B](https://huggingface.co/NousResearch/Hermes-2-Pro-Llama-3-8B)

![Datasets Text to SQL](./media/datasets-text-to-sql.png)

# How it Works

1. Get first parquet file URL from dataset
2. Get SQL DDL from Parquet column and data types
3. Prompt the LLM for SQL
4. Run the SQL against the Dataset Parquet

Inspired by [Datasets-Text2SQL](https://huggingface.co/spaces/asoria/datasets-text2sql)