prisma-studio-next

A fork of Prisma Studio, the visual editor for browsing and editing your database, with sharding support, a more polished interface, and support for more databases.

Everything the original does, this still does: explore your schema, browse and edit table data, filter, sort and page through records, follow relations between tables, and run SQL.

The Two Libraries

| Library | What it is | | ---------------------- | ----------------------------------------------------------------------------------------------------------------- | | @prisma/studio-core | Prisma's official library — the one behind Prisma Studio in the Prisma CLI and Prisma Console | | prisma-studio-next | This package. The same editor, forked and maintained separately, with the improvements below |

It is published under its own name so it is never mistaken for, or published over, Prisma's official library.

Where It Is Used

prisma-sharding — a library and CLI for running an application across many database shards — uses this package as its database editor.

Starting Studio from the prisma-sharding CLI opens a single editor that covers every shard, with a shard picker in the header. Switching shards keeps you in the same place instead of sending you to a new tab, and you are warned before switching away from edits you have not saved yet. Without this fork, inspecting several shards meant one browser tab per database, with no way to tell at a glance which tab pointed where.

What This Fork Adds

Sharding. One editor for every shard, a shard picker in the header, and a warning before you leave unsaved edits behind.

Interface and experience.

• Scrolling sideways through wide tables is smooth, and the last column is actually reachable
• Column widths and your custom column order survive pinning and unpinning
• The schema diagram remembers how you arranged the tables, per schema, even after a reload
• The total number of rows is shown as you browse, and reflects any filters or search in use
• Dark mode covers the whole page rather than stopping at the edges of the editor

Database support.

• MariaDB databases can be read, not just MySQL
• Secure connections using certificate files work as expected
• On PostgreSQL, list columns built from a fixed set of options can be edited, and column types are labelled with their familiar names rather than internal ones
• On SQLite, date and timestamp columns can be edited without their values being mangled
• Newer identifier formats are accepted when filtering
• The editor works when opened over a local network address, not just on your own machine

Licensed Apache-2.0. See NOTICE for the Prisma brand terms, which this fork preserves.