Website • Docs • Examples • Blog • Slack • Twitter • Prisma 2 (Preview)

Prisma replaces traditional ORMs and simplifies database workflows:

• Access: Type-safe database access with the auto-generated Prisma client (in JavaScript, TypeScript, Go)
• Migrate: Declarative data modelling and migrations (optional)
• Manage: Visual data management with Prisma Admin

It is used to build GraphQL, REST, gRPC APIs and more. Prisma currently supports MySQL, PostgreSQL, MongoDB.

Try a Prisma example online with CodeSandbox:

• Quickstart
• Examples
• Database Connectors
• Community
• Contributing
• Prisma 2 Preview

Get started with Prisma from scratch (or use your existing database):

brew tap prisma/prisma
brew install prisma

npm install -g prisma
# or
yarn global add prisma

To setup Prisma, you need to have Docker installed. Run the following command to get started with Prisma:

prisma init hello-world

The interactive CLI wizard now helps you with the required setup:

• Select Create new database (you can also use an existing database or a hosted demo database)
• Select the database type: MySQL or PostgreSQL
• Select the language for the generated Prisma client: TypeScript, Flow, JavaScript or Go

Once the wizard has terminated, run the following commands to setup Prisma:

cd hello-world
docker-compose up -d

Edit datamodel.prisma to define your datamodel using SDL syntax. Each model is mapped to a table in your database schema:

type User {
  id: ID! @id
  email: String @unique
  name: String!
  posts: [Post!]!
}

type Post {
  id: ID! @id
  title: String!
  published: Boolean! @default(value: false)
  author: User
}

To deploy your Prisma API, run the following command:

prisma deploy

The Prisma API is deployed based on the datamodel and exposes CRUD & realtime operations for each model in that file.

The Prisma client connects to the Prisma API and lets you perform read and write operations against your database. This section explains how to use the Prisma client from Node.js.

Inside the hello-world directory, install the prisma-client-lib dependency:

npm install --save prisma-client-lib

To generate the Prisma client, run the following command:

prisma generate

Create a new Node script inside the hello-world directory:

touch index.js

Add the following code to it:

const { prisma } = require('./generated/prisma-client')

// A `main` function so that we can use async/await
async function main() {
  // Create a new user with a new post
  const newUser = await prisma.createUser({
    name: 'Alice',
    posts: {
      create: { title: 'The data layer for modern apps' }
    }
  })
  console.log(`Created new user: ${newUser.name} (ID: ${newUser.id})`)

  // Read all users from the database and print them to the console
  const allUsers = await prisma.users()
  console.log(allUsers)

  // Read all posts from the database and print them to the console
  const allPosts = await prisma.posts()
  console.log(allPosts)
}

main().catch(e => console.error(e))

Finally, run the code using the following command:

node index.js

const usersCalledAlice = await prisma
  .users({
    where: {
      name: "Alice"
    }
  })

// replace the __USER_ID__ placeholder with an actual user ID
const updatedUser = await prisma
  .updateUser({
    where: { id: "__USER_ID__" },
    data: { email: "[email protected]" }
  })

// replace the __USER_ID__ placeholder with an actual user ID
const deletedUser = await prisma
  .deleteUser({ id: "__USER_ID__" })

const postsByAuthor = await prisma
  .user({ email: "[email protected]" })
  .posts()

Here is what you can do next:

• Build an app with Prisma client
• Check out some examples
• Read more about how Prisma works

Database connectors provide the link between Prisma and the underlying database.

You can connect the following databases to Prisma already:

• MySQL
• PostgreSQL
• MongoDB

If you are interested to participate in the preview for one of the following connectors, please reach out in our Slack.

• Elastic Search
• MS SQL
• Oracle
• ArangoDB
• Neo4j
• Druid
• Dgraph
• DynamoDB
• Cloud Firestore
• CockroachDB
• Cassandra
• Redis
• AWS Neptune
• CosmosDB
• Influx

Join the discussion or contribute to influence which we'll work on next!

Prisma has a community of thousands of amazing developers and contributors. Welcome, please join us! 👋

Meet the Prisma community in person and learn about modern application development and database best practices at Prisma Day (Berlin, June 19).

• Forum
• Spectrum
• Slack
• Twitter
• Facebook
• Meetup
• GraphQL Conf
• Email

• Chinese translation of the Prisma docs (Thanks to Victor Kang)
• Awesome Prisma (Thanks to Catalin Miron)

Contributions are welcome and extremely helpful 🙌 Please refer to the contribution guide for more information.

Releases are separated into three channels: alpha, beta and stable. You can learn more about these three channels and Prisma's release process here.

Prisma 2 splits up Prisma's core functionality into 2 standalone tools:

• Photon: Type-safe database access
• Lift: Declarative data modeling and migrations

Photon and Lift are currently in Preview! Limitations include missing features, limited performance and stability issues. You can learn more about Prisma 2 in the announcement or the docs.

You can track the progress of Prisma 2 on isprisma2ready.com.