# Schema Designer

The Schema Designer lets you create and modify database tables visually, generate model code, and export migration files.

## Browsing Tables

The left sidebar shows all tables in the database. Click a table to view its columns and indexes.

## Creating Tables

1. Click **New Table**
2. Add columns with:
   - **Name** — Column identifier
   - **Type** — Pick from common types (INTEGER, TEXT, BOOLEAN, FLOAT, TIMESTAMP, JSONB, etc.) or enter a custom type
   - **Nullable** — Allow NULL values
   - **Primary Key** — Mark as primary key
   - **Default** — Default value expression
3. Click **Save** to execute the CREATE TABLE statement

## Editing Tables

Select an existing table to:
- **Add columns** — New column with type, nullable, default
- **Modify columns** — Change type or constraints
- **Remove columns** — Drop with confirmation
- Changes are tracked as "dirty" until saved

## Index Management

For each table:
- **View indexes** — List all secondary indexes with their columns
- **Create index** — Regular or unique, on one or more columns
- **Drop index** — Remove with confirmation

## Code Generation

Generate model boilerplate from your schema in four languages:

| Language | Output |
|----------|--------|
| **Go** | Struct with `db` and `json` tags |
| **TypeScript** | Interface or type definition |
| **Rust** | Struct with `serde` derives |
| **Python** | Pydantic `BaseModel` class |

Switch between language tabs instantly. Copy to clipboard with one click.

## Migration Export

Export pending schema changes as a SQL migration file:

1. Make changes in the designer
2. Click **Export Migration**
3. Downloads a timestamped `.sql` file (e.g., `20260308T143000_users.sql`)
4. File contains the appropriate ALTER TABLE or CREATE TABLE statements

Use with `neutron migrate` to apply migrations consistently across environments.

## Dropping Tables

Select a table and click **Drop Table**. A confirmation dialog prevents accidental deletion.