AI Overview
This category brings together NineData's AI-related capabilities in one place, including Q&A, generation, diagnosis, and AI configuration features.
Capability Map
| Feature | Typical scenario | Entry |
|---|---|---|
| ChatDBA | Database Q&A, knowledge retrieval, troubleshooting | ChatDBA icon at the top of the page or AI diagnosis in SQL Console |
| Text2SQL / Chat2SQL | Generate SQL from natural language | SQL editor |
| AI SQL Completion | Get context-aware completion while typing | AI icon in the upper-right corner of the SQL editor |
| AI SQL Optimization | Get optimization suggestions for SQL | Toolbar or right-click menu in SQL Console |
| AI SQL Diagnosis | Analyze SQL execution errors | AI diagnosis button after an SQL error |
| AI SQL Formatting | Reformat SQL for readability | AI formatting entry in supported SQL Consoles |
| SQL Help and Semantic Explanation | Explain SQL syntax, object definitions, and statement logic | Right-click menu in SQL editor |
| AI DDL Conversion | Convert table DDL across database types | Right-click menu on a table in SQL Console |
| AI Table Structure to Code | Generate code skeletons from table structures | Right-click menu on a table in SQL Console |
| AI Routine to Code | Convert procedures or functions to application code | Right-click menu on a routine in SQL Console |
| Natural Language to Redis Commands | Generate Redis commands from plain language | Redis SQL Console |
| Knowledge Base Management | Provide enterprise knowledge to ChatDBA | Account or organization configuration entry |
| AI Model Management | Configure and switch AI models | System configuration |
Find by Task
| Task | Recommended documentation |
|---|---|
| Generate SQL from natural language | Text2SQL / Chat2SQL |
| Diagnose SQL errors or optimize SQL | AI SQL Diagnosis, AI SQL Optimization |
| Get completion, explanation, and formatting assistance while writing SQL | AI SQL Completion, SQL Help and Semantic Explanation, AI SQL Formatting |
| Manage ChatDBA Q&A and enterprise knowledge | ChatDBA, Knowledge Base Management, AI Model Management |
| Generate DDL, code, or Redis commands | AI DDL Conversion, AI Table Structure to Code, AI Routine to Code, Natural Language to Redis Commands |
Recommended Usage Pattern
- If you want more business-specific answers, configure Knowledge Base Management or AI Model Management first.
- For Text2SQL scenarios, add AI notes to tables and columns to improve SQL generation accuracy.
- During everyday SQL writing, enable AI SQL Completion to get gray inline suggestions that can be accepted with the Tab key.
- Review AI-generated results before using them in production workflows.
Notes
- The documents in this category are AI-focused topic pages.
- The original module-specific documents remain in their existing locations for feature-by-feature lookup.