# Prisma database adapter > This is the last active development release of this package as **Keystone 5** is now in a 6 to 12 month active maintenance phase. For more information please read our [Keystone 5 and beyond](https://github.com/keystonejs/keystone-5/issues/21) post. [](https://changelogs.xyz/@open-keystone/adapter-prisma) The Prisma adapter allows Keystone to connect a database using Prisma Client, a type-safe and auto-generated database client. You can learn more about Prisma Client in the [Prisma docs](https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-client). > **Tip:** Want to get started with Keystone + Prisma? [Follow the guide](/docs/guides/prisma.md)! > > **Warning:** The Keystone Prisma adapter is not currently production-ready. It depends on the [Prisma Migrate](https://www.prisma.io/docs/concepts/components/prisma-migrate) system which is currently flagged as `Preview`. Once Prisma Migrate is out of preview mode, we will release a production-ready version of this package. > > **Note:** This adapter currently only supports PostgreSQL databases, and has other limitations. For more details, see our [Prisma Adapter - Production Ready Checklist](/docs/discussions/prisma.md) ## Usage ```javascript const { PrismaAdapter } = require('@open-keystone/adapter-prisma'); const keystone = new Keystone({ adapter: new PrismaAdapter({ url: 'postgres://...' }), }); ``` ## Config ### `url` _**Default:**_ `DATABASE_URL` The connection string for your database, in the form `postgres://:@:/`. By default it will use the value of the environment variable `DATABASE_URL`. You can learn more about the connection string format used in the [Prisma docs](https://www.prisma.io/docs/reference/database-connectors/connection-urls). ### `getPrismaPath` _**Default:**_ `({ prismaSchema }) => '.prisma'` A function which returns a directory name for storing the generated Prisma schema and client. ### `getDbSchemaName` _**Default:**_ `({ prismaSchema }) => 'public'` A function which returns a database schema name to use for storage of all Keystone tables in your database. > You can also set the schema name by including the suffix `?schema=...` in your `DATABASE_URL` or `url`. In this case you should set this value to `() => null`. ### `enableLogging` _**Default:**_ `false` Enables logging at the [`query`](https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-client/logging#overview) level in the Prisma client. ### `dropDatabase` _**Default:**_ `false` Allow the adapter to drop the entire database and recreate the tables / foreign keys based on the list schema in your application. This option is ignored in production, i.e. when the environment variable NODE_ENV === 'production'. ### `migrationMode` _**Default:**_ `'dev'` Controls how and when migrations are applied. One of `'dev'`, `'prototype'`, `'createOnly'`, or `'none'`. In `prototype` mode, `prisma db push` is used to sync the database tables without generating migration files. In `dev` mode, migrations files are generated and applied whenever the schema changes. In `createOnly` mode, migrations are generated but not applied. In `none` mode, no migrations are generated or applied. ## Setup Before running Keystone with the Prisma adapter you will need to have a PostgreSQL database to connect to. If you already have a database then you can use its connection string in the `url` config option. If you don't have a database already then you can create one locally with the following commands. ```shell allowCopy=false showLanguage=false createdb -U postgres keystone psql keystone -U postgres -c "CREATE USER keystone5 PASSWORD 'change_me_plz'" psql keystone -U postgres -c "GRANT ALL ON DATABASE keystone TO keystone5;" ``` If using the above, you will want to set a connection string of: ```javascript const keystone = new Keystone({ adapter: new PrismaAdapter({ url: `postgres://keystone5:change_me_plz@localhost:5432/keystone` }), }); ``` See the [adapters setup](/docs/quick-start/adapters.md) guide for more details on how to setup a database.