Prisma Data Platform - Prisma ORM on Cloud

Prisma Data Platform is a cloud based service which allows developers to try the Prisma ORM, run queries on cloud environment without the need to install Prisma Client locally on the developers' computer.

Features of Prisma Data Platform

Free database provisioning
Pre defined model schema templates
Run and test Prisma Queries on the data
Collaboration between team members
Data browsing capabilities

Getting Started

To get started, visit Prisma Data Platform, sign in with your GitHub Account and click on New Project. From here, we may choose to go in two different ways:

Create new project from scratch
Import existing project from GitHub

Creating Project

Creating a project is simple on Prisma Data Platform. Once you create the project on Prisma Data Platform it will simultaneously create a GitHub Project for it.

Creating Database

Prisma Data Platform can automatically spin an app instance on heroku and create a PostgreSQL database instance as well. You may connect to an existing database as well.

Creating Schema

One of the great features of Prisma Data Platform is that it provides pre written schemas for our database. We can even customise the schema if we want. Also it loads sample data to our database so that we can try out our queries on those data.

For this blog, I would be using the URL Shortener template.

Once the schema has been created, it pushes the schema.prisma file to the GitHub Repository and also adds a Readme.md file to the repo which contains all the instructions for setting up and running the project locally and also the Database ER diagram for ready reference like the one shown below:

This ER Diagram is generated using:

Prisma on Cloud Functionalities

The Prisma on cloud contains several functionalities such as

Guide to Local Setup
Data browser (Prisma Studio)
Query Console

Local Setup

Prisma on Cloud gives a robust documentation to setup the same project on your local development environment with the option to setup local database or connect to a remote database.

Data Browser

Prisma on Cloud provides Prisma Studio out of the box for data browsing on cloud. It helps developers edit data in database tables without a local database client.

Query Console

The query console is the heart of Prisma Data Platform. It allows us to write and try out complex queries on the sample dataset. It can even serve as a scratch pad for your queries during the development phase of your application. It helps to instantly get output of a query without having to write APIs and console logs for the same.

The Query console supports code highlighting, auto complete, auto saves queries and also code linting features.

Collaborate with users

Prisma on cloud also allows developers to collaborate with fellow developers, just by inviting a GitHub user to the Prisma Project. It also gives various types of permissions for collaborators such as Admin, Developer, Viewer etc which grants restricted access to the Prisma project.

Admins can even modify access of collaborators and can remove them from project if at some point they think it's necessary to do so.

What's next for Prisma Data Platform?

Support for other database dialects
Multiple environments support to facilitate and organise projects and initiate workflows between them
Insights such as query times, generated SQL Script about the Query ran in the Query console
Telemetry events integration from Prisma queries to 3rd party external services supporting Open Telemetry Framework
Insights about list of queries in the application

[Please note: All the above mentioned points are subject to change and are not guaranteed]

Contribute to Prisma

Prisma ORM is Open Source and available publicly on GitHub. If you want to contribute to the Prisma check out their GitHub Repository by clicking here.

Blog