> For the complete documentation index, see [llms.txt](https://doc.chatdba.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.chatdba.com/start-a-conversation-with-chatdba/expert-mode.md).

# Expert mode

> In order to provide you with better service, we not only offer the basic version, but also the upgraded version ChatDBA Pro. You can refer to the [upgrade plan ](/chatdba-advanced-exploration/upgrade-plan.md)for details.

## The usage method of expert mode

When creating a conversation, you can choose the service mode you need in advance, which includes "simple mode" and "expert mode". As the name suggests, "expert mode" will be more professional in solving the problems you encounter in the database. Then enter your database question in the input box. Finally, click on send.

<figure><img src="/files/INXkAkf9PvM4thkZHEWo" alt=""><figcaption></figcaption></figure>

#### # Image upload

In order to better restore the scenario of database failure, we support users to upload corresponding error message pictures or photos (you can upload pictures by dragging or copying and pasting). The specific questioning method is shown in the following figure.

<figure><img src="/files/LAg4SaQlGZRKVoKtlwcp" alt=""><figcaption></figcaption></figure>

> Note:
>
> * The image formats we support for uploading here are: PNG, JPG, JPEG;
> * Upload a maximum of 3 images per conversation round;
> * One account can only upload 30 images per day

#### # Overview of Expert Mode Answer Page

<figure><img src="/files/lg6tSfFlapqQZmTOlfUY" alt=""><figcaption></figcaption></figure>

#### # SQL Generation/Optimization

{% hint style="success" %}
Currently, both "Simple Mode" and "Expert Mode" support SQL generation/optimization. For specific questioning methods, please refer to the methods provided below.
{% endhint %}

**SQL Generation：**

Taking expert mode as an example, ask ChatDBA to help you generate the SQL statements you want.

<figure><img src="/files/uKgxiDyf8r9CgUi8GqlO" alt=""><figcaption></figcaption></figure>

> Note: You need to provide relevant table structure information and a description of the SQL statement to be generated. At the same time, the input should clearly include a description of the SQL statement that ChatDBA is expected to assist in generating.

**SQL Optimization：**

Taking expert mode as an example, ChatDBA is requested to help you optimize SQL statements. The specific example is shown in the following figure.

<figure><img src="/files/16rUFE4C9c8tHs8QrlQg" alt=""><figcaption></figcaption></figure>

> The input should clearly include a description of hoping ChatDBA can help optimize SQL statements.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://doc.chatdba.com/start-a-conversation-with-chatdba/expert-mode.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.