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?

1

Field Tracking

The AI Schema Builder analyses your database to identify and track all fields in all tables

2

Table Listing

After identifying the fields, it lists all tables with the relevant fields needed for your database operations

3

Automated Table Listing

With one click, all unlisted tables can be automatically listed, including each field, ensuring comprehensive database management

4

User-Friendly Interface

The tool provides an intuitive interface that simplifies database schema management, even for users with limited technical expertise

​
How to use?

  1. Navigate to Data Connectors page. Select the Database you want to work on.

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

  1. 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.
  2. The AI Schema Builder will automatically generate Logical Models for all identified Unlisted tables.
  3. The AI Schema Builder will generate the Schema for the unlisted tables and display them along with their relevant fields.
  4. Once generated, you can edit the corresponding fields by clicking the specific table.

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.

​
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

Was this page helpful?

Data ConnectorsMagic AI - Query Generator