prisma multiple schema files

I would like to use multiple schema files

github.com › prisma › prisma › discussions › 20878

This has now been implemented: https://www.prisma.io/blog/organize-your-prisma-schema-with-multi-file-support

prisma.io › blog › organize-your-prisma-schema-with-multi-file-support

Organize Your Prisma Schema into Multiple Files

June 4, 2024 - Prisma ORM lets you organize your Prisma Schema into multiple files. You split your models across as many .prisma files as you like, relations work across files without any imports, and Prisma combines everything when you run prisma generate ...

GitHub

github.com › prisma › prisma › discussions › 20878

I would like to use multiple schema files · prisma/prisma · Discussion #20878

Author prisma

Top answer

1 of 1

This has now been implemented: https://www.prisma.io/blog/organize-your-prisma-schema-with-multi-file-support

Prisma can't find multi-file-separated models in 6.14.0 · Issue #27974 · prisma/prisma Aug 27, 2025

10mo ago

What is the best way to handle multiple prisma schemas? · prisma/prisma · Discussion #18218

Multiple Prisma connections and schemas · prisma/prisma · Discussion #24247

Preview feature feedback: Prisma multi schema support (`multiSchema`) · Issue #15077 · prisma/prisma Aug 30, 2022

3y ago

One model to multiple database schemas for multi-tenancy · Issue #24794 · prisma/prisma Jul 15, 2024

2y ago

More results from github.com

Discussions

node.js - Prisma split schema into multiple file - Stack Overflow

I try spliting my models into muitliple files according the tutorial in my node ts project in root i have prisma folder i created schema subdirectory and create inside all models files include schema. More on stackoverflow.com

stackoverflow.com

Prisma adds support for multiple schemas and table views!!

I've had this setup for a few weeks and it works well. The only thing I wish I could change is that the Auth/Storage schemas have so many tables that aren't needed for the work we would do with them. I really only need the `users` table from the auth schema. It clutters up the codebase. More on reddit.com

r/Supabase

February 3, 2023

Is it possible to use prisma schema with multiple files?

NO More on reddit.com

r/learnjavascript

March 28, 2023

Support for splitting Prisma schema into multiple files

Problem Prisma currently only supports one single Prisma Schema file. Developers want more flexibility for managing their Prisma Schema files. Motivations: breaking up large schema files to make th... More on github.com

github.com

352

May 5, 2020

Videos

03:09

YouTube

Using Multiple Prisma Schema Files in Prisma 7 - YouTube

January 28, 2026

08:24

YouTube

How to Use Multiple Schemas with Prisma - YouTube

March 5, 2025

youtube.com

Multiple Prisma Schema Files 💡 #nextjs #webdevelopment - YouTube

January 15, 2025

View all

DEV Community

dev.to › 0xtanzim › splitting-prisma-schema-into-multiple-files-a-simple-guide-ni1

Splitting Prisma Schema into Multiple Files: A Simple Guide - DEV Community

March 3, 2025 - Today, I want to share a solution I found for a common problem with Prisma. By default, Prisma uses just one file called schema.prisma to store all your database models. This can get messy when your project grows. I figured out how to split it into multiple files, and I'll show you how to do it step by step.

Prisma

prisma.io › home › multi-schema › multi-schema › multi-schema › multi-schema

How to use Prisma ORM with multiple database schemas | Prisma Documentation

To use multiple database schemas in your Prisma schema file, add the names of your database schemas to an array in the schemas field, in the datasource block.

Prisma

prisma.io › home › schema location › schema location › schema location › schema location

Prisma Schema Location and Configuration | Prisma Documentation

For example, assuming schema.prisma defines the generator block, here's the correct directory structure: # All files must be inside the `prisma/` directory # `migrations` and `schema.prisma` must be at the same level prisma/ ├── migrations ├── models │ ├── posts.prisma │ └── users.prisma └── schema.prisma # Contains generator block

Medium

arcdev.medium.com › how-to-split-your-prisma-schema-a-simple-guide-4a453502f9b8

How to Split Your Prisma Schema: A Simple Guide | by arcdev.in | Medium

January 10, 2025 - Create a schema subdirectory within your prisma directory. You can move your existing schema.prisma file into this directory and split its contents into multiple .prisma files based on logical groupings, such as models related to users, posts, ...

DevGenius

blog.devgenius.io › splitting-prisma-schema-into-multiple-files-a-simple-guide-0e28da7c5cd7

Splitting Prisma Schema into Multiple Files: A Simple Guide | by Tanzim Hossain | Dev Genius

October 10, 2025 - Today, I want to share a solution I found for a common problem with Prisma. By default, Prisma uses just one file called schema.prisma to store all your database models. This can get messy when your project grows. I figured out how to split it into multiple files, and I'll show you how to do it step by step.

Find elsewhere

Google Bing Mojeek

Prisma

prisma.io › home › overview of prisma schema › overview of prisma schema › overview of prisma schema

Prisma schema | Prisma Documentation

It is typically a single file called schema.prisma (or multiple files with .prisma file extension) that is stored in a defined but customizable location.

Medium

medium.com › @joydip007x › how-to-use-multiple-schema-in-prisma-40cc6b6f8d9c

How to Use Multiple Schema with Prisma Database | Medium

July 7, 2023 - How to use MultiSchema Databases in Prisma , connect Multiple Databases using PrismaSplit in Subschemas or model, use Multiple Schemas Models Databases.

Stack Overflow

stackoverflow.com › questions › 79748024 › prisma-split-schema-into-multiple-file

node.js - Prisma split schema into multiple file - Stack Overflow

Top answer

1 of 1

Like you correctly did before, you need to place every prisma file in prisma/schema.

In prisma/schema/schema.prisma you might want to update output so that the files are still created in the root of your project and not in prisma/:

output = "../generated/prisma" -> "../../generated/prisma"

Then, in the root of your project, create a file named prisma.config.ts:

import { defineConfig } from "prisma/config";

export default defineConfig({
  schema: "./prisma"
});

If you use a config file though, environment variables are not loaded automatically anymore, so, if you use them, you need to load them yourself by installing the package dotenv and adding this in the first line of prisma.config.ts:

import "dotenv/config";

YouTube

youtube.com › watch

Using Multiple Prisma Schema Files - YouTube

05:33

Starting at Prisma 5.15, we can now split our schemas up into multiple files. This is useful for scenarios where different team members are working on differ...

Published January 8, 2025

YouTube

youtube.com › shorts › EOJsdrQfUHY

Using Multiple Prisma Schema Files in Prisma 7 - YouTube

01:00

Prisma 7 is here! This is how you can use multiple schema files in your codebase.To learn more about everything included in this major release of *Prisma ORM...

Published January 30, 2026

GitHub

github.com › prisma › prisma › discussions › 24413

Preview feature feedback: `prismaSchemaFolder`, Multi-file Prisma Schema · prisma/prisma · Discussion #24413

This is probably unrelated to feedback on the new schema folder feature (but unsure where else to put it), but could this open up the way to allowing multiple data sources in the future? I initially tried this out by having 2 {postgres,sqlite}.prisma.schema files in the schema folder and I was pretty pleased when schema generation went without a hitch.

Author prisma

reddit.com › r/supabase › prisma adds support for multiple schemas and table views!!

r/Supabase on Reddit: Prisma adds support for multiple schemas and table views!!

February 3, 2023 -

I was reading through Prisma release notes for versions 4.8.0 and 4.9.0 (as you do), and I saw that they have released support for both views and multiple schemas! This has long been an issue for those of us who have wanted to use Prisma with Supabase, but we've always had to to do hacky things to make it work around Supabase's `auth`, `storage`, and other schemas.

These features are behind preview flags for now, but I'm super excited to see this support coming to the library! Leave a comment if you've been able to test this out at all - I might hack on it a bit this weekend, myself.

https://www.prisma.io/docs/guides/database/multi-schema

https://www.prisma.io/docs/concepts/components/prisma-schema/views

https://github.com/prisma/prisma/releases

Top answer

1 of 2

2 of 2

Editing Prisma Schema has become much easier with Prisma Editor, https://www.reddit.com/r/node/comments/12fj56c/prisma_editor_a_powerful_tool_to_visualize_and/

GitHub

github.com › joydip007x › Prisma-MultiSchema

GitHub - joydip007x/Prisma-MultiSchema: Organized Multi-Schema support for Prisma · GitHub

Prisma normally limits your schema to one file, but with prisma-multischema, you can write multiple prisma schema files in an organized manner without any restrictions.

Starred by 91 users

Forked by 4 users

Languages TypeScript 93.5% | JavaScript 6.5%

YouTube

youtube.com › watch

How to Use Multiple Schema files in Prisma - YouTube

*The Repo Used in this video* : TypeScript: https://github.com/joydip007x/Prisma-MultiSchema-TS-ExampleJavascript: https://github.com/joydip007x/Prisma-Multi

Published June 6, 2023

GitHub

github.com › prisma › prisma › discussions › 18289

Combine Prisma schema files with code · prisma/prisma · Discussion #18289

Schemas can be combine easily using online tools like https://schemabuilder.net/schema-combiner/ I just tried for testing purposes and also validated with Google Rich Result Checking tool and it is combining correctly

Author prisma

reddit.com › r/learnjavascript › is it possible to use prisma schema with multiple files?

r/learnjavascript on Reddit: Is it possible to use prisma schema with multiple files?

March 28, 2023 -

There is an open discussion on the prisma repo regarding this but it doesn't look like it will be implemented any time soon, is there a workaround for the meantime? I saw people using a utility function to cat everything into one file but I will lose editor formatting and autocompletion from the prisma extension

Top answer

1 of 2

2 of 2

Hi u/isaacfink We just released functionality to split schema files in Prisma 5.15.0. Can you please try it out and let us know your feedback? https://www.prisma.io/blog/organize-your-prisma-schema-with-multi-file-support

GitHub

github.com › prisma › prisma › issues › 2377

Support for splitting Prisma schema into multiple files · Issue #2377 · prisma/prisma

May 5, 2020 - Support importing additional schema files, i.e. import "user.schema", import models/*.prisma or import modules/**/*.prisma.

Author prisma