Browse project data
Inspect or edit records during local development.
Prisma · Command
prisma studio
prisma studio starts a local web interface for interactively browsing and managing database data. It can use Prisma project configuration or a direct database URL.
How it works
The prisma studio CLI command starts a local web server and opens Prisma Studio in the default browser. It can use the project’s Prisma configuration or connect directly to a database with --url, while options can customize the port, browser, and configuration path.
Syntax
prisma studio [options]Parameters
| Name | Type | Description |
|---|---|---|
options | optional CLI options | Options controlling Studio startup, including --port, --browser, --config, --url, and --help. |
Returns
Starts a local Studio web server and opens it in a browser; the default port is 5555.
Key points
- Studio provides a local browser interface for interactively viewing and managing database records.
- Use
--portto select the port on which the local Studio server listens. - Use
--browserwhen the automatically opened browser should be selected explicitly. - Use
--configwhen the Prisma configuration file is not at its usual project location. - Use
--urlto provide a direct database connection and override the Prisma configuration.
Common mistakes
- Only PostgreSQL, MySQL, and SQLite are supported; CockroachDB and MongoDB are not currently available.
Example: Connect directly with a URL
npx prisma studio --url="postgresql://user:password@localhost:5432/yourdb"Starts Studio against the supplied database and opens its local web interface.
When to use it
Use a direct connection URL
Open a database without relying on project configuration.
Customize local startup
Run Studio on a non-default port or with a selected browser.
Interview questions
QWhat does prisma studio do?
It starts a local web server and launches a browser-based interface for browsing and managing database data. The default local address uses port 5555.
Follow-up: How can it be used without a Prisma project? Pass a database connection string with --url, allowing Studio to connect directly and inspect the database schema.
QHow do you connect Studio directly to a database?
Run prisma studio --url="<connection-string>". The URL option supplies the database connection directly instead of relying on project configuration.
Follow-up: What happens if both project configuration and --url are available? The command-line URL takes precedence over the configured connection.
QWhich useful options does the command provide?
The documented options include --port for the listening port, --browser for the browser to open, --config for a custom Prisma config path, and --url for a direct connection string.
Follow-up: Which databases are supported? The current page lists PostgreSQL, MySQL, and SQLite; CockroachDB and MongoDB are not supported yet.
Related
Prisma CLIPrisma config filePrisma schemaPrisma ORM