GitHub Source: http://github.com/theshashank1/TESH-Query

PyPI Source: http://pypi.org/project/teshq/

Tired of wrestling with complex SQL queries? Introducing TESH-Query, the open-source CLI tool that makes database querying effortless. Powered by AI, TESH-Query (Text to Executable SQL Handler) transforms your plain English questions into optimized SQL queries, making data accessible to everyone on your team.

Example Usage

Imagine you need to find all high-value electronics orders from last month.

Before: Crafting intricate SQL...

# Before: Crafting intricate SQL...
$ psql my_database -c "SELECT products.name, categories.category_name, orders.order_date FROM products JOIN order_items ON products.id = order_items.product_id JOIN orders ON order_items.order_id = orders.id JOIN categories ON products.category_id = categories.id WHERE categories.category_name = 'electronics' AND orders.order_date >= current_date - interval '1 month' ORDER BY orders.order_date DESC;"

# After: Just ask TESH-Query!
$ teshq query "Show me all high-value electronics orders from last month"

# Get instant, formatted results directly in your terminal:
┌────────────┬─────────────────┬───────────┬─────────────┐
│ Order ID   │ Product Name    │ Price     │ Order Date  │
├────────────┼─────────────────┼───────────┼─────────────┤
│ 12847      │ MacBook Pro M3  │ $2,499.00 │ 2025-04-15  │
│ 12923      │ OLED Monitor    │ $899.99   │ 2025-04-18  │
└────────────┴─────────────────┴───────────┴─────────────┘

teshq query "List the top 5 highest-selling products this month"

TESH-Query intelligently generates and executes the SQL query, delivering results instantly.