Prisma Studio

Prisma Studio is a standalone visual database editor that lets you view and manipulate data directly in your browser. Prisma 7 introduces a new standalone Studio that works with or without Prisma ORM.

Unlike previous versions, the new Prisma Studio is SQL-driven and does not rely on the Prisma schema file at all. Instead, it introspects your database directly to understand the schema structure. This means you can use it with any supported database without needing a Prisma schema or project.

Note that Prisma Studio is not open source but you can still create issues in the prisma/studio repo. All "old Studio" issues are being closed as there won't be any further work on the previous version.

Prisma Studio is a standalone tool that only requires a database connection. You have two options:

Connect directly to any supported database using the --url flag:

bunx prisma studio --url="postgresql://user:password@localhost:5432/dbname"

pnpm prisma studio --url="postgresql://user:password@localhost:5432/dbname"

yarn prisma studio --url="postgresql://user:password@localhost:5432/dbname"

npx prisma studio --url="postgresql://user:password@localhost:5432/dbname"

This approach works without any Prisma ORM setup—Studio will introspect your database schema directly.

If you have an existing Prisma project, Studio can read your database connection configuration:

• A prisma.config.ts configuration file with database connection details
• A configured database connection

To launch Prisma Studio with any database, provide a connection URL:

bunx prisma studio --url="postgresql://user:password@localhost:5432/dbname"

pnpm prisma studio --url="postgresql://user:password@localhost:5432/dbname"

yarn prisma studio --url="postgresql://user:password@localhost:5432/dbname"

npx prisma studio --url="postgresql://user:password@localhost:5432/dbname"

If you have a Prisma project, run the following command in your project directory:

bunx prisma studio --config ./prisma.config.ts

pnpm prisma studio --config ./prisma.config.ts

yarn prisma studio --config ./prisma.config.ts

npx prisma studio --config ./prisma.config.ts

Both commands start a local web server (default port 5555) and open Prisma Studio in your browser. Studio connects directly to your database and introspects the schema in real-time to provide a visual interface for your data—no Prisma schema file required.

Prisma Studio provides several key capabilities for working with your database:

Studio displays all tables from your database in a sidebar. Select any table to view its data in a table format. You can open multiple tables in separate tabs to work with related data simultaneously.

You can edit data in two ways:

• Inline editing: Double-click any cell to edit its value directly in the table
• Side panel editing: Click the edit icon next to a record to open a detailed view with all fields

Changes are accumulated and must be saved explicitly using the save button. This lets you make multiple edits before committing them to the database.

Create new records by clicking the "Add record" button. Studio provides appropriate input controls based on each field's data type:

• Text fields for strings
• Number inputs for integers and decimals
• Date pickers for datetime fields
• Dropdowns for enums and boolean values
• Relation selectors for foreign keys

Select one or more records using the checkboxes and click the delete button. Deletions require confirmation and are applied immediately (they cannot be batched with other changes).

Use the Filters menu to narrow down your data:

• Add conditions using comparison operators (equals, greater than, less than, etc.)
• Combine multiple filters with AND logic
• Clear individual filters or all filters at once

Customize your view:

• Fields menu: Show or hide specific columns
• Showing menu: Control pagination with "Take" (limit) and "Skip" (offset) options

Click any column header to sort by that field. Click again to toggle between ascending and descending order.

Studio supports keyboard shortcuts for common operations. Press Cmd+/ (macOS) or Ctrl+/ (Windows) to view all available shortcuts.

Studio displays visual indicators for different field types in your database:

• Text fields: String values
• Number fields: Integers and decimals
• Date/time fields: Timestamps and dates
• Boolean fields: True/false values
• Enum fields: Predefined list of options
• Relation fields: References to records in other tables (foreign keys)
• JSON fields: Structured JSON data

These visual cues help you quickly understand your data structure as Studio introspects it directly from your database.

Prisma Studio currently supports the following databases: PostgreSQL, MySQL, and SQLite.

• File paths must have a file: protocol right now in the database url for SQLite

• Node.js 22.5+: Works out of the box with the built-in node:sqlite module

  • May require NODE_OPTIONS=--experimental-sqlite environment variable

• Node.js 20: Requires installing better-sqlite3 as a dependency

  • If using pnpm 10+ with pnpx, you'll need the --allow-build=better-sqlite3 flag

• Deno >= 2.2: Supported via built-in SQLite module

• Bun: Support for Prisma Studio with SQLite is coming soon and is not available yet

Support for CockroachDB and MongoDB is not currently available but may be added in future releases. If you're using these databases:

• CockroachDB: Explore the options suggested by CockroachDB
• MongoDB: Use MongoDB Atlas, MongoDB Compass, or the MongoDB shell

When connecting to PostgreSQL databases, you may encounter this error if your connection string includes the schema query parameter:

unrecognized configuration parameter "schema"

This happens because the new Studio is standalone and passes your connection URL directly to the PostgreSQL driver without any processing. The URL you provide—whether via prisma.config.ts or the --url flag—must be a valid PostgreSQL connection string that only uses standard PostgreSQL connection parameters.

The schema parameter was a custom Prisma ORM parameter that worked in v6 and earlier, but PostgreSQL itself doesn't recognize it.

To resolve this issue, use the standard search_path parameter instead:

# ❌ This will cause an error

postgresql://user:password@host:port/database?schema=my_schema

# ✅ Use this instead

postgresql://user:password@host:port/database?options=-c%20search_path%3Dmy_schema

Alternatively, you can remove the schema parameter entirely if you're using the default public schema, as PostgreSQL defaults to it automatically.

For more details, see the related GitHub issue.

Caching issues may cause Prisma Studio to use an older version of the query engine. You may see the following error:

Error in request:  PrismaClientKnownRequestError: Failed to validate the query Error occurred during query validation & transformation

To resolve, delete the following folders:

• ~/.cache/prisma on macOS and Linux
• %AppData%/Prisma/Studio on Windows