README.md

---
title: Nilotpal SQL Bot
emoji: ⚡
colorFrom: blue
colorTo: indigo
sdk: docker
pinned: false
license: mit
app_port: 7860
---

# ⚡ Nilotpal SQL Bot

A Telegram bot + Web App that converts plain English to SQL and queries your CSV data instantly.

## Features

| Feature | Standard Telegram Msg | Telegram Web App |
|---|---|---|
| HTML/CSS Support | ❌ None | ✅ Full |
| Interactive Buttons | ✅ Yes | ✅ Yes |
| Complexity | Low | High |
| Professional Feel | Good | Premium |

## Setup (Two Steps)

### Step 1 — HuggingFace Space Secrets
In your Space → Settings → Variables and secrets, add:

| Key | Value |
|---|---|
| `BOT_TOKEN` | Your Telegram bot token from @BotFather |
| `SPACE_URL` | `https://nilotpaldhar2004-nilotpal-sql-bot.hf.space` |
| `WEBHOOK_SECRET` | Any secret string (e.g. `nilotpalsqlbot`) |

### Step 2 — Telegram Bot Setup
1. Message @BotFather → `/newbot` → get token
2. Set bot token in HF Secrets
3. Deploy Space → webhook auto-registers on startup

### Step 3 — Enable Web App in BotFather
```
/newapp → select your bot → set URL to:
https://nilotpaldhar2004-nilotpal-sql-bot.hf.space/webapp
```

## Usage

**Via Telegram Bot:**
1. Send `/start`
2. Send a `.csv` file
3. Ask questions in plain English

**Via Web App:**
- Tap "Open Web App" button in bot
- Full HTML/CSS premium interface
- Upload CSV + chat with data

## Tech Stack
- FastAPI + Python
- HuggingFace Transformers (T5-small text-to-SQL)
- SQLite (in-memory per session)
- Telegram Bot API + Web App API
- Docker on HuggingFace Spaces

## File Structure
```
nilotpal-sql-bot/
├── app.py              ← FastAPI backend + Telegram webhook
├── static/
│   └── webapp.html     ← Telegram Web App UI
├── requirements.txt
├── Dockerfile
└── README.md
```