August 30, 2022

End-To-End Type-Safety with GraphQL, Prisma & React: GraphQL API

14 min read

In this series you are learning how to implement end-to-end type safety using React, GraphQL, Prisma, and some other helpful tools that tie those three together.

Table Of Contents

Introduction

In this section, you will build upon the project you set up in the previous article of this series by fleshing out a GraphQL API.

While building this API, you will focus on ensuring your interactions with the database, data handling within your resolvers, and data responses are all type-safe and that those types are in sync.

If you missed the first part of this series, here is a quick overview of the technologies you will be using in this application, as well as a few prerequisites.

Technologies you will use

These are the main tools you will be using throughout this series:

  • Prisma as the Object-Relational Mapper (ORM)
  • PostgreSQL as the database
  • Railway to host your database
  • TypeScript as the programming language
  • GraphQL Yoga as the GraphQL server
  • Pothos as the code-first GraphQL schema builder
  • Vite to manage and scaffold your frontend project
  • React as the frontend JavaScript library
  • GraphQL Codegen to generate types for the frontend based on the GraphQL schema
  • TailwindCSS for styling the application
  • Render to deploy your API and React Application

Assumed knowledge

While this series will attempt to cover everything in detail from a beginner's standpoint, the following would be helpful:

  • Basic knowledge of JavaScript or TypeScript
  • Basic knowledge of GraphQL
  • Basic knowledge of React

Development environment

To follow along with the examples provided, you will be expected to have:

Start up a GraphQL Server

The very first thing you will need to build a GraphQL API is a running GraphQL server. In this application, you will use GraphQL Yoga as your GraphQL server.

Install the graphql-yoga and graphql packages to get started:

npm install graphql-yoga graphql
Copy

With those packages installed, you can now start up your own GraphQL server. Head over to src/index.ts. Replace the existing contents with the this snippet:

// src/index.ts
// 1
import { createServer } from "node:http";
import { createSchema, createYoga } from 'graphql-yoga'
// 2
const port = Number(process.env.API_PORT) || 4000
// 3
const schema = createSchema({
typeDefs: /* GraphQL */ `
type Query {
hello: String
}
`,
resolvers: {
Query: {
hello: () => 'world'
}
},
})
// 4
const yoga = createYoga({ schema })
// 5
const server = createServer(yoga);
// 6
server.listen(port, () => {
console.log(`🚀 GraphQL Server ready at http://localhost:${port}/graphql`);
})
Copy

The code above does the following:

  1. Imports the createServer function from Node HTTP, and createSchema and createYoga from graphql-yoga
  2. Creates a variable to hold the API's port, defaulting to 4000 if one is not present in the environment
  3. Creates a "dummy" GraphQL schema with a hello query
  4. Creates a Yoga instance with a GraphQL schema
  5. Creates a server instance and pass the yoga instance into the request handlers
  6. Starts the server up on port 4000 and lets the console know it's up and running

Note: The "dummy" schema will be replaced later in this tutorial.

If you start up your server, you will have access to a running GraphQL API with one query type called hello:

npm run dev
Copy

Note: The GraphQL server is up and running, however it is not usable because you have not yet defined any queries or mutations.

Set up the schema builder

GraphQL uses a strongly typed schema to define how a user can interact with the API and what data should be returned. There are two different approaches to building a GraphQL schema: code-first and SDL-first.

  • Code-first: Your application code defines and generates a GraphQL schema
  • SDL-first: You manually write the GraphQL schema

In this application, you will take the code-first approach using a popular schema builder named Pothos.

To get started with Pothos, you first need to install the core package:

npm i @pothos/core
Copy

Next, create an instance of the Pothos schema builder as a sharable module. Within the src folder, create a new file named builder.ts that will hold this module:

cd src
touch builder.ts
Copy

For now, import the default export from the @pothos/core package and export an instance of it named builder:

// src/builder.ts
import SchemaBuilder from "@pothos/core";
export const builder = new SchemaBuilder({});
Copy

Define a Date scalar type

By default, GraphQL only supports a limited set of scalar data types:

  • Int
  • Float
  • String
  • Boolean
  • ID

If you think back to your Prisma schema, however, you will remember there are a few fields defined that use the DateTime data type. To handle those within your GraphQL API, you will need to define a custom Date scalar type.

Fortunately, pre-made custom scalar type definitions are available thanks to the open-source community. The one you will use is called graphql-scalars:

npm i graphql-scalars
Copy

You will need to register a Date scalar with your schema builder to let it know how to handle dates. The schema builder takes in a generic where you can specify various configurations.

Make the following changes to register the Data scalar type:

// src/builder.ts
import SchemaBuilder from "@pothos/core";
// 1
import { DateResolver } from "graphql-scalars";
// 2
export const builder = new SchemaBuilder<{
Scalars: {
Date: { Input: Date; Output: Date };
};
}>({});
// 3
builder.addScalarType("Date", DateResolver, {});
Copy

Here's what changed in the snippet above. You:

  1. Imported the Date scalar type's resolver which handles converting values to the proper date type within your API
  2. Registered a new scalar type called "Date" using the SchemaBuilder's Scalars configuration and configured the JavaScript types to use when accessing and validating fields of this type
  3. Let the builder know how to handle the defined Date scalar type by providing the imported DateResolver

Within your GraphQL object types and resolvers, can now use the Date scalar type.

Add the Pothos Prisma plugin

The next thing you need to do is define your GraphQL object types. These define the objects and fields your API will expose via queries.

Pothos has a fantastic plugin for Prisma that makes this process a lot smoother and provides type safety between your GraphQL types and the database schema.

Note: Pothos can be used in a type-safe way with Prisma without using the plugin, however that process is very manual. See details here.

First, install the plugin:

npm i @pothos/plugin-prisma
Copy

This plugin provides a Prisma generator that generates the types Pothos requires. Add the generator to your Prisma schema in prisma/schema.prisma:

// prisma/schema.prisma
generator client {
provider = "prisma-client-js"
}
+generator pothos {
+ provider = "prisma-pothos-types"
+}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
model User {
id Int @id @default(autoincrement())
name String
createdAt DateTime @default(now())
messages Message[]
}
model Message {
id Int @id @default(autoincrement())
body String
createdAt DateTime @default(now())
userId Int
user User @relation(fields: [userId], references: [id])
}
Copy

Once that is added, you will need a way to generate Pothos' artifacts. You will need to install this API's node modules and regenerate Prisma Client this each time this application is deployed later in the series, so go ahead and create a new script in package.json to handle this:

// package.json
{
// ...
"scripts": {
// ...
"build": "npm i && npx prisma generate"
}
}
Copy

Now you can run that command to install your node modules and regenerate Prisma Client and the Pothos outputs:

npm run build
Copy

When you run the command above, you should see that Prisma Client and the Pothos integration were both generated.

Now that those types are generated, head over to src/builder.ts. Here you will import the PrismaPlugin and the generated Pothos types and apply them to your builder:

// src/builder.ts
import SchemaBuilder from "@pothos/core";
import { DateResolver } from "graphql-scalars";
+import PrismaPlugin from "@pothos/plugin-prisma";
+import type PrismaTypes from "@pothos/plugin-prisma/generated";
export const builder = new SchemaBuilder<{
Scalars: {
Date: { Input: Date; Output: Date };
};
}>({});
builder.addScalarType("Date", DateResolver, {});
Copy

As soon as you add the generated types, you will notice a TypeScript error occur within the instantiation of the SchemaBuilder.

Pothos is smart enough to know that, because you are using the Prisma plugin, you need to provide a prisma instance to the builder. This is used by Pothos to infer information about the types in your Prisma Client. In the next step you will create and add that instance to the builder.

For now, register the Prisma plugin and the generated types in the builder instance to let Pothos know about them:

// src/builder.ts
// ...
export const builder = new SchemaBuilder<{
Scalars: {
Date: { Input: Date; Output: Date };
};
+ PrismaTypes: PrismaTypes;
}>({
+ plugins: [PrismaPlugin],
});
// ...
Copy

You will, again, see a TypeScript error at this point. This is because the builder now expects an instance of Prisma Client to be provided to the function.

In the next step, you will instantiate Prisma Client and provide it here in the builder.

Create a reusable instance of Prisma Client

You now need to create a re-usable instance of Prisma Client that will be used to query your database and provide the types required by the builder from the previous step.

Create a new file in the src folder named db.ts:

touch src/db.ts
Copy

Within that file, import Prisma Client and create an instance of the client named prisma. Export that instantiated client:

// src/db.ts
import { PrismaClient } from "@prisma/client";
export const prisma = new PrismaClient();
Copy

Import the prisma variable into src/builder.ts and provide it to builder to get rid of the TypeScript error:

// src/builder.ts
// ...
+import { prisma } from "./db";
export const builder = new SchemaBuilder<{
Scalars: {
Date: { Input: Date; Output: Date };
};
PrismaTypes: PrismaTypes;
}>({
plugins: [PrismaPlugin],
+ prisma: {
+ client: prisma,
+ },
});
// ...
Copy

The Pothos Prisma plugin is now completely configured and ready to go. This takes the types generated by Prisma and allows you easy access to those within your GraphQL object types and queries.

The cool thing about this is you now have a single source of truth (the Prisma schema) handling the types in your database, the API used to query the database, and the GraphQL schema.

Next, you will see this in action!

Define your GraphQL types

At this point, you will define the GraphQL object types using the builder you configured with the Prisma plugin.

Note: It may seem redundant to manually define GraphQL object types when you've already defined the shape of the data in the Prisma schema. The Prisma schema defines the shape of the data in the database, while the GraphQL schema defines the data available in the API.

Create a new folder within src named models. Then create a User.ts file within that new folder:

mkdir src/models
touch src/models/User.ts
Copy

This is where you will define the User object type and its related queries that you will expose through your GraphQL API. Import the builder instance:

// src/models/User.ts
import { builder } from "../builder";
Copy

Because you are using Pothos's Prisma plugin, the builder instance now has a method named prismaObject you will use to define your object types.

That method takes in two parameters:

  1. name: The name of the Prisma model this new type represents
  2. options: The config for the type being defined

Use that method to create a "User" type:

// src/models/User.ts
import { builder } from "../builder";
+builder.prismaObject("User", {})
Copy

Note: If you press Ctrl + Space within an empty set of quotes before typing in the name field, you should get some nice auto-completion with a list of available models from your Prisma schema thanks to the Prisma plugin.

Within the options object, add a fields key that defines the id, name and messages fields using Pothos's "expose" functions:

// src/models/User.ts
import { builder } from "../builder";
builder.prismaObject("User", {
fields: t => ({
id: t.exposeID("id"),
name: t.exposeString("name"),
messages: t.relation("messages")
})
})
Copy

Note: Hitting Ctrl + Space when you begin to type in a field name will give you a list of fields in the target model that match the data type of the "expose" function you are using.

The function above defines a GraphQL type definition and registers it in the builder instance. Generating a schema from the builder does not actually store a GraphQL schema in your file system that you can check out, however the resulting type definition for your User will look like this:

type User {
id: ID!
messages: [Message!]!
name: String!
}
Copy

Next, add another file in the same folder named Message.ts:

touch src/models/Message.ts
Copy

This file will be similar to the User.ts file, except it will define the Message model.

Define the id, body and createdAt fields. Note the createdAt field has the DateTime type in your Prisma schema and will need a custom configuration to define the custom date scalar type you defined:

// src/models/Message.ts
import { builder } from "../builder";
builder.prismaObject("Message", {
fields: (t) => ({
id: t.exposeID("id"),
body: t.exposeString("body"),
createdAt: t.expose("createdAt", {
type: "Date",
}),
}),
});
Copy

This function will result in the following GraphQL object type:

type Message {
body: String!
createdAt: Date!
id: ID!
}
Copy

Implement your queries

Currently, you have object types defined for your GraphQL schema, however you have not yet defined a way to actually access that data. To do this, you first need to initialize a Query type.

At the bottom of your src/builder.ts file, intialize the Query type using builder's queryType function:

// src/builder.ts
// ...
builder.queryType({});
Copy

This registers a special GraphQL type that holds the definitions for each of your queries and acts as the entry point to your GraphQL API. You define this type in the builder.ts file to ensure the query builder has a Query type defined, that way you can add query fields to it later on.

Within this queryType function, you have the ability to add query definitions directly, however, you will define these separately within your codebase to better organize your code.

Import the prisma instance into src/models/User.ts:

// src/models/User.ts
import { builder } from "../builder";
+import { prisma } from "../db";
// ...
Copy

Then, using the builder's queryField function, define a "users" query that exposes the User object type you defined:

// src/models/User.ts
// ...
// 1
builder.queryField("users", (t) =>
// 2
t.prismaField({
// 3
type: ["User"],
// 4
resolve: async (query, root, args, ctx, info) => {
return prisma.user.findMany({ ...query });
},
})
);
Copy

The snippet above:

  1. Adds a field to the GraphQL schema's Query type named "users"
  2. Defines a field that resolves to some type in your Prisma schema
  3. Lets Pothos know this field will resolve to an array of your Prisma Client's User type
  4. Sets up a resolver function for this field.

Note: The resolve function's query argument at the beginning of the argument list. This is a specific field Pothos populates when using prismaField function that is used to load data and relations in a performant way. This may be confusing if you come from a GraphQL background as it changes the expected order of arguments.

In order to better visualize what took place, here is the Query type and the users query that will be generated by the code in this section:

type Query {
users: [User!]!
}
Copy

Apply the GraphQL schema

You now have all of your GraphQL object types and queries defined and implemented. The last piece needed is a way to register all of these types and queries in a single place and generate the GraphQL schema based on your configurations.

Create a new file in src named schema.ts:

touch schema.ts
Copy

This file will simply import the models, causing the code within the files to be run, and run the builder instance's toSchema function to generate the GraphQL schema:

// src/schema.ts
import { builder } from "./builder";
import "./models/Message";
import "./models/User";
export const schema = builder.toSchema({});
Copy

The toSchema function generates an abstract syntax tree (AST) representation of your GraphQL schema. Below, you can see what the AST and GraphQL representations would look like:

scalar Date
type Message {
body: String!
createdAt: Date!
id: ID!
}
type Query {
users: [User!]!
}
type User {
id: ID!
messages: [Message!]!
name: String!
}
Copy

Over in your src/index.ts file, import the schema variable you just created and delete the "dummy" schema you created to prevent a duplicate variable warning:

// src/index.ts
import { createServer } from "node:http";
import { createSchema, createYoga } from 'graphql-yoga'
import { schema } from "./schema";
const port = Number(process.env.API_PORT) || 4000
const yoga = createYoga({ schema })
const server = createServer(yoga);
server.listen(port, () => {
console.log(`🚀 GraphQL Server ready at http://localhost:${port}/graphql`);
})
Copy

Fantastic! Your GraphQL schema has been defined using a code-first methodology, your GraphQL object and query types are in sync with your Prisma schema models, and your GraphQL server is being provided the generated GraphQL schema.

At this point, run the server so you can play with the API:

npm run dev
Copy

After running the above command, open up http://localhost:4000/graphql in your browser to access the GraphQL playground. You should be presented with a page that looks like this:

In the top-left corner of the screen, hit the Explorer button to see your API's available queries and mutations:

If you click on the users query type, the right side of the screen will be automatically populated with a query for your user data.

Run that query by hitting the "execute query" button to see the API in action:

Feel free to play around with the different options to choose which fields you would like to query for and which data from the "messages" relation you would like to include.

Summary & What's next

In this article, you built out your entire GraphQL API. The API was built in a type-safe way by taking advantage of Prisma's generated types. These, along with the Pothos Prisma plugin, allowed you to ensure the types across your ORM, GraphQL object types, GraphQL query types, and resolvers were all in sync with the database schema.

Along the way, you:

  • Set up a GraphQL server with GraphQL Yoga
  • Set up the Pothos schema builder
  • Defined your GraphQL object and query types
  • Queried for data using Prisma Client

In the next article, you will wrap things up by setting up code generation to keep the types on your frontend client and API in sync. Then you will deploy your finished application!

Don’t miss the next post!

Sign up for the Prisma Newsletter

Key takeaways from the Discover Data DX virtual event

December 13, 2023

Explore the insights from the Discover Data DX virtual event held on December 7th, 2023. The event brought together industry leaders to discuss the significance and principles of the emerging Data DX category.

Prisma Accelerate now in General Availability

October 26, 2023

Now in General Availability: Dive into Prisma Accelerate, enhancing global database connections with connection pooling and edge caching for fast data access.

Support for Serverless Database Drivers in Prisma ORM Is Now in Preview

October 06, 2023

Prisma is releasing Preview support for serverless database drivers from Neon and PlanetScale. This feature allows Prisma users to leverage the existing database drivers for communication with their database without long-lived TCP connections!