There is no need to guess, Prisma has documented their naming conventions:
Model names must adhere to the following regular expression: [A-Za-z][A-Za-z0-9_]*
Model names must start with a letter and are typically spelled in PascalCase
Model names should use the singular form (for example, User instead of user, users or Users)
And model fields:
Must start with a letter
Typically spelled in camelCase
Must adhere to the following regular expression: [A-Za-z][A-Za-z0-9_]*
https://www.prisma.io/docs/orm/reference/prisma-schema-reference#naming-conventions
You don't have to map your table and column names. You can ignore them and aim for optimal developer experience by letting Prisma handle the names.
As for the error, if you first started with one naming convention and later changed it, you must also sync your DB schema or write a migration.
Answer from Perttu Haliseva on Stack OverflowPrisma
prisma.io › home › overview of prisma schema › overview of prisma schema › overview of prisma schema
Prisma schema | Prisma Documentation
This page explains how to configure data sources in your Prisma schema · ExampleSyntaxVS CodeGitHubAccessing environment variables from the schemaCommentsAuto formattingFormatting rulesConfiguration blocks are aligned by their = signField definitions are aligned into columns separated by 2 or more spacesEmpty lines resets block alignment and formatting rulesMultiline field attributes are properly aligned with the rest of the field attributesBlock attributes are sorted to the end of the block
Prisma
prisma.io › home › format › format
prisma format | Format & Validate Prisma Schema | Prisma Documentation
The prisma format command formats your Prisma schema file.
Fig
fig.io › manual › prisma › format
prisma format - Format your schema
prisma version --json · Format your schema · On this page ·
Prisma
prisma.io › blog › prisma-schema-language-the-best-way-to-define-your-data
Prisma Schema Language: The Best Way to Define Your Data
February 24, 2025 - The Prisma Schema Language enforces a consistent format for database schemas.
Nova Extensions
extensions.panic.com › extensions › robb-j › robb-j.Prisma
Prisma - Nova Extensions - Panic
You can now globally enable "formatOnSave" which will automatically format your .schema files whenever you save them. The style is defined by Prisma themselves and this is opt-in feature, enable it in extension preferences.
GitHub
github.com › prisma › prisma › discussions › 19113
What is the format of Prisma file (.prisma)? · prisma/prisma · Discussion #19113
Prisma has its own format called the Prisma Schema Language (PSL) for defining database models and configurations.
Author prisma
Top answer 1 of 8
22
I had the same error, then I found this issue on GitHub with the following code, and it worked:
"[prisma]": {
"editor.defaultFormatter": "Prisma.prisma"
},
2 of 8
6
- Install prisma Insider in VS Code
- Add these lines in Settings.josn
"[prisma]": {
"editor.defaultFormatter": "Prisma.prisma-insider"
},
"editor.formatOnSave": true
Now formatting will work.
GitHub
github.com › iiian › prisma-case-format
GitHub - iiian/prisma-case-format: Give your introspected schema.prisma sane naming conventions · GitHub
Most of the time that is probably fine, however you may want or need different conventions in the generated client library. prisma-case-format makes it simple and direct to get the case conventions you want, applied across an entire schema.prisma ...
Starred by 211 users
Forked by 23 users
Languages TypeScript 87.7% | JavaScript 12.3%
Skemato
skemato.com › home › blog › generate prisma schema from visual database design
Generate Prisma Schema from Visual Database Design | Skemato Blog
November 23, 2025 - Export to Prisma schema format · Copy to your project and run migrations · Generate Prisma Schema Free → · Use meaningful model names - Singular, PascalCase · Add indexes - On foreign keys and queried fields · Use @@map - For custom table names · Enable referential actions - onDelete, onUpdate ·
Prisma
prisma.io › home › schema api › schema api › schema api
Prisma Schema API | Prisma Documentation
If the underlying data type is STRING, you must use one of the following formats: ... A JSON object. ... Microsoft SQL Server does not have a specific data type for JSON. However, there are a number of built-in functions for reading and modifying JSON. ... Not supported by MongoDB The MongoDB connector does not support the Unsupported type. The Unsupported type was introduced in 2.17.0 and allows you to represent data types in the Prisma schema that are not supported by Prisma Client.
Prisma
prisma.io › home › schema location › schema location › schema location › schema location
Prisma Schema Location and Configuration | Prisma Documentation
If you prefer splitting your Prisma schema into multiple files, you can have a setup that looks as follows: prisma/ ├── migrations ├── models │ ├── posts.prisma │ ├── users.prisma │ └── ...
Prisma
prisma.io › home › writing guides › writing guides
How to write guides for Prisma ORM | Prisma Documentation
It covers the required structure, formatting, and style conventions to ensure consistency across all guides. You'll learn about frontmatter requirements, section organization, and writing style. ... All frontmatter fields should use sentence case. ... Use numbered steps (e.g., "## 1. Set up your project", "## 2. Install and Configure Prisma") Use numbered subsections (e.g., "### 2.1. Install dependencies", "### 2.2. Define your Prisma Schema")
SabinTheDev
sabinadams.hashnode.dev › building-a-prisma-schema
Learn to build your prisma schema - Sabin Adams
December 31, 2021 - Learn about the options available in your prisma schema by building out a real-life project with relations and mappings. Also touches on Docker and Postgres
Wasp
wasp.sh › prisma schema file
Prisma Schema File | Wasp
Let's see how Wasp and Prisma files work together to define your application. Here's an example schema.prisma file where we defined some database options and two models (User and Task) with a one-to-many relationship:
MCP Servers
mcpservers.org › home › agent skills library › prisma-cli-format
prisma-cli-format | Agent Skills Library
prisma format modifies the file in place. It is equivalent to "Prettier for Prisma schemas" but also has semantic understanding to fix/add missing schema definitions.
Author prisma
Medium
medium.com › @kemaltf_ › what-is-schema-in-prisma-1f52ddac630e
What is schema in prisma.. Attention: | by Taufik Kemal | Medium
June 23, 2023 - Prisma schema is the main configuration file for your Prisma setup.
Visual Studio Marketplace
marketplace.visualstudio.com › items
Prisma - Visual Studio Marketplace
May 19, 2026 - Extension for Visual Studio Code - Adds syntax highlighting, formatting, auto-completion, jump-to-definition and linting for .prisma files.