AYCC DB Designer

AYCC DB Designer is the tool for designing and managing spreadsheet-like databases. It lets you create bases, tables, fields, rows, views, integrations, and data sources connected to NocoDB.

Access

The recommended way is to open DB Designer from MainApp_DEMO. Locally, you can open http://localhost:5175.

Path	Purpose
/login	User login
/signup	Registration
/bridge	Access through MainApp_DEMO
/password-setup	Password setup for bridge-created users
/onboarding	Guided first project creation
/	Protected operational home
/integrations	Connections and integrations
/settings	Settings

Main Concepts

Concept	Meaning
Base	Main data project container
Table	A set of columns and rows inside a base
Field	A table column, with type and settings
Row	A table record
View	A filtered or organized view of data
Connection	A connection to an external database such as PostgreSQL or MySQL
Data source	A data source linked to a base

Operational Home

The Home page is the main hub. From there you can create a base, select an existing base, create tables, open tables, import data, manage views, add data sources, invite members, and access integrations.

Creating a Base

1. Open the sidebar.
2. Select Create Base.
3. Enter a clear name.
4. Confirm creation.
5. Wait for the base list to reload.

Creating a Table

1. Select the correct base.
2. Use the create table action.
3. Enter the table title.
4. Confirm.
5. Open the table to add fields and rows.

Fields and Columns

Add fields from the dedicated menu. Each field has a type, such as text, number, date, boolean, or a more advanced format.

Stable names

Avoid renaming fields that are already used by Form Builder. A name change can break links, filters, or views.

Rows

The dynamic table lets you view rows, edit cells inline, add new rows, delete rows, open JSON or complex content, and see loading status.

Data Import

DB Designer includes dialogs for importing CSV, Excel, JSON, Airtable when configured, and connected external sources.

Table Actions

From the table menu you can rename the table, duplicate the structure, or delete it.

Deleting tables

Deleting a table can remove data and break Builder forms. Do it only after checking dependencies and backups.

Integrations and Data Sources

The Integrations page manages external database connections, mainly PostgreSQL and MySQL. After creating a connection, you can add a data source to a base by choosing an alias and the connection.

Relationship with Form Builder

Use DB Designer to prepare the data structure. Use Form Builder to create interfaces that read or write that data.