Schemas

AI in schema editing

AI shows up in several small helpers while you edit a schema, and in one larger one, the Schema Agent. In every case AI proposes and you decide: nothing is applied until you click to apply it.

Where AI helps

Helper Where What it does
Suggest Names Table page, Columns or Info tab; Create Derivative Table Proposes better table and column names that follow the schema’s naming conventions.
Bulk Add Columns Table page, Columns tab Turns lines of SQL, lists or plain language into columns.
Paste Code Tables tab › Create Table Parses a CREATE TABLE statement into a table.
Auto-generate description The magic-wand button next to a description Drafts a description from the object’s structure. Overwrites the current one.
Generate Descriptions Object lists Writes descriptions for every selected object in the background.
Add Dialect A SQL object’s SQL tab Converts the primary SQL to another dialect.
Suggest Relationships Schema Info tab Finds likely foreign keys by matching column names to primary keys.
Schema Agent Schema Schema Agent tab Reviews the schema and proposes new objects and changes you can apply with one click.

Naming suggestions

Suggest Names sends the table’s structure and the schema’s naming conventions (casing, prefixes, ID suffix, singular or plural) to AI. The dialog lists each name it would change, a drop-down of alternatives, and a short reason. Tick the ones you want and click Apply (N). See Work with tables and columns.

Tip: Set the naming conventions first, on the Settings tab. The suggestions follow them. See Schema settings.

Descriptions

Descriptions can be drafted one at a time with the auto-generate button, or in bulk with Generate Descriptions. Both overwrite what’s there, and neither can be undone, so select only what you want rewritten.

Dialect conversion

When you add a dialect to a view, procedure, function or script, AI converts the primary SQL for it. The converted tab is read-only and can be re-synced when the primary changes. If conversion fails, you get a template instead. See Work with views, procedures, functions and scripts.

The Schema Agent

The Schema Agent is a chat on the schema’s Schema Agent tab. It can read everything in the schema, answer questions about it, and propose tables, views, procedures, functions, indexes and column changes as cards you apply with Create or Apply. See Work with the Schema Agent.

Manual edits always win

AI suggestions never overwrite your work on their own. A suggestion is only applied when you click to apply it, and you can edit anything afterwards.

Note: AI features use your organization’s AI allowance. See AI token allowance and usage.