All posts for Prisma

• unrecognized keys some
• Nested relation query help
• Pulse local development + static IPs
• Error: 🟥 @prisma/react-native failed to initialize, js engine: hermes
• Issues with prisma docker deployments
• Dynamic Filtering items with prisma and Nextjs?
• creating a record attempting to update it shortly after causes error
• Not updating types
• docker container problem
• Help with findFirst and none relations
• Can't see relation field in Types
• Help with multiple prisma clients in a turbo monorepo
• At what point is a query used up from the 60k
• Contacts: error combining many-to-one with one-to-one on the same models
• Getting error when using Prisma Optimize
• How do the accelerate and read replica extensions interact?
• property 'data' does not exist on args when using $extends
• NPM network error only when trying to fetch Prisma
• updateMany fails with "You can't specify target table 'Org' for update in FROM clause" error
• How can i implement Prisma Client as shared package?
• @relation field referencing a compound id
• Slowness issue when using Supavisor connection pooling with Prisma
• unexpected message from server
• Build failure because of prisma?
• Accelerate SWR option not re-fetching/revalidating cache
• Types are broken because of read replicas extension
• How do I go about seeding with the D1 adapter?
• Sort by nulls
• Prisma Enum Mapping
• Prisma schema folder
• Prisma.io Console 500
• Can you have multiple named prisma pulse streams?
• Error using PrismaClient with Cloudflare Pages
• How can i get the change the return type of a prisma function based on a generic type?
• $queryRawUnsafe takes a long time to respond
• Include in findone return null if the join table not have its id
• prismaclientvalidationerror
• Definitive Solution for automatic migration running?
• please help me to setup prisma for my ds ticket bot
• Help: squashing migrations
• Using upsert when `Notifications` table doesn't exist yet for user
• Initial find query giving weird error
• Create prisma client with extension without circular dependency
• Error.code not defined for Deadlock & 40P01 error
• Hi everyone. I have a question regarding NestJS and Prisma ORM.
• Migrating a One2One field to a One2Man
• message: "invalid byte sequence for encoding \"UTF8\": 0x00
• "The preview feature "omitApi" is not known." when trying to add 'omitApi' to the preview features.
• Cleaner Way to Write Prisma Schema for Badge System
• Get Correct Return Type when using Prisma ORM inside a method that accepts the client's args
• prisma client error
• 500 Internal Server Error from Pulse console setup
• Prisma Client is not configured to run in the edge runtime
• How to use getDMMF
• Get type of prisma client before it is defined
• How to reference/store a joined primary key?
• error with simple request
• create many skip existing
• why does my table with the name users show up as uSER in my prismaclient?
• GET request using JSON body
• Unable to connect Prisma to RDS database
• Date field default value
• when i do command 'npx prisma db pull', Can i pull specific table?
• Question about the schema model type
• Redirected false error 400
• Typescript one to many relation
• Error in "create" logic ?
• Prisma RLS example makes transactions not possible to use
• Is Prisma still not working with RDS Proxy?
• Prisma serverless-pg driver support
• AttributeError: module 'prisma.actions' has no attribute 'model_rebuild'
• Order by relation field
• Safe to import Prisma in Client Component?
• Can not deploy my backend api that use bun as runtime and prisma for database to my vps server using
• Can't reach database server at localhost:5432
• Very hard to describve
• NestJS + prisma
• ID needed in delete()?
• Argument transaction tx with prisma accerlate typescript error
• Prisma try migrate a model that no exist.
• yarn 4
• Cannot generate prisma client in monorepo
• Setting up Prsma Pulse with AWS RDS
• URGENT: I cannot remove/uninstall Accelerate from my Vercel build. Help.
• How can I simultaneously use Accelerate with directUrl for some uses cases?
• Problem with nested create
• Can I opt into join vs every query being join by default?
• Prisma without Engine for Serverless/Edge?
• engine type library error
• Random garbage errors
• How can I use plain object instead of composite types ?
• how to import prisma client on a client without compromising credentials
• Best Practices for Error Handling When Updating Bridge Table (Composite IDs)
• Help with generate database (Rust Prisma ORM)
• What’s a good strategy for migration if downtime is not a problem?
• Internal server error
• How to use migrate when having a directurl and normal url
• How to create project?
• Error: Cannot fetch data from service:getaddrinfo ENOTFOUND aws-us-east-1.prisma-data.com
• Mongodb schema update - how to
• I created free postgresql database in Aiven.io. But I can't connect database with Prisma.
• Inserting data with migration file
• Migrate dev failing in a project it used to work in. Says issue w/ user defined functions.
• Prisma Optimize does not show queries
• Help With 2 database usage in same api
• cacheStrategy is never
• Unique Constraints Failed
• Representing a User with sub-roles
• Relations issue
• Prisma Accelerate - Nextjs Middleware - NextAuth V5 - EDGE_FUNCTION_INVOCATION_TIMEOUT
• Unknown argument 'ID' in double nested find many with one to many relation
• How do you organize your Prisma.validator schemas?
• Get P6004 and P5000 error running Vercel production query through Accelerate
• nested transactions
• Prisma for expo app
• Invalidating/flushing cache in Accelerate
• How can I use Prisma with Kubernetes? Any example
• Unique index with nullable composite key?
• Multiple one-to-one relations with referential actions
• Nested queries with mongodb not working.
• Cannot find environment variables
• N+1 problem with multiple filter conditions
• Preserve key order when writing JSON fields
• Accessing extended operations on the prisma client with typescript
• $queryRaw for Insert asking for id which is set to autoincrement
• Prisma Accelerate and Tracing
• mongodb not updating schema
• Prisma returning different results for the same query (FindMany vs Count)
• Update to 5.16 results in Initialization Error
• Prisma Pulse issue
• Prisma Error: Error Querying DB due to DB is starting up
• Problems when deploying after a failed migration
• What's the proper way for me to define tsvector field in my schema file?
• Issues deploying Flask + Prisma-Client-Py backend to Vercel
• Dashboard localhost:4467/_admin after run command: yarn prisma:deploy-force all table is 0
• Database requires reset when migrating
• Hi, I am using prisma with cockroachdb. CRDB clusters have many nodes.
• Best Practices for Updating Nested Relations in Prisma with NestJS and SQL Server
• Ensuring Filtering if variable is undefined
• Cannot find module rollup/parseAst
• Prisma NextJs Docker and Multi Datasource
• prisma edge compactible with lucia -auth with node postgres typescript error
• Prisma can only run debugging, cannot compile and publish? #14
• Vercel Edge Functions + tRPC + Prisma + CockroachDB
• AWS ECS + Fargate + Aurora PostgreSQL
• Caching
• Caching server side prisma query in next js
• When running Prisma Generate on either of my computers (both Apple Silicon) getting error
• Prisma is not working while deployed on Vercel with Vercel Postgresql but working in Development.
• Storing image metadata: Is this safe?
• Prisa Query doesn´t find the data in my DB
• A big 2M wasm file created after implementing prisma
• opensaas
• One of two fields (or both) must be provided.
• Getting P2024 all of a sudden without any unusual activity or usage spike
• studio
• Three Way Relationship ConnectOrCreate
• how to make a model with any type
• Invalid `prisma.course.create()` invocation:
• Problem with Prisma , Docker , Postgres and PgAdmin
• Prisma git ops deployment
• Can't start prisma studio
• Error: A unique constraint would be violated on ProviderRoleAccess. Details: Field name = role
• Unable to find table (not available) but it exists
• Did Prisma.raw and Prisma.sql helpers get removed?
• Prisma Nuxt RollupError
• Random findMany is not a function errors
• Could not connect to server at http://localhost:4467. Please check if your server is running.
• Where is my environment var coming from?
• omit with condition
• How to cover this custom SQL with Prisma
• length() of column
• Unit testing a result extension
• How to populate array in one-to-many relationship (or may be even persist)?
• Invalid `prisma.account.findUnique()` invocation:
• How can we do arbitrary atomic number operation in prisma?
• Accelerate migration not happening Vercel Prod but does with Vercel Preview
• Local sqlite db in monorepo with nextJS trying to find table 'main.TABLE' instead of 'TABLE'
• Prisma runtime error using direct db access in parallel with Accelerate on Vercel
• Multiple relation between models
• prisma is generating some crappy migrations for no reason
• Pointing two relations to same field?
• Cannot read properties of undefined (reading 'kind')
• Docker error Can't reach database server at localhost:5432
• Why doesn't the generated client use the .env file specified by dotenv?
• Prisma seed data erased during testing in single test file run
• Learning Prisma from 0
• Does Raw Queries Hit Read Replica ?
• TS Type Issue on Nested Selects
• stuck with prisma and supabase using nextjs14 when i want to npx prisma db push/ migrate / reset etc
• Issue with permissions for setting up replication for prisma pulse
• Is it possible to use prisma pulse if your database is behind a VPN?
• Get type of `create` with `connect`?
• Can't reach database server error
• prisma migrate dev deleted all my data and when I do another migrate dev again I got shadow error
• Error: @prisma/client did not initialize yet.
• I'm trying to use prisma prisma in remix (ERR_RESOLVE_PACKAGE_ENTRY_FAIL)
• Error bubbling in $transaction client
• Updating user info in db using forms
• Own local Caching?
• Import Enum from my TS to the schema
• reset db and migrate changes
• Unable to run db push because of introspected inconsistencies with supabase
• i am unable to run prisma migrate
• Ordering of createMany items
• Error: cannot find module ‘.prisma/client/index’
• Export client types in custom package
• typescript server not working after installing @prisma/client
• Tips on designing this recursive database model
• how to make fields selection mandatory?
• Hosting Typescript Express Server with Prisma on Vercel
• Connection Pooling issues with Azure SQL
• PrismaClientInitializationError
• How to add new schema with multiSchema feature without database reset
• Setting up SafeQL for Prisma
• too many db connections on Prisma Accelerate
• Failing to write raw query
• Is there an option to turn off the dataloader query optimization?
• Update column type without losing data
• Multiple schema - node_modules - prisma client
• Getting total count of records with one Query
• Problems regarding new feature (v5.15.0)
• problem when deploying prisma
• Can't reach database server at `aws-0-ap-south-1.pooler.supabase.com:5432`
• Prisma: command not found (Vercel)
• Vulnerabilities That Won't Be Fixed
• problem when deploying
• I can't disconnect a many-to-many relationship
• using variable in queryRaw not working
• make from model.prisma sql
• Help Needed with Nested CreateMany!
• Question about designing friend request / follow system with relational tables
• Flat response from relational query?
• Server closed connection
• Adding fields to a templated `select`
• Multiple relations between the same Tables
• Conditional Unique Constraint
• Websocket error when using Pulse
• Supabase with prisma
• Prisma Console API access?
• default value not changing
• Type '{ connectOrCreate: { where: { state_name: string; }; create: { state_name: string; }; }; }' is
• Main .prisma file location with new prismaSchemaFolder feature (+ Bazel)
• Update Prisma CLI
• Argument is missing
• optimize dashboard connection timed out
• db push and migrate dev
• Type-safety for dates when returning DB entries as JSON
• npx prisma migrate dev --name init (stuck)
• Filtering an array
• Generate prism client
• Uploading image
• binaries.prisma.sh Gives Not Found Error
• prisma migrate dev wants to drop all tables
• schema env file
• nextjs + prisma + superbase working is developement only
• Dynamic database
• Field excluded when running prisma query to supabase
• Why can't I access profile in user? (ORM) (Postgres)
• Is it bad practice to depend on the unique constraint while creating a new object?
• circular variable reference issues
• Raw SQL generated for cursor using libsql issue
• prisma.transaction.findMany() not working
• Cleaning code
• How to push changes to already deployed db?
• check connection - prisma nextjs
• Lock tables
• 500 (Internal Server Error) from simple query
• [Help]Prisma ORM with Express and TypeScript. Trying to use include.
• prisma use middleware
• Prisma telemetry operation contains unaccounted for time
• Prisma ORM returns two different results from two similar (?) queries
• UncheckedCreateInput error when trying to create a many to many relationship (likeSermon / likePost)
• Implicite Many-to-Many relationship double primary key
• mongodb connection randomly unable to connect
• Prisma client doesn't get updated with new columns after db pull
• npx prisma migrate dev --name init from tutorial not working
• Error Initializing Prisma on Expo
• Does Accelerate support MSSQL?
• [FIXED] Error when providing certificate
• dmmf in prisma 5
• How to ignore custom migtation script without reset all data?
• Null, Undefined, <form><input>, Zod validation and query result type mismatches.
• P3009 error on deploy
• Queryraw condition joining
• prisma accelerate can I connect to my database?
• Any expected SDL-First generator with CRUD abilities?
• SET UP PRISMA ON EXISTING DATABASE?
• SHOULD I RUN prisma generate EVERYTIME WHEN I MODIFY PRISMA SCHEMA IF I GOING TO DO MIGRATION?
• Disable CLI ads
• Extend client Type loose relation
• Nuxt 3 - Prisma building production
• Use orderBy based on the field that is coming from nested one to many relation
• 403 - Forbidden when running "npx prisma generate"
• How to create Prisma Client's generated types with nested models?
• PrismaClient is not configured to run in Vercel Edge Functions or Edge Middleware
• How to manage shared Prisma types in serverless frontend/backend apps
• Prisma with Accelerate TypeScript error
• prisma db push is failing on relation
• ERROR: column "filename" of relation "ActionDependencyList" contains null values
• Change query typing to respect where null, or where not null
• Self-Hosted Pulse?
• How to filter if a variable is not in database
• No index found for fulltext search over relation (Planetscale)
• How to order multiple index
• user not saving on mongodb but works fine with mysql
• Using createManyAndReturn
• Prisma custom flow
• Prisma RLS using transactions
• Typing custom property on a method
• Prisma 5.12.1 client has errors accessing postgress db when using with cloudflare workers and the ne
• `PrismaClientInitializationError: Prisma Client could not locate the Query Engine for runtime` error
• Foreign key constraint failed on the field: `anime_season_fkey (index)`
• Delete Prisma Models
• can i pass a model to a type, the same way i pass a type to a model in prisma schema ?
• Pass current user id to Postgres
• Prisma migrate deploy fails in GitHub actions
• Prisma Accelerate: ConnectorError. SUPABASE
• nested incuding
• Running a typescript migration script
• Prisma generate just load scheme and then no output
• how to return an empty array instead of null
• Unique index w/ nullable field in unique query
• Question about explicit many to many table
• ts error in library file
• Unable to run the seed script successfully
• Prisma.validator with arguments
• Should I stick with raw SQL?
• $on
• Prisma migrations working with more than one container
• Data Location Security
• The response size of the query exceeded the the maximum of 5MB
• NextJS version 13.5.4 in prod getting Internal Server Error
• How to authenticate Prisma Optimize in a VPS ?
• Is there a way to tell Prisma to use GIN indexes?
• In a Prisma result extension, is it possible to require ("needs") a relation?
• I want to find a user with either email or username but I'm getting a typescript error
• Filter (where) for nonexistant boolean field
• Prisma extend can change db pointing to?
• Setting Connection limit in gcp cloud run and cloud sql
• Can composite type contain a list of another composite type?
• Type Error
• Prisma Migrations With Turbo Repo
• Relation not included in the generated types
• Need help with schema
• Prisma is not using test env file
• Does prisma allow use of Shared Primary Key?
• upsert orm
• Why isn’t prisma adding support for mongo change streams?
• How do I setup my Supabase DB connection string to work with Prisma Accelerate
• Prisma Migrate Diff coming back when it shouldn't
• Super slow queries when filter JSON
• Error
• prisma azure swa is not working
• Counting hashtags in all posts
• Prisma format fails with disambigious relations
• Database Design for Sitemaps
• Can composite type contain a list of another composite type?
• Does Prisma ORM support CUIDv2?
• Bypass accelerate for certain queries to avoid 5MB limit
• Giving relation implicit name explicitly without dropping table
• Error: spawn prisma-client-py ENOENT
• Additional processing after fetching data
• why can't all sides of relation become mandatory? why one of the side has to be optional?
• many to many api response looks wierd
• Prisma breaks lambda
• Refactoring schema
• Extra query into object (GetPayload)
• Updating several different data
• Which is more efficient: Promise.all([findUnique() * 3]) or prisma.$transaction([findUnique() * 3])?
• findUniqueOrThrow does not throw a PrismaClientKnownRequestError - and NotFoundError is deprecated
• Create Project Button is disabled, also page seems to be broken
• npm migrate deploy Error
• where inside include
• Does Accelerate support using cacheStrategy with groupBy queries on a view?
• Prisma `AND` filter not working
• Merge migrations
• Set max execution timeout
• Is it possible to include nested fields in client extensions?
• getting migration error in prisma
• NextJS + Prisma，why is a 2M WASM file generated?
• RDS Proxy with Prisma
• orderBy on a relation include
• QueryError(MixedParams) after Google Cloud hosting service
• Deploy failed in the cloudflare pages dashboard with prisma.
• Convert Raw Query back to prisma type
• When db is updated how to get that alter into prisma?
• [Prisma] Nested create with 2 levels of related records
• [Neon] [Driver Adapters] Do we need DIRECT_URL if using Driver Adapters?
• How to setup Next js apps on Vercel using Prisma....
• How to create a .prisma file for each Model in a schema
• Prisma ORM with Cloudflare D1/Next-on-pages
• A bug with prisma
• Is it possible to use every + and?
• Incorrect binary data format in bind parameter
• Prisma not recognizing Date-only values
• Dynamically changing DB connection during runtime
• How to Handle Case Insensitivity?
• Inconsistent query result: Field topics is required to return data, got `null` instead.
• Does Prisma Studio work without Node (i.e. with Bun)
• How to run safe migrations
• Prisma Warn Console in development
• Type 'string[]' is not assignable to type 'string'.ts(2322) when trying to create a form using Prism
• Strange @relation fields in auto-generated models
• I feel this is simple but I fear i've just been at it too long I'm starting to not see straight.
• findMany query is failing as it's breaching planetscale's 100k limit but rawquery is working fine
• Pulse listening to all schemas in my RDS instance
• How to avoid resetting the DB when switching between branches with schema diffs
• Connecting prisma with mongodb issue
• Deploy on GCP
• mysql table collation
• Reason why relation is giving an error when id is provided
• Temporary table support?
• No models defined
• Pulse import not recognized / types not working in Next.js project
• Error with correct Model
• Prisma throws an error with code 2F005
• Error on prisma Client
• invalid invocation prisma.paypal.findMany()
• Prisma Query
• Prisma stores invalid data
• MTI key relation
• Prisma first query goes slow
• [ERR_PACKAGE_PATH_NOT_EXPORTED]: Package subpath './runtime/library.js' is not defined in "exports"
• Health Check of Query Engine timed out.
• How to write like query in mongodb prisma raw?
• Sorting by distance
• Cloudflare Pages Error: @prisma/client did not initialize yet. Please run "prisma generate" and try
• Error querying the database: FATAL: Max client connections reached
• Prisma too many connection to my database
• How do you seed/initialize basic data as products, delivery methods during deploy ?
• Prisma not working in cpanel
• Issue when running migrate command
• Prisma generate have different result in v5.13
• How to resolve this certificate issue
• Prisma warns of data loss when changing required field to optional, even when there is a default val
• Prisma VSCode extension v5.13.1 causing severe issue
• multiple relations to same table
• anyway i can have the _sum in this findMany()
• Bun App. Cant fix Prisma Generate. Dockerfile?
• How can show advertisement in queue in sync with all users?
• Transaction timeout
• Is it safe to expose prisma types to client application?
• Status of NanoID
• Can't use Neon
• Typescript error
• Prisma Accelerate p6000
• [MongoDB] dup key: { itemId: null }, labels: {}
• Prisma not working on middleware even tho the app is being ran on a server.
• DB Connection String: connection_limit which side does it control exactly?
• Neovim hightlight isn't working
• Problem with first connection to database
• How to execute postgres function in node js?
• optionally adding an $extends clause to prisma export
• Extends result relations
• How to create Prisma triggers ?
• Best practices for updating column type when there are existing records
• Error validating datasource `db`: the URL must start with the protocol `prisma://`
• Many to many on the same model, multi directional?
• How to type $allModels result extension
• Is it possible to have workspaces transferred from one user to another?
• offset-based pagination in a field with a relation
• is there any way we could get in touch with someone from the accelerate team?
• prisma accelerate + custom directory
• Custom database_url from command line?
• can I use prisma with Mongodb for real time data fetching ?
• Filtering time
• Prisma filter variable in given array
• Authentication error while fetching data but not while prisma studio or db push
• P1017: Server has closed the connection.
• prisma migrate reset --force
• Need urgent support from Prisma team
• How to get the type of a compound query?
• Support case insensitive advanced Json filtering
• How good is Prisma with Json fields?
• Prisma optimization
• Timezone error
• prisma aggregateRaw, how to parse Date back to javascript date, and other special types,
• Deployment to vercel failing
• Using pulse in a next.js project
• Add Model Extension methods
• union type findMany
• How to cascade delete properly in a self-relation with mongodb ?
• [Typescript] Prisma result extension typing
• will prisma support zod validations natively
• @unique on optional field
• Unknown argument xx. Available options are marked with ?.
• Trying to get into Prisma; lots of hope and heartbreak
• SOLVED: Create w/ sub create: Subquery returned more than 1 value
• Returning the next day closest to NOW
• prisma nested fields
• Get the next date with prisma
• How to Get Started with Prisma? ORM
• Wierd type error with prisma codegen
• why that not work?
• Sorting by related field
• Paying for this service but can't login. On multiple accounts now
• Monorepo setup: Prisma with NestJS
• Update nested field in composite types
• Turbo setup with prisma and pnpm
• Optimizing a query
• Cloudflare D1 support
• I need to convert find many query to find raw query...
• [ADVANCED] Prisma Extensions - dynamic typing
• Filter: return both or one
• Cannot select both '$scalars: true' and a specific scalar field 'tags'.
• User data not generated at prisma
• is there still no option to manually invalidate the cache?
• StringFieldUpdateOperationsInput on @id
• multiSchema variable
• Deploying to Railway
• How do I find records then select only 10 of them between (example) 40 and 50
• Frequent constraint failed on id when using @id @default(autoincrement())
• Single table inheritance
• Connecting relations misunderstanding
• Prisma.Decimal is not a Decimal
• Does 'asc' sorting order sorts my createdAt timestamps from the oldest to the latest or viceversa?
• how to create the _prisma_migration table in a specific schema?
• Prisma(postgres) stuck at `where: {assets: {none: {}}}`
• Data is not showing in table
• Multiple datasources
• Fixing slow query
• Edge + Accelerate cold start