Skip to main content

ChatDBA

ChatDBA is NineData's intelligent assistant for database Q&A, knowledge retrieval, SQL troubleshooting, and everyday AI-assisted inquiries.

What ChatDBA Can Do​

  • Knowledge Q&A: Ask questions in natural language and quickly get answers about databases, platform features, and troubleshooting topics.
  • Knowledge-base-enhanced answers: ChatDBA can combine enterprise knowledge bases with general AI reasoning. For more information, see Knowledge Base Management.
  • Data source access: Select a data source that has been added to NineData so ChatDBA can answer questions or help locate issues with data source context.
  • SQL troubleshooting: When AI diagnosis is triggered from the SQL Console, ChatDBA analyzes the error and suggests follow-up actions.
  • Performance diagnosis: Provides a performance diagnosis Agent for MySQL-compatible databases, including database health checks, real-time session diagnosis, slow SQL governance, intelligent SQL optimization, lock diagnosis, and long-transaction diagnosis.
  • Efficient retrieval: Retrieves relevant information from knowledge bases, historical conversations, and the current question to provide answers with fuller context.
  • Multi-turn conversation: A single chat keeps context, making it suitable for follow-up questions and step-by-step troubleshooting.

Supported Data Sources for Performance Diagnosis​

The performance diagnosis capability currently supports MySQL, RDS MySQL, PolarDB MySQL, TDSQL-C MySQL, TaurusDB MySQL, and Aurora MySQL.

Usage Limits​

  • Unregistered or logged-out users have a limit of 10 Q&A sessions per day.
  • Unregistered or logged-out users cannot start new sessions.

Prerequisites​

  • You are logged in to the NineData console.
  • If you want ChatDBA to answer with enterprise knowledge, configure and enable a knowledge base first.

Getting Started​

  1. Log in to the NineData Console.

  2. Click the chatdba icon at the top of the page to open ChatDBA. The page opens in full-screen mode by default, and you can switch between full-screen and window mode as needed.

  3. To let ChatDBA answer with the context of a specific data source, click Select Datasource and select the target data source.

  4. Enter your question in the input box at the bottom, then click send-fill to send it.

  5. To start a new conversation, click New Chat on the left. Previous chats stay in the history list for later review.

    tip

    Context is preserved within the same session. For more coherent answers, keep related follow-up questions in a single conversation.

  6. To delete a chat, hover over the target conversation, click delete, and then confirm with Delete Chat.

    caution

    Deleted conversations cannot be restored.

View Knowledge Sources​

If an answer is based on knowledge base content, ChatDBA displays the View knowledge sources button below the answer. Click it to see which sources were referenced.

Last updated on