Skip to main content

Neon Postgres


A guide to integrate Neon resources in genezio projects

Introduction to Neon

Neon is a fully managed serverless Postgres provider. Neon separates storage and compute and offers modern developer features such as serverless, branching, bottomless storage, and more.

Set up a Neon Postgres Database

Navigate to the project integration page in the dashboard and select to Install a Neon Postgres database to your project:

Connect with an Neon account using the preferred login method:

Create a Neon project or select an already existing project:

Select the branch, database and role for the Neon project:

Hit Save to save the database credentials as backend environment variables

Use the environment variables in your genezio project to connect to the Postgres database.

import { Pool } from "pg";

const pool = new Pool({
connectionString: process.env.NEON_DATABASE_URL,

pool.query("SELECT * FROM your_table_name", (error, results) => {
console.log("Query Result:", results.rows);

Note: Install pg using npm, if you don't have this dependency already in your project:

npm install pg

Test Locally with a Neon Postgres Database

To test your project locally, you have to create a file named .env and store the Neon Postgres credentials there. This file should be in the root directory of your backend.

Use the genezio dashboard under Integrations/Neon Postgres card to copy the Postgres credentials in your .env file.


Now you can use genezio local to start a server locally that will also load up the necessary environment variables to connect to the Postgres database.