> For the complete documentation index, see [llms.txt](https://docs.toucanai.cloud/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.toucanai.cloud/build/analyze-your-database-with-ai/how-to/review-ai-analysis-proposals.md).

# Review AI analysis proposals

{% hint style="info" %}
**Target Audience**: Non technical users
{% endhint %}

### Goal

Review the metadata proposals produced by an AI analysis run, decide what to keep or discard, and confirm each section so accepted changes update your metadata in Toucan AI.

***

### Prerequisites

* At least one [AI analysis run](/build/analyze-your-database-with-ai/how-to/analyze-your-database-with-ai.md) has completed on the database.
* You have access to the Databases section as a builder or admin.

***

### Steps

#### 1. Open the AI analyses list

* Navigate to **Databases** and open the database you analyzed.
* Open the **More options** menu (⋮) in the database header.
* Select **AI analyses**.

You land on a list of every analysis run for that database, newest first. Runs are never replaced by newer ones: you can always go back to an earlier review.

<figure><img src="https://4270790459-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fl0BD9cL6TJjTGV95tGak%2Fuploads%2Fgit-blob-1aac4c67bc47998ea51097ab7c691d43eb061d87%2Fai_analysis_analysis_review_page.png?alt=media" alt="AI analyses list keeping every past run, newest first"><figcaption></figcaption></figure>

Each row shows:

* The **scope** of the run (which schemas and tables were selected)
* When it started and who started it
* A status badge when action is needed (**To review**)

<figure><img src="https://4270790459-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fl0BD9cL6TJjTGV95tGak%2Fuploads%2Fgit-blob-f833729d7ab558a7b7750d8360a22ed3ec068220%2Fai_analysis_runs_to_review.png?alt=media" alt="Analysis run carrying the To review badge"><figcaption></figcaption></figure>

#### 2. Open a completed run

* Click a run marked **To review** (or any completed run that still has pending proposals).
* If the run is still **running**, you see live progress and can **Stop the analysis**. Proposals are only reviewable after the run completes successfully.
* If the run **failed** or was **cancelled**, open it to see how far the pipeline got; there is nothing to confirm until you launch a new analysis.

#### 3. Navigate review sections

A completed run with pending proposals opens a review layout:

* A **sidebar** lists review sections that still need attention (in review order):
  * **Type casts** — type casts inferred for columns. For example, text to datetime
  * **Display names** — human-readable labels for the UI and chat
  * **Descriptions** — short explanations of what columns represent
  * **Relationships** — suggested joins between tables (reviewed separately; see step 6)
* The main pane shows a **diff table** for the selected review section: current value vs proposed value, plus **Justification** (rationale) and **Confidence** when available — shown only to help you during review.

{% hint style="info" %}
Justification and confidence are not saved with your metadata and are not available to the AI assistant.
{% endhint %}

Only review sections that still have something to review appear in the sidebar. When every proposal for a section is confirmed and applied, that section disappears from the list.

#### 4. Decide on proposals

For each row you can:

* **Accept** the proposal (keep it for application)
* **Reject** it (discard it; it will not be applied to your metadata)
* Leave it **undecided** for later

You can mix accepts and rejects in the same review section before confirming.

Use the sticky action bar at the top of the pane:

* **Accept all** / **Reject all** — apply to the rows currently visible (respects the table filter)
* **Reset** — clear local decisions on the visible rows
* Badges show how many proposals are **to apply** and **to discard** across the whole review section (including decisions made under a previous filter)

Optionally filter the table by one or more tables so you can review a large run in smaller batches.

{% hint style="info" %}
Leaving a proposal undecided does not block confirmation of the others. Undecided rows stay pending for a later pass on the same review section.
{% endhint %}

#### 5. Confirm and apply a section

* When you are ready, click the confirm button for that review section (for example **Confirm type casts**).
* Confirm the dialog (**Confirm this section?**). Toucan AI locks that section and starts applying accepted proposals; rejected ones are removed. Apply cannot be cancelled.
* While applying, the UI shows that changes are being applied. Rows disappear as writes land on your metadata.
* If apply fails part-way, what already landed stays applied; remaining confirmed proposals are retried on the next apply of that section.

<figure><img src="https://4270790459-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fl0BD9cL6TJjTGV95tGak%2Fuploads%2Fgit-blob-62dc2ba7b8bcb79d22a644cf8bf5b3cc25705854%2Fai_analysis_review_confirm.png?alt=media" alt="Confirm this section dialog over the type casts diff table"><figcaption></figcaption></figure>

Repeat for each remaining column review section until the run shows nothing left to review for casts, display names, and descriptions.

#### 6. Relationship suggestions

During analysis, Toucan AI also looks for **relationships** between tables. From the run review sidebar, open **Relationships** to land on **Suggested joins**.

* Decide row by row (**Keep** / **Reject**), or use **Keep all** / **Reject all** / **Reset**.
* Each suggestion shows relevance (confidence) and a justification.
* Click **Confirm** to apply kept joins. Suggested joins are not applied through the column proposal confirm buttons.

<figure><img src="https://4270790459-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fl0BD9cL6TJjTGV95tGak%2Fuploads%2Fgit-blob-c0c397cd0ce163c29459cc627444c872033e132a%2Fai_analysis_suggested_joins.png?alt=media" alt="Suggested joins tab with relevance and justification per join"><figcaption></figcaption></figure>

#### 7. When everything is reviewed

After all column proposals for a run are confirmed, the AI analyses list shows **All AI proposals have been reviewed** for that run (instead of **To review**).

<figure><img src="https://4270790459-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fl0BD9cL6TJjTGV95tGak%2Fuploads%2Fgit-blob-375a96837ab81e99f73d1a8a3f113531891a113d%2Fai_analysis_runs_completed.png?alt=media" alt="Analysis run showing All AI proposals have been reviewed"><figcaption></figcaption></figure>

***

### Edge cases

| Situation                           | What to do                                                                                                                  |
| ----------------------------------- | --------------------------------------------------------------------------------------------------------------------------- |
| Run completed with **no proposals** | Nothing to review: the analysis found nothing to change, or everything was already confirmed.                               |
| Run **failed** or **cancelled**     | Launch a new analysis on the same or a smaller set of tables. Previous completed runs and their proposals remain available. |
| Partial re-analysis                 | Starting a new run on a subset of tables does **not** delete older runs. Review each run independently.                     |
| Schema changed after the run        | Prefer a new analysis (and/or **Refresh Schema**) so proposals match the current structure.                                 |

***

### Constraints

* Proposals are **not** applied until you confirm a review section.
* Confirmation is **per review section**: you can apply casts today and leave descriptions for tomorrow.
* Analysis consumes [AI credits](/getting-started/credits-and-usage.md); reviewing and confirming does not add a separate enrichment charge.

***

### Conclusion

Confirmed proposals update your semantic metadata. Tables included in the analysis are marked **Available for chat and charts** by default.

**Suggested Next Step**: [Complete metadata information](/build/semantic-layer/how-to/complete-metadata-information.md) or [Table Visibility Governance](/govern/table-visibility-governance.md)