Connecting to Your Database

Connection String

Every Nearbase instance has a unique connection string available on the Overview tab in the console. It follows this format:

postgresql://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require

SSL is required for all connections. Always include sslmode=require (or its equivalent for your driver). Connections without SSL are rejected.

Connection Details

Parameter	Value
Host	`{instance-id}.pg.nearbase.app`
Port	`5432`
Database	`postgres`
Username	`admin`
SSL mode	`require`

Code Examples

psql "postgresql://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require"

import pg from "pg";

const pool = new pg.Pool({
  connectionString:
    "postgresql://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require",
});

const result = await pool.query("SELECT NOW()");
console.log(result.rows[0]);

import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";

const pool = new Pool({
  connectionString:
    "postgresql://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require",
});

export const db = drizzle(pool);

// Add to your .env file:
// DATABASE_URL="postgresql://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require"

// schema.prisma
datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

import psycopg2

conn = psycopg2.connect(
    "postgresql://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require"
)

cursor = conn.cursor()
cursor.execute("SELECT NOW()")
print(cursor.fetchone())
conn.close()

from sqlalchemy import create_engine, text

engine = create_engine(
    "postgresql+psycopg2://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require"
)

with engine.connect() as conn:
    result = conn.execute(text("SELECT NOW()"))
    print(result.fetchone())

package main

import (
    "context"
    "fmt"
    "github.com/jackc/pgx/v5"
)

func main() {
    conn, err := pgx.Connect(
        context.Background(),
        "postgresql://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require",
    )
    if err != nil {
        panic(err)
    }
    defer conn.Close(context.Background())

    var now string
    conn.QueryRow(context.Background(), "SELECT NOW()").Scan(&now)
    fmt.Println(now)
}

Connection Pooling

For production applications, use a connection pool to efficiently reuse database connections rather than opening a new one per request.

A good starting point: set your pool size to 5–10 connections per CPU on your database instance. You can monitor live active connection counts on the Performance tab.

const pool = new pg.Pool({
  connectionString:
    "postgresql://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require",
  max: 10,           // maximum pool size
  idleTimeoutMillis: 30000,
  connectionTimeoutMillis: 2000,
});

engine = create_engine(
    "postgresql+psycopg2://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require",
    pool_size=5,
    max_overflow=10,
    pool_pre_ping=True,
)

import "github.com/jackc/pgx/v5/pgxpool"

config, _ := pgxpool.ParseConfig(
    "postgresql://admin:{password}@{instance-id}.pg.nearbase.app:5432/postgres?sslmode=require",
)
config.MaxConns = 10

pool, err := pgxpool.NewWithConfig(context.Background(), config)

SSL / TLS

All Nearbase databases require TLS. If your driver accepts a configuration object instead of a connection string, enable SSL explicitly:

const pool = new pg.Pool({
  host: "{instance-id}.pg.nearbase.app",
  port: 5432,
  database: "postgres",
  user: "admin",
  password: "{password}",
  ssl: { rejectUnauthorized: true },
});

Need help? Reach out at team@m.nearbase.dev.

Getting Started

Instances

Billing

Connecting to Your Database

Connection String

Connection Details

Code Examples

Connection Pooling

SSL / TLS

​Connection String

​Connection Details

​Code Examples

​Connection Pooling

​SSL / TLS

Connection String

Connection Details

Code Examples

Connection Pooling

SSL / TLS