Drizzle Studio with AWS Aurora Serverless

// drizzle.config.ts
import type { Config } from 'drizzle-kit';

export default {
  driver: 'pg',
  schema: 'src/schemas/index.ts',
  out: 'src/migrations',
} satisfies Config;

// database.ts
import { drizzle } from 'drizzle-orm/aws-data-api/pg';

import { RDS } from 'sst/node/rds';
import { RDSDataClient } from '@aws-sdk/client-rds-data';

import * as schema from '@/schemas';

export const database = drizzle(new RDSDataClient({}), {
  database: RDS.database.defaultDatabaseName,
  secretArn: RDS.database.secretArn,
  resourceArn: RDS.database.clusterArn,
  schema,
});