> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datachecks.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Migration Assessment Agent

> Analyze stored procedures, views, and SQL complexity in your source database and get a structured migration readiness report.

The Migration Assessment agent analyzes your source database to evaluate migration complexity before you begin. It examines stored procedures, views, and translation difficulty, then generates a structured assessment dashboard with an executive summary and detailed findings.

## What it does

* Analyzes stored procedures for migration complexity
* Evaluates views and their dependencies
* Assesses translation difficulty for SQL logic in the source dialect
* Generates an assessment dashboard with an executive summary and detailed findings
* Lets you refine and update the assessment through chat

## Create an agent

1. Go to the **Agents** tab in the left sidebar.
2. Click **Create Agent**.
3. Select **Migration Assessment** as the agent type.
4. Select the source data source, and add a name and description for the agent.
5. Select the target database type (for example, Snowflake, BigQuery, Databricks).
6. Click **Create** to save.

## Run an agent

1. Go to the **Agents** tab and click the agent you created.
2. Click **Run** to start the assessment. The agent analyzes your source database and produces an assessment dashboard.
3. You can create multiple runs and view previous runs at any time.

## Assessment dashboard

When the run completes, the agent produces an assessment dashboard you can use to evaluate migration readiness. The dashboard includes:

| Section                  | Description                                                                      |
| ------------------------ | -------------------------------------------------------------------------------- |
| **Executive Summary**    | High-level migration readiness score and key findings                            |
| **Procedure Analysis**   | Per-procedure complexity assessment and migration notes                          |
| **View Analysis**        | View dependency mapping and complexity flags                                     |
| **Translation Analysis** | Assessment of SQL constructs that require translation, with complexity estimates |

You can continue the conversation in the chat to ask follow-up questions, request a deeper analysis of specific objects, or update the scope. The agent will modify the assessment dashboard based on your input.
