Build and Deploy a GraphQL API to the Edge with MySQL and PlanetScale — Part 3

Build and Deploy a GraphQL API to the Edge with MySQL and PlanetScale — Part 3

Set up Database Connection

We're going to use the serverless PlanetScale database driver inside our Grafbase Edge Resolvers. Run the following command to install the @planetscale/database dependency:

npm install @planetscale/database

Now open the connection settings inside your PlanetScale database and obtain copy the values.

PlanetScale connection environment variables

Now create the file grafbase/.env and paste the contents from above:

DATABASE_HOST=
DATABASE_USERNAME=
DATABASE_PASSWORD=

Finally, create the file grafbase/lib.ts and add the following config export:

export const config = {
  host: process.env.DATABASE_HOST,
  username: process.env.DATABASE_USERNAME,
  password: process.env.DATABASE_PASSWORD
}

That's it! We'll use this next in our first mutation resolver!

👉 Continue to Part 4