Metadata-Version: 2.4
Name: teshq
Version: 0.3.1
Summary: A CLI tool that converts natural language queries into SQL and returns relevant tables using natural language.
Author-email: Shashank <shashankgundas1@gmail.com>
License: MIT
Project-URL: Homepage, https://github.com/theshashank1/TESH-Query
Project-URL: Bug Tracker, https://github.com/theshashank1/TESH-Query/issues
Keywords: sql,cli,database,natural language,AI,LLM
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Classifier: Programming Language :: Python :: 3.12
Classifier: Operating System :: OS Independent
Requires-Python: >=3.9
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: SQLAlchemy~=2.0.41
Requires-Dist: python-dotenv~=1.1.0
Requires-Dist: psycopg2-binary~=2.9.10
Requires-Dist: langchain~=0.3.25
Requires-Dist: langchain-core~=0.3.61
Requires-Dist: langchain-google-genai~=2.1.4
Requires-Dist: typer[all]~=0.15.4
Requires-Dist: rich~=14.0.0
Requires-Dist: logfire~=3.16.0
Requires-Dist: tabulate~=0.9.0
Provides-Extra: dev
Requires-Dist: pytest~=8.3.5; extra == "dev"
Requires-Dist: autopep8~=2.3.2; extra == "dev"
Requires-Dist: pre-commit~=4.2.0; extra == "dev"
Requires-Dist: flake8~=6.1.0; extra == "dev"
Requires-Dist: isort~=5.13.2; extra == "dev"
Dynamic: license-file

<!-- # TESH-Query
A CLI tool that converts natural language queries into SQL and executes them on your database. -->
# 🤖 TESH-Query

**TESH-Query** (Text to Executable SQL Handler) is an AI-powered CLI tool that lets you query your database using natural language — and instantly get the **actual table data** you're asking for.

> **Ask**: *"Show me the list of employees in Bangalore with salary above 1 lakh"*
> **Get**: 🧾 A neatly printed table with exactly those results — **no SQL writing required**.

## ✨ What it does

- 💬 Turn **natural language** into working SQL queries
- 🔍 **Find exactly the data** you need without SQL knowledge
- 🔌 Work with **PostgreSQL, MySQL, SQLite** databases
- ⚡ **Lightning-fast CLI** experience

## 🚧 Development Status

TESH-Query is currently in **early-stage development**. Here's what's actively being worked on:

- ✅ **CLI foundation** with Typer
- ✅ **Database configuration** with secure credential storage
- ✅ **Connection management** utilities
- 🔄 **Natural language understanding** pipeline (in progress)
- 🔄 **Schema introspection** for query context (in progress)

## 📦 Basic Usage (Coming Soon)

```bash
# Configure your database connection
teshq config

# Connect to your database
teshq database --connect

# Ask questions in plain English
teshq query "List all customers who made a purchase last month"
```

## 🔧 Tech Stack

- **Python** - Core language
- **Typer** - Modern CLI framework
- **SQLAlchemy** - Database interaction
- **dotenv/JSON** - Configuration handling
- **LLM Integration** - Natural language processing (coming soon)

## 👤 Made By

**[Shashank](https://github.com/theshashank1)** — Building intelligent tools for developers.

## ⭐ Stay in the Loop

Star this repo to follow along — AI-driven database access is coming soon.
