Browse Database Structure

Database Structure

Build a Schema Manually

Create schema context by entering tables, columns, data types, keys, and relationships yourself.

Steps

1

Choose Build Schema

Open Write SQL with AI and select the Build Schema option.

2

Add tables and columns

Enter the table name, then add each column and choose an appropriate data type.

3

Mark keys and relationships

Identify primary keys and define foreign-key connections where they are known.

4

Review and continue

Confirm the manual structure before using it in the SQL Generation Workspace.

Open the relevant SQL Mocker tool

Continue with this workflow in SQL Mocker when you are ready.

Related documentation