TESH-Query

TESH-Query (teshq) is a CLI tool that transforms natural language queries into SQL and returns relevant tables using natural language responses. It's designed to bridge the gap between human language and database queries, making data easily accessible for teams without requiring SQL expertise. --- Key Features - Natural Language to SQL: No need to write complex queries—just ask questions like you would in conversation. - AI-Powered Translation: Uses Google Gemini AI (via Langchain) for intelligent SQL generation. - Direct Database Interaction: Works with PostgreSQL, MySQL, and SQLite. - Schema-Aware Queries: Understands your database structure for relevant responses. - Formatted Results: Displays query output in a clean, readable table in your terminal. - Secure Configuration: Supports credential management and database setup. --- Example Usage Instead of writing a lengthy SQL query: 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; You can just type: teshq query "Show me all high-value electronics orders from last month" And get the formatted results instantly! --- Installation & Setup 1. Install via pip: pip install teshq 2. Configure database & AI API key: teshq config --config-db teshq config --config-gemini 3. Start querying: teshq query "Show me the total sales amount for each product category in the last quarter." --- Why Use It? ✅ Faster insights without SQL expertise ✅ More productive teams accessing data effortlessly ✅ Less room for errors in manual SQL writing ✅ Supports various databases ✅ Secure storage of credentials