Get started
Overview PostgreSQL Manage schema
Overview Column types Indexes & Constraints Migrations Views Schemas Access your data
Query Select Insert Update Delete Filters Joins Magic sql`` operator Performance
Queries Serverless Advanced
Set Operations Transactions Batch Dynamic query building Read Replicas Custom types Goodies Extensions
ESLint Plugin drizzle-zod drizzle-typebox drizzle-valibot AWS Data API
AWS Data API
Drizzle ORM natively supports aws-sdk driver with drizzle-orm/aws-data-api package.
npm
yarn
pnpm
bun
npm i drizzle-orm @aws-sdk/client-rds-data @aws-sdk/credential-providers
npm i -D drizzle-kityarn add drizzle-orm @aws-sdk/client-rds-data @aws-sdk/credential-providers
yarn add -D drizzle-kitpnpm add drizzle-orm @aws-sdk/client-rds-data @aws-sdk/credential-providers
pnpm add -D drizzle-kitbun add drizzle-orm @aws-sdk/client-rds-data @aws-sdk/credential-providers
bun add -D drizzle-kitimport { drizzle } from 'drizzle-orm/aws-data-api/pg';
import { RDSDataClient } from '@aws-sdk/client-rds-data';
import { fromIni } from '@aws-sdk/credential-providers';
const rdsClient = new RDSDataClient({
credentials: fromIni({ profile: process.env['PROFILE'] }),
region: 'us-east-1',
});
const db = drizzle(rdsClient, {
database: process.env['DATABASE']!,
secretArn: process.env['SECRET_ARN']!,
resourceArn: process.env['RESOURCE_ARN']!,
});
await db.select().from(...)...;