ContextQMD
Back to Prisma

Fly.io

apps/docs/content/docs.v6/postgres/integrations/flyio.mdx

latest3.9 KB
Original Source

Fly.io is a cloud application platform that lets you deploy full-stack applications globally. This guide shows you how to deploy a Node.js application using Prisma Postgres to Fly.io.

Prerequisites

Deploy your application

1. Generate Prisma Client in postinstall

Ensure your package.json includes a postinstall script to generate Prisma Client during deployment:

json
{
  // ...
  "scripts": {
    // ...
    "postinstall": "prisma generate" // [!code ++]
  }
}

2. Launch your app with Fly.io

From your project directory, run:

bash
fly launch

Follow the prompts to configure your application. Fly.io will auto-detect your Node.js application and create the necessary configuration.

3. Set your database connection string

Add your Prisma Postgres DATABASE_URL as a secret in Fly.io:

bash
fly secrets set DATABASE_URL="your-prisma-postgres-connection-string"

:::tip You can find your DATABASE_URL in your .env file or in the Prisma Console. :::

4. Deploy

If not already deployed during fly launch, deploy your application:

bash
fly deploy

Once the deployment completes, you'll see a success message with your app's URL:

šŸŽ‰  SUCCESS! Your app is live and ready to use!  šŸŽ‰

Visit: https://your-app-name.fly.dev/

:::note In the Fly.io dashboard, your app's status may show as "Pending" initially. It typically transitions to "Deployed" within a few minutes. :::

Additional considerations

Ensure your project uses the correct environment variable

Ensure that the data source in your prisma.config.ts file is configured to use the DATABASE_URL environment variable:

ts
import "dotenv/config";
import { defineConfig, env } from "prisma/config";

export default defineConfig({
  datasource: {
    url: env("DATABASE_URL"),
  },
  schema: "./prisma/schema.prisma",
});

Running migrations in production

To run migrations on your deployed Fly.io app, you can use:

bash
fly ssh console -C "npx prisma migrate deploy"

Or add a release command to your fly.toml:

toml
[deploy]
  release_command = "npx prisma migrate deploy"

Scaling and regions

Fly.io lets you scale and place your application in multiple regions. For optimal performance, deploy your app in a region close to your Prisma Postgres database region.

bash
fly scale count 2 --region iad

Troubleshooting

Prisma schema not found or Client not generated correctly

If you're using a custom Dockerfile and your build fails because the Prisma Client cannot be found, it's likely due to one of two reasons:

  1. Order of operations: npm install (which runs postinstall) runs before the schema is copied.
  2. Incorrect copy path: The schema is copied to the root instead of the prisma folder.

Solution: In your Dockerfile, copy the prisma/ directory to ./prisma before running npm install:

dockerfile
# āŒ Wrong order or path
COPY package*.json ./
COPY prisma .                   # Copies contents to root (wrong structure)
RUN npm install                 # postinstall runs but might fail or generate in wrong place

# āœ… Correct order and path
COPY package*.json ./
COPY prisma ./prisma            # Copies to ./prisma folder (preserves structure)
RUN npm install                 # postinstall finds schema in expected location
COPY . .

More information