Schema:

type Project {
  id: UUID! @id
  locationSecurity: Json
}

PostgreSQL type:

locationSecurity     | text                           |           |          |         | extended |              |

It is stored in schema as JSON and in the database as text. Why? This is bug? Or is there a specific reason?

@Ahmet Yes Prisma 1 used to store

Json

values as text, as a workaround you would need to manually fix the type in the DB. This is fixed in Prisma 2.