Postgres
Postgres guide
Connect your Vorynza database with Prisma, Drizzle, psql, or any Postgres client.
Use any standard Postgres client, ORM, or tool. Your Vorynza database works like any other PostgreSQL database.
Connection string format
Your Vorynza connection string uses the standard PostgreSQL URI format with SSL enforced.
postgresql://<username>:<password>@<host>:5432/<database>?sslmode=requireConnect with Prisma
Add your connection string to your .env file, then configure your Prisma schema.
DATABASE_URL="postgresql://vnz_xxxx_user:your-password@host:5432/vnz_xxxx_db?sslmode=require"datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}npx prisma generate
npx prisma db pushConnect with Drizzle
Install drizzle-orm and postgres, then create your client.
npm install drizzle-orm postgresimport { drizzle } from 'drizzle-orm/postgres-js'
import postgres from 'postgres'
const client = postgres(process.env.DATABASE_URL!)
export const db = drizzle(client)Connect with psql
Copy your connection string from the Vorynza dashboard and connect directly.
psql "postgresql://vnz_xxxx_user:your-password@host:5432/vnz_xxxx_db?sslmode=require"Connect with node-postgres (pg)
Use the pg package directly for raw query access.
npm install pg @types/pgimport { Pool } from 'pg'
const pool = new Pool({
connectionString: process.env.DATABASE_URL,
ssl: { rejectUnauthorized: false }
})
const result = await pool.query('SELECT NOW()')
console.log(result.rows[0])Need help connecting? Contact support.