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

# Magic AI - GraphQL Schema Builder

The Magic AI Schema Builder is an advanced tool designed to help you track and manage all fields in all tables within a specific database. It automatically identifies fields, lists tables with the relevant fields, and allows you to list all unlisted tables with a single click.

## How it works?

<Steps>
  <Step title="Field Tracking">
    The AI Schema Builder analyses your database to identify and track all fields in all tables
  </Step>

  <Step title="Table Listing">
    After identifying the fields, it lists all tables with the relevant fields needed for your database operations
  </Step>

  <Step title="Automated Table Listing">
    With one click, all unlisted tables can be automatically listed, including each field, ensuring comprehensive database management
  </Step>

  <Step title="User-Friendly Interface">
    The tool provides an intuitive interface that simplifies database schema management, even for users with limited technical expertise
  </Step>
</Steps>

## How to use?

1. Navigate to Data Connectors page. Select the `Database` you want to work on.
   <img src="https://mintcdn.com/zeromagiclabsprivatelimited/h_DeJnPWvd8dA9lO/assets/images/datamanager.png?fit=max&auto=format&n=h_DeJnPWvd8dA9lO&q=85&s=0592413c00c84148fa15ae18a2ec7fb5" alt="datamanager" width="1135" height="300" data-path="assets/images/datamanager.png" />

2. Click the `AI Schema Builder` button located in the top right corner of the page

<img src="https://mintcdn.com/zeromagiclabsprivatelimited/h_DeJnPWvd8dA9lO/assets/images/ai-schema-builder.png?fit=max&auto=format&n=h_DeJnPWvd8dA9lO&q=85&s=cced649adaab65549b7c247828ca61a8" alt="ai-schema-builder" width="1096" height="222" data-path="assets/images/ai-schema-builder.png" />

3. The AI Schema Builder will start analysing all `Unlisted tables` in your database. Once the scan is complete, the AI Schema Builder will identify and list all relevant fields for each `Unlisted table`.
4. The AI Schema Builder will automatically generate `Logical Models` for all identified Unlisted tables.
5. The AI Schema Builder will generate the `Schema` for the unlisted tables and display them along with their relevant fields.
6. Once generated, you can edit the corresponding fields by clicking the specific table.

<img src="https://mintcdn.com/zeromagiclabsprivatelimited/h_DeJnPWvd8dA9lO/assets/images/ai-model-page.png?fit=max&auto=format&n=h_DeJnPWvd8dA9lO&q=85&s=51f3ef45b55b00e85cfb0a0c54da266a" alt="ai-model-page" width="1477" height="843" data-path="assets/images/ai-model-page.png" />

<Tip>
  The Magic AI Schema Builder may not always perfectly understand the relationships between your data.
  It is crucial to review its recommendations and adjust them based on your specific needs.
</Tip>

## Benefits

* **Save Time**: Automating field detection and table selection significantly reduces the manual effort required for schema creation.
* **Increase Efficiency**: Streamline your workflow by automating a significant portion of the schema creation process.
* **Simplicity**: Simplifies database schema management with an easy-to-use interface and automated processes.

## FAQs

<Accordion title="Can the Magic AI Schema Builder handle complex database schemas?">
  Yes, the Magic AI Schema Builder is designed to handle complex database schemas with multiple tables and fields.
</Accordion>