Autocomplete and Suggestions
Production - Query suggestions, similar queries, templates, and predictions
The Autocomplete system provides intelligent query suggestions as users type, recommends similar previously-successful queries, and offers template-based quick starts.
12.3.6.1Suggestion Service
Implemented in data-plane/ai-service/src/sql_generation/suggestions.py:
# Get query suggestions
curl "http://localhost:8000/api/v1/text-to-sql/suggestions?tenant_id=acme-corp&prefix=show+me+total"{
"suggestions": [
{"text": "Show me total revenue by region", "confidence": 0.92, "source": "history"},
{"text": "Show me total orders this month", "confidence": 0.88, "source": "template"},
{"text": "Show me total customers by segment", "confidence": 0.85, "source": "schema"}
]
}Similar Query Lookup
curl "http://localhost:8000/api/v1/text-to-sql/similar?tenant_id=acme-corp&question=revenue+by+region"{
"similar_queries": [
{
"question": "What is revenue by region for Q3?",
"sql": "SELECT region, SUM(revenue) FROM orders WHERE ...",
"similarity_score": 0.94,
"execution_count": 12
}
]
}