Extended native types support

Native database type attributes

When you enable the nativeTypes Preview feature, introspection adds a native database type attribute that describes the underlying database type:

model Post {
  id      Int    @id
  title   String @db.VarChar(200)
  tagline String @db.Char(50)
}

Each Prisma type can map to multiple native database types. Native database type attributes are:

• Specific to the underlying provider - for example, PostgreSQL uses @db.Boolean for Boolean whereas MySQL uses @db.TinyInt
• Written in PascalCase (for example, VarChar or Text)
• Prefixed by @db, where db is the name of the datasource block in your schema

Type attributes give you:

• Exact control over what native type [Prisma Migrate creates in the database - for example, a String can be @db.VarChar(200) or @db.Char(50)
• An enriched schema when you introspect - you can see if String is varchar(200) or just text.

Enable native database type attributes

To enable native database type attributes:

1. Update the generator block in your schema as shown:

   prisma/schema.prisma
   1generator client {
   2    provider        = "prisma-client-js"
   3    previewFeatures = ["nativeTypes"]
   4}

2. Introspect your database to populate the schema with type attributes:

   $npx prisma introspect

3. Generate Prisma Client:

   $npx prisma generate

Additional Prisma types

The type attribute Preview feature includes the following new Prisma types:

• Decimal
• Bytes
• BigInt

model sample {
  bigInt  BigInt?  @db.BigInt
  byteA   Bytes?   @db.ByteA
  decimal Decimal? @db.Numeric
  id      Int      @id @default(autoincrement()) @db.Integer
}

// Create record
const newTypes = await prisma.sample.create({
  data:{
    bigInt: BigInt(534543543534),
    decimal: new Decimal(24.454545),
    byteA: Buffer.from(["Hello", "this is a string", 1, 9, 4])
  }
});
// Filter records
const newTypesFilter = await prisma.dates.findMany({
  where: {
    bigInt: {
      gt: BigInt(4594375943753)
    },
    byteA: {
      not: Buffer.from(["Hey!"])
    }
  }
})