The Nobregas MySQL Panel features a powerful visual table builder that lets you design database tables without writing a single line of SQL. Add columns, set data types, configure keys — all through an intuitive point-and-click interface.
Accessing the Table Builder
- Log in at mysql.nobregas.org.
- Click Databases in the top navigation bar.
- Click the Manage button (or click the database name) next to the database where you want to create a table.
- Click the Create Table button at the top right.
If the database has no tables yet, the builder appears inline on the page with a friendly prompt to create your first table. Otherwise, a modal window opens.
Step 1: Enter a Table Name
At the top of the builder, type a name for your table in the Table Name field. Use descriptive, lowercase names with underscores:
usersproductsorder_itemsblog_posts
Table names can be up to 64 characters long and should contain only alphanumeric characters and underscores.
Step 2: Add Columns Using Quick Templates
The builder provides Quick Add buttons for common column types. Click any of these to instantly add a pre-configured column:
| Template | Column Created | Data Type |
|---|---|---|
| ID (Auto) | id |
INT, Primary Key, Auto Increment |
| Name | name |
VARCHAR(255) |
email |
VARCHAR(255) | |
| Text | content |
TEXT |
| Number | amount |
INT |
| Decimal/Price | price |
DECIMAL(10,2) |
| Yes/No | is_active |
TINYINT(1), Default 0 |
| Date | date |
DATE |
| Date & Time | datetime |
DATETIME |
| Timestamps | created_at + updated_at |
TIMESTAMP |
| Password | password |
VARCHAR(255) |
| JSON | data |
JSON |
Step 3: Add Custom Columns Manually
Click the Add Column Manually button to add a blank column row. For each column, configure:
- Column Name — The name of the column (e.g.,
phone_number). - Data Type — Choose from INT, BIGINT, DECIMAL, VARCHAR, TEXT, TINYINT, DATE, DATETIME, TIMESTAMP, or JSON.
- Primary Key — Check if this column is the primary key.
- Auto Increment — Check to auto-generate sequential values (usually paired with primary key).
- Nullable — Check if the column can contain NULL values.
- Default Value — Optionally set a default.
Step 4: Review and Create
The builder shows a column count so you can verify how many columns you have added. Review your columns, then click Create Table.
The table is created instantly on your MySQL node. You will see it appear in the tables list, ready for data.
Tips for Good Table Design
- Always start with an auto-increment ID column as the primary key.
- Use VARCHAR for short text and TEXT for long content.
- Use DECIMAL for money/prices — never use FLOAT for financial data.
- Add created_at and updated_at timestamps for audit trails.
- Keep column names descriptive and consistent (snake_case recommended).
