hey yall, i have a somewhat noob question so hopefully there is a simple answer: I have an existing postgresql database and I want to set up a graphql API server to perform basic CRUD on it and feed data to a few client applications we have. My question is, "what steps should i take to set up my prisma server with my existing database?" I originally thought this was a simple SQL migration setup, but as I read the docs, it became unclear if it would work as intended. Can anyone advise me on the steps to take to turn my existing database into a Prisma CRUD API?

Hello there! Are you talking about Prisma 2? If so I think you could use Nexus with this CRUD generator https://github.com/paljs/create-nexus-type

yeah i am planning on prisma 2

You’re welcome 🙂

nexus can replace apollo server (the framework im most familiar with), correct? another example it replaces is graphql yoga, ya? @Joël

Yes indeed but you could also only use https://github.com/graphql-nexus/schema

oh great, thank you again!

I think you will also be able to find examples in the repository

The Prisma part itself: You run Introspection, then have a Prisma schema representation of your database, which lets you generate a Prisma Client for your database that you can use in any node application - for example a GraphQL API and its resolvers etc.

thanks @janpio can you help me understand the order of operations of these steps? • use nexus CRUD generator to create CRUD boilerplate resolvers • prisma introspect the database to build prisma schema • use prisma schema to generate prisma client

2, 3, 1.

ok great, thank you! so to repeat what you said myself to make sure i understand it: first i use prisma to introspect my database to build the prisma schema. then i use that schema to generate my prisma client. i connect my prisma client to my graphql API of choice (apollo, nexus, yoga, etc). I then use the nexus CRUD generator on my generated schema (or the client?) to generate the CRUD resolvers

I am not sure how the CRUD generator works - that is from a user.

ok great, thank you

Good luck!