Prisma ORM 8 is here.Read the docs

Getting Started

Quick start guide for setting up and using the Prisma Console

This guide walks you through setting up your Console account and creating your first project.

Prerequisites

  • A GitHub account (for authentication)
  • A Prisma project (optional, but recommended)

Step 1: Create your account

  1. Go to console.prisma.io/login
  2. Click Sign in with GitHub
  3. Authorize Prisma Console to access your GitHub account

You now have a Console account with a default workspace.

Step 2: Set up a workspace

When you create an account, a default workspace is automatically created for you. You can create additional workspaces for different teams or organizations.

Create a workspace (optional)

To create an additional workspace:

  1. Click the workspace dropdown in the top navigation
  2. Click Create Workspace
  3. Enter a name for your workspace
  4. Click Create

Step 3: Create a project

Projects organize your databases and environments within a workspace.

Using the Console web interface

  1. Navigate to your workspace
  2. Click Create Project
  3. Enter a project name
  4. Click Create

Step 4: Create a resource

Resources are the actual databases or environments within your project.

For Prisma Postgres

  1. Navigate to your project
  2. Click Create Database
  3. Enter a database name
  4. Select a region
  5. Click Create

For Accelerate

  1. Navigate to your project
  2. Click Create Environment
  3. Enter an environment name (e.g., "production")
  4. Click Create

Step 5: Generate a connection string

Connection strings authenticate your application's requests to Prisma products.

Using the Console web interface

  1. Navigate to your resource (database or environment)
  2. Click Connection Strings tab
  3. Click Create Connection String
  4. Enter a name for the connection string
  5. Copy the connection string and store it securely
  6. Click Done

Step 6: Use the connection string in your application

Add the connection string to your .env file. For Prisma Postgres, use the pooled connection string for application queries and the direct connection string for migrations, introspection and Prisma Studio:

# Application traffic over pooled TCP
DATABASE_URL="postgres://USER:PASSWORD@pooled.db.prisma.io:5432/postgres?sslmode=require"

# Prisma CLI commands and administrative tooling
DIRECT_URL="postgres://USER:PASSWORD@db.prisma.io:5432/postgres?sslmode=require"

In a Node.js runtime, pass the pooled connection string to Prisma Client through the @prisma/adapter-pg driver adapter. In an edge or TCP-constrained runtime, use the Prisma Postgres serverless driver with the direct connection string instead.

Next steps

On this page