Using Prisma Studio
1. Launching Prisma Studio
| Command | Detail |
|---|---|
prisma studio | Local UI on http://localhost:5555 |
| Auth | Local-only by default |
2. Viewing Table Data
| Feature | Detail |
|---|---|
| Spreadsheet view | One tab per model |
| Hide columns | Toggle per column |
| Pagination | Built-in |
3. Creating New Records
| Step | Detail |
|---|---|
| Add record | Click "+" toolbar |
| Fill required | Mandatory fields highlighted |
| Save | Commit batch with green button |
4. Editing Existing Records
| Aspect | Detail |
|---|---|
| Inline edit | Click cell, type, Enter |
| Bulk update | Edit multiple, save once |
5. Deleting Records
| Step | Detail |
|---|---|
| Select rows | Checkbox column |
| Delete | Confirms before commit |
6. Filtering and Searching Data
| Feature | Detail |
|---|---|
| Filter | Operator + value per column |
| Sort | Click column header |
| Saved views | Persisted per project |
7. Navigating Relations
| Feature | Detail |
|---|---|
| Drill-in | Click FK cell → opens related row |
| Reverse view | Related count link opens child list |
8. Configuring Custom Port
npx prisma studio --port 6000 --browser none| Flag | Detail |
|---|---|
--port | Override default 5555 |
--browser none | Disable auto-launch |
9. Managing Multiple Models
| Aspect | Detail |
|---|---|
| Tabs | One per model, persisted |
| Sidebar | Quick model switcher |
10. Exporting Data
| Format | Notes |
|---|---|
| CSV | Via current view (Studio toolbar) |
| JSON | Programmatic via Prisma client |