Prisma improves your database workflows and saves you from writing complex SQL queries or the intricacies of working with NoSQL APIs.
Prisma turns your database into a GraphQL API and enables the use of GraphQL as a universal query language for all databases. Instead of writing SQL or using a NoSQL API, you can query your database with GraphQL.
-
Based on OpenCRUD
-
Supports MySQL, Postgres & MongoDB
-
Simple API for joins, mutations,
filters & pagination
Prisma uses GraphQL SDL as a tool for defining the data model in your application. The data model is then translated into an actual database schema. This approach makes migration flows for your databases easy.
-
Powerful data modelling with GraphQL SDL
-
Simple database migration process
-
Faster development cycles
type User { id: ID! @unique createdAt: DateTime! name: String! admin: Boolean! @default(value: "true") }
Datamodel in GraphQL SDL
CREATE TABLE User( `id` CHAR(25), `createdAt` DATETIME NOT NULL DEFAULT CURRENT `updatedAt` DATETIME NOT NULL DEFAULT CURRENT `name` MEDIUMTEXT NOT NULL, `admin` BOOLEAN NOT NULL DEFAULT TRUE, PRIMARY KEY (`id`), UNIQUE INDEX `id_UNIQUE` (`id` ASC) )
Generated SQL
Supported
Coming Soon