Skip to content
Dashboard

AWS databases now available on the Vercel Marketplace

lib/postgres.ts
import { Signer } from "@aws-sdk/rds-signer";
import { awsCredentialsProvider } from "@vercel/functions/oidc";
import { attachDatabasePool } from "@vercel/functions";
import { Pool } from "pg";
const signer = new Signer({
hostname: process.env.PGHOST,
port: Number(process.env.PGPORT),
username: process.env.PGUSER,
region: process.env.AWS_REGION,
credentials: awsCredentialsProvider({
roleArn: process.env.AWS_ROLE_ARN,
clientConfig: { region: process.env.AWS_REGION },
}),
});
export const pool = new Pool({
host: process.env.PGHOST,
user: process.env.PGUSER,
database: process.env.PGDATABASE || "postgres",
password: () => signer.getAuthToken(),
port: Number(process.env.PGPORT),
ssl: { rejectUnauthorized: false },
});
attachDatabasePool(pool);

Setup a database client

Link to headingGetting started

Ready to deploy?