Overview

Prisma needs a connection URL to be able to connect to your database, e.g. when sending queries with Prisma Client or when changing the database schema with Prisma Migrate.

The connection URL is provided via the url field of a datasource block in your Prisma schema. It generally consists of the following components (except for SQLite):

  • User: The name of your database user
  • Password: The password for your database user
  • Host: The IP or domain name of the machine where your database server is running
  • Port: The port on which your database server is running
  • Database name: The name of the database you want to use

Make sure you have this information at hand when getting started with Prisma. If you don't have a database server running yet, you can either use a local SQLite database file (see the Quickstart) or setup a free PostgreSQL database on Heroku.

Examples

Here are examples for the connection URLs of the databases Prisma supports:

PostgreSQL

1datasource postgresql {
2 provider = "postgresql"
3 url = "postgresql://janedoe:mypassword@localhost:5432/mydb"
4}

MySQL

1datasource mysql {
2 provider = "mysql"
3 url = "mysql://janedoe:mypassword@localhost:3306/mydb"
4}

SQLite

1datasource sqlite {
2 provider = "sqlite"
3 url = "file:./dev.db"
4}

Note that you can also provide the connection URL as an environment variable like so:

1datasource postgresql {
2 provider = "postgresql"
3 url = env("DATABASE_URL")
4}

You can then either set the environment variable in your terminal or by providing a dotenv file called .env. This will automatically be picked up by the Prisma CLI.

.env

1DATABASE_URL=postgresql://janedoe:mypassword@localhost:5432/mydb

Format

The format of the connection URL depends on the database connector you're using. Prisma generally supports the standard formats for each database. You can find out more about the connection URL of your database on the dedicated docs page:

Edit this page on Github