AI Query Assistant
Natural-language chat that generates and refines SQL from live schema context and can explain query or stored-procedure errors.
OL DataIQ includes an AI-powered chat assistant in the Query Console that turns natural-language requests into SQL grounded in the connected database schema.
Capabilities
- Schema-aware suggestions (tables, columns, relationships)
- Insert suggested SQL into the editor; refine with follow-up prompts
- Conversation context across messages; learns from last query and errors
- Explain failed queries or stored-procedure saves via notification “Explain” into chat
- When writing INSERT statements, key columns are treated as keys. Auto-generated columns are left for the database to fill, and a numeric key takes the next value from rows already in the table so sample rows do not clash