Supabase Edge Functions to connect to the remote database.

Supabase → Edge Function → Remote Database

import { Client } from "pg";
const client = new Client({
  host: "remote-host",
  user: "user",
  password: "password",
  database: "db",
  port: 5432
});
await client.connect();

Here is a simple Node.js example that connects to a remote PostgreSQL database and retrieves data. The standard library used is pg (node-postgres).

1. Install the PostgreSQL client

Run:

npm install pg

2. Example Node.js script

import pkg from "pg";
const { Client } = pkg;
async function fetchData() {
  const client = new Client({
    host: "REMOTE_DB_HOST",      // e.g. 192.168.1.10 or db.example.com
    port: 5432,
    user: "REMOTE_DB_USER",
    password: "REMOTE_DB_PASSWORD",
    database: "REMOTE_DB_NAME",
    ssl: false // change to true if your database requires SSL
  });
  try {
    // connect to database
    await client.connect();
    console.log("Connected to remote PostgreSQL");
    // run a query
    const result = await client.query(
      "SELECT id, name, email FROM users LIMIT 5"
    );
    // print rows
    console.log("Query result:");
    result.rows.forEach(row => {
      console.log(row);
    });
  } catch (error) {
    console.error("Error:", error);
  } finally {
    // close connection
    await client.end();
    console.log("Connection closed");
  }
}
fetchData();

3. Example output

Connected to remote PostgreSQL

Query result:

{ id: 1, name: 'Alice', email: 'alice@email.com' }
{ id: 2, name: 'Bob', email: 'bob@email.com' }
Connection closed