SKILL.md
prisma studio
Opens a visual database browser for viewing and editing data.
Command
prisma studio [options]What It Does
- Starts a web-based database GUI
- View all your models and records
- Create, update, and delete records
- Filter and sort data
- Navigate relations
Options
| Option | Description | Default |
|---|---|---|
--port / -p |
Port to start Studio on | 5555 |
--browser / -b |
Browser to open Studio in | System default |
--config |
Custom path to your Prisma config file | - |
--url |
Database connection string (overrides the one in your Prisma config) | - |
Examples
Open Studio
prisma studioOpens at http://localhost:5555
Custom port
prisma studio --port 3000Specific browser
prisma studio --browser firefoxDon't open browser
BROWSER=none prisma studioUseful for remote servers.
Features
View Records
- See all records in table format
- Pagination for large datasets
- Column sorting
Filter Data
- Filter by any field
- Multiple conditions
- Relation filtering
Edit Records
- Click to edit inline
- Add new records
- Delete records (with confirmation)
Navigate Relations
- Click relations to view related records
- See counts of related items
- Follow relation links
Use Cases
- Development: Quick data inspection
- Debugging: Check data state
- Testing: Verify seed data
- Demo: Show data to stakeholders
Limitations
- Development tool only
- Not for production use
- Limited to configured database
- No advanced queries (use Prisma Client for that)
Common Workflow
- Run migrations:
``bash prisma migrate dev ``
- Seed data:
``bash prisma db seed ``
- Open Studio to verify:
``bash prisma studio ``
- Make manual edits if needed
Security Note
Studio provides direct database access. Only run on:
- Local development machines
- Secure internal networks
- Never expose publicly