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 |
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.