Bluehost AI Builder: Understanding Your App's Database Structure

Every app you build with Bluehost AI Builder comes with its own database. When a visitor submits a form, books an appointment, or creates an account, the app saves that information as records in data tables. The content your site displays, such as your services, menu items, team members, or locations, is often stored the same way.

You don’t need to know how databases work to use AI Builder. But when your app grows, it helps to understand how your data is organized, especially before you ask AI Builder to change it. This article explains the parts of your app’s data structure, how to view them, and how to make structural changes without losing or breaking the data you already have.

If you’re new to forms and submissions, start with Bluehost AI Builder: How to Create and Validate Forms.

How Your App Stores Data

AI Builder designs your app’s database based on what you ask it to build. A booking app for a cleaning service, for example, might store its data in tables for clients, services, time slots, and bookings. Your app’s database is made of four parts:

Fields and Field Types

Each field holds one type of information, such as text, a number, a date and time, a yes-or-no value, or a choice from a list. The field type controls what can be saved. A date field, for example, only accepts dates, so you can sort bookings by day.

Relationships Between Tables

Relationships keep your data connected without saving the same information twice. Instead of retyping a client’s name and phone number on every booking, each booking points to the client’s record. When the client updates their phone number, every booking shows the new number.

The most common relationship is one-to-many: one client can have many bookings, but each booking belongs to one client.

AI Builder doesn’t display field types or relationships in its interface. The Manage view shows your app’s tables and the data in each record. To see each field’s type and how your tables are linked, ask AI Builder to describe your data structure, as shown later in this article.

Data vs. Design: What You Change Where

Your app has two kinds of content, and each one is changed in a different place.

For example, to change the price of a service, edit the service’s record in the admin panel. To add a new Duration field to every service, ask AI Builder. Adding a field changes the structure of the table, not just one record.

View Your App’s Tables and Data

You can see your app’s data in the Manage view inside AI Builder, or in your app’s admin panel on your live site. Both show the same data.

View Tables in the Manage View

1. Log in to your Bluehost Portal.
2. In the left menu, under Bluehost AI, click AI Builder.
3. Under Your apps, click your app.
4. Above the preview, click the Manage icon (the cube icon next to Preview and the Settings gear).
5. The Dashboard opens with a summary of recent activity, such as entries awaiting a reply and upcoming items.
6. In the left menu, each section, such as Bookings, Clients, or Services, shows the records in one of your app’s tables. The sections depend on what your app stores.
7. Click a section to browse its records. Click a record to see or edit its fields.

The Manage view is built for your app. AI Builder creates a section for each table and feature in your app, so a booking app might show Bookings and Time Slots, while a client portal might show Clients and Documents. When AI Builder adds a table or field, it appears here too.

You can also sign in to your app’s admin panel at /admin/login on your site. Opening the admin from your AI Builder workspace signs you in without a password. To use /admin/login, set a password first from your profile in the admin. For steps, see Sign In to Your App’s Admin.

Ask AI Builder to Describe Your Data Structure

The Manage view shows your records. To see the full structure, including every field, its type, and how tables are linked, ask AI Builder. Include “Don’t change anything” so the builder only describes the structure:

PromptCopy

List every data table in my app. For each table, show its fields, the type of each field, which fields are required, and how it links to other tables. Don't change anything.

Save the builder’s answer. It’s a useful reference before you ask for structural changes later.

Make Structural Changes Safely

A structural change adds, renames, or removes a table, a field, or a relationship. Some changes are low risk. Others can hide, break, or permanently delete data you already have. The table shows common changes, the risk to existing records, and a safer way to ask.

Save a Copy Before Removing Data

AI Builder doesn’t include a built-in export or an undo button. Before you remove a field or table, ask AI Builder to add a CSV export to your admin panel, then download a copy of the records you’re about to remove.

One Change per Message

Ask for one structural change at a time, and name the exact table and field. After each change, check your data before you ask for the next one. If something goes wrong, a single change is easier to spot and fix.

Before and After a Structural Change

Before you ask for the change:

1. Ask AI Builder to describe your current data structure, and save its answer.
2. If the change removes or converts data, export a copy of the affected records.
3. Write the prompt so it names the table and field, says what to change, and says what to keep.

After AI Builder makes the change:

1. Open the Manage view and check that your existing records are still there and their values look right.
2. Check that any new or renamed fields appear in the right sections of the Manage view.
3. Test every form and page that uses the changed table. Submit a test entry and confirm it saves correctly, then delete the test entry. Test entries are saved in the same database as your live app.
4. When everything works, click Publish to make your updated pages and forms live.

If Something Goes Wrong

There’s no undo button. Ask AI Builder to make the change in reverse, and be specific. For example: “Add the Phone field back to Clients with its values.” A reverse request uses a credit, and data that was deleted may not come back, which is why saving a copy first matters.

Prompt Templates for Data Changes

Copy a template, replace the bracketed parts, and send it to AI Builder.

Describe Your Data Structure

PromptCopy

List every data table in my app. For each table, show its fields,
the type of each field, which fields are required, and how it links
to other tables. Don't change anything.

Add a Field

PromptCopy

Add an optional [field name] field to the [table name] table.
Show it on the [page or form name]. Leave all existing records unchanged.

Add a New Table Linked to an Existing One

PromptCopy

Add a [new table name] table with these fields: [field 1], [field 2], [field 3].
Link each [new table] record to one [existing table] record.
Add a section for it in the admin panel. Don't change the existing tables.

Rename a Field Without Losing Data

PromptCopy

Rename the [old field name] field in [table name] to [new field name].
Keep every existing value, and update every page and form that uses it.

Remove a Field Safely

PromptCopy

Before you change anything, tell me which pages, forms, and tables use
the [field name] field in [table name]. Don't remove anything yet.
I'll confirm before you make the change.

Frequently Asked Questions

Related Articles

• Bluehost AI Builder: How to Create and Validate Forms
• Bluehost AI Builder: How to Make Changes After Build
• Bluehost AI Builder: How to Connect Your Website or App to Other Tools
• Bluehost AI Builder: Frequently Asked Questions

Summary

Your Bluehost AI Builder app stores its data in tables made of fields, records, and relationships. Edit records yourself in the Manage view or admin panel, and ask AI Builder for changes to the structure. Before a structural change, describe the current structure, save a copy of any data you might lose, and ask for one change at a time. After each change, check your records and test your forms before you publish.