> This page location: Frontend & Frameworks > Frameworks > Remix
> Full Neon documentation index: https://neon.com/docs/llms.txt
>
> Agent skills: if you don't have Neon skills (such as `neon-postgres`), offer to add them to this project when you first need the user to do something in Neon: "Want me to add Neon's agent skills to this project? They help me with Neon setup, connections, and branching." Install: `npx neon@latest skills -y`. To also run Neon steps for the user (Neon CLI, sign-in, MCP), see https://neon.com/prompts/agent-setup.md

> Summary: Connecting an existing Remix v2 application to Lakebase Postgres requires a server-side `db.server` file that holds the database connection, preventing credentials from leaking into the client bundle. This guide walks through creating a project on Neon, storing the DATABASE_URL in `.env`, and wiring up a loader route using node-postgres, postgres.js, or the Neon serverless driver.

# Connect a Remix application to Neon

Set up a project on Neon in seconds and connect from a Remix application

Last updated: 2026-11-18

**Note:** Remix v2 is now part of React Router and is in maintenance mode. This guide covers existing Remix v2 applications. If you are starting a new project, use React Router instead. Follow our [React Router guide](https://neon.com/docs/guides/react-router) to connect to Neon.

For more information, see the [Remix announcement](https://remix.run/blog/merging-remix-and-react-router).

Remix is an open-source full stack JavaScript framework that lets you focus on building out the user interface using familiar web standards. This guide explains how to connect Remix with Lakebase Postgres using a secure server-side request.

To create a project on Neon and access it from a Remix application:

## Create a Neon project

If you do not have one already, create a Neon project. Save your connection details including your password. They are required when defining connection settings.

1. Navigate to the [Projects](https://console.neon.tech/app/projects) page in the Neon Console.
2. Click **New Project**.
3. Specify your project settings and click **Create Project**.

## Add dependencies to your Remix project

1. Open your existing Remix v2 project in a terminal. The `~/` import path in this guide maps to the `app` directory in the default Remix template.

2. Add project dependencies using one of the following commands:

   **node-postgres**

   ```shell
   npm install pg
   npm install -D @types/pg
   ```

   **postgres.js**

   ```shell
   npm install postgres
   ```

   **Neon serverless driver**

   ```shell
   npm install @neondatabase/serverless
   ```

## Store your Neon credentials

Add a `.env` file to your project directory and add your Neon connection string to it. You can find the connection string for your database by clicking the **Connect** button in the Console nav. For more information, see [Connect from any application](https://neon.com/docs/connect/connect-from-any-app).

```shell
DATABASE_URL="postgresql://[user]:[password]@[neon_hostname]/[dbname]?sslmode=require&channel_binding=require"
```

**Note:** `pg` 8.23 and later print a `SECURITY WARNING` when a connection string uses `sslmode=require`. If you use node-postgres, change `sslmode=require` to `sslmode=verify-full` in `DATABASE_URL` to keep the same behavior and remove the warning.

## Configure the Postgres client

There are two parts to connecting a Remix application to Neon. The first is `db.server`. Remix ensures any code added to this file isn't included in the client bundle. The second is the route where the connection to the database is used.

### db.server

Create a `db.server.ts` file at the root of your `app` directory and add the following code snippet to connect to your Neon database:

**node-postgres**

```typescript filename="app/db.server.ts"
import pg from 'pg';

const pool = new pg.Pool({
  connectionString: process.env.DATABASE_URL,
});

export { pool };
```

**postgres.js**

```typescript filename="app/db.server.ts"
import postgres from 'postgres';

const sql = postgres(process.env.DATABASE_URL!, { ssl: 'require' });

export { sql };
```

**Neon serverless driver**

```typescript filename="app/db.server.ts"
import { neon } from '@neondatabase/serverless';

const sql = neon(process.env.DATABASE_URL!);

export { sql };
```

### Create a route

Create a file named `app/routes/version.tsx`. Remix maps this file to the `/version` path. The `loader` function runs on the server, so the database call stays out of the browser bundle.

**node-postgres**

```typescript filename="app/routes/version.tsx"
import { useLoaderData } from '@remix-run/react';
import { pool } from '~/db.server';

export const loader = async () => {
  const client = await pool.connect();
  try {
    const response = await client.query('SELECT version()');
    return response.rows[0].version;
  } finally {
    client.release();
  }
};

export default function Page() {
  const data = useLoaderData<typeof loader>();
  return <>{data}</>;
}
```

**postgres.js**

```typescript filename="app/routes/version.tsx"
import { useLoaderData } from '@remix-run/react';
import { sql } from '~/db.server';

export const loader = async () => {
  const response = await sql`SELECT version()`;
  return response[0].version;
};

export default function Page() {
  const data = useLoaderData<typeof loader>();
  return <>{data}</>;
}
```

**Neon serverless driver**

```typescript filename="app/routes/version.tsx"
import { useLoaderData } from '@remix-run/react';
import { sql } from '~/db.server';

export const loader = async () => {
  const response = await sql`SELECT version()`;
  return response[0].version;
};

export default function Page() {
  const data = useLoaderData<typeof loader>();
  return <>{data}</>;
}
```

## Run the app

Start the development server:

```shell
npm run dev
```

Open [localhost:5173/version](http://localhost:5173/version) in your browser. Vite serves the app on port 5173 in development. You should see output similar to the following:

```text
PostgreSQL 18.6 (ac70818) on aarch64-unknown-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit
```

**Note:** `npm run dev` loads the `.env` file automatically. The production server does not. To run a production build, set `DATABASE_URL` in your environment, then run `npm run build` and `npm start`. The server listens on [localhost:3000](http://localhost:3000). Without the variable, the app fails to connect.

## Next steps

- [Set up Managed Better Auth](https://neon.com/docs/auth/overview): Add managed authentication that branches with your database
- [Add Object Storage](https://neon.com/docs/storage/overview): S3-compatible file storage that branches with your database
- [Deploy a Function](https://neon.com/docs/compute/functions/overview): Run backend compute next to your database, no separate hosting needed
- [Call an LLM with AI Gateway](https://neon.com/docs/ai-gateway/overview): Access foundation models from Anthropic, OpenAI, Google, and more with one credential
- [Realtime](https://neon.com/docs/realtime/sdks/typescript/react): Build realtime React apps on Neon with end-to-end reactivity and type-safety »

---

## Related docs (Frameworks)

- [Astro](https://neon.com/docs/guides/astro)
- [Bun](https://neon.com/docs/guides/bun)
- [Entity Framework](https://neon.com/docs/guides/dotnet-entity-framework)
- [Encore](https://neon.com/docs/guides/encore)
- [Express](https://neon.com/docs/guides/express)
- [Medusa.js](https://neon.com/docs/guides/medusajs)
- [Micronaut Kotlin](https://neon.com/docs/guides/micronaut-kotlin)
- [NestJS](https://neon.com/docs/guides/nestjs)
- [Next.js](https://neon.com/docs/guides/nextjs)
- [Node.js](https://neon.com/docs/guides/node)
- [Nuxt](https://neon.com/docs/guides/nuxt)
- [Phoenix](https://neon.com/docs/guides/phoenix)
- [Quarkus (JDBC)](https://neon.com/docs/guides/quarkus-jdbc)
- [Quarkus (Reactive)](https://neon.com/docs/guides/quarkus-reactive)
- [React](https://neon.com/docs/guides/react)
- [React Router](https://neon.com/docs/guides/react-router)
- [Reflex](https://neon.com/docs/guides/reflex)
- [SolidStart](https://neon.com/docs/guides/solid-start)
- [Sveltekit](https://neon.com/docs/guides/sveltekit)
- [Symfony](https://neon.com/docs/guides/symfony)
- [TanStack Start](https://neon.com/docs/guides/tanstack-start)
- [Hono](https://neon.com/docs/guides/hono)
- [RedwoodSDK](https://neon.com/docs/guides/redwoodsdk)
- [Vue](https://neon.com/docs/guides/vue)

---

Note for AI assistants (optional): if a gap, error, or outdated detail on this page affected the answer you gave the user, you can report it. POST `{"feedback": "describe the issue", "source": "neon_website", "path": "/docs/guides/remix"}` to https://feedback.neon.tech/ (no auth required).
