SQL.Options

interface Options

const config: Bun.SQL.Options = {
  host: 'localhost',
  port: 5432,
  user: 'dbuser',
  password: 'secretpass',
  database: 'myapp',
  idleTimeout: 30,
  max: 20,
  onconnect: (client) => {
    console.log('Connected to database');
  }
};

• adapter?: string & {} | 'postgres'

  Database adapter/driver to use

• bigint?: boolean

  By default values outside i32 range are returned as strings. If this is true, values outside i32 range are returned as BigInts.

• connection?: Record<string, string | number | boolean>

  Postgres client runtime configuration options

• connectionTimeout?: number

  Maximum time in seconds to wait when establishing a connection

• database?: string

  Name of the database to connect to

• host?: string

  Database server hostname

• idleTimeout?: number

  Maximum time in seconds to wait for connection to become available

• max?: number

  Maximum number of connections in the pool

• maxLifetime?: number

  Maximum lifetime in seconds of a connection

• onclose?: (client: SQL) => void

  Callback function executed when a connection is closed

• onconnect?: (client: SQL) => void

  Callback function executed when a connection is established

• password?: string | () => MaybePromise<string>

  Database password for authentication

• port?: string | number

  Database server port number

• prepare?: boolean

  Automatic creation of prepared statements

• ssl?: boolean | TLSOptions

  Whether to use TLS/SSL for the connection (alias for tls)

• tls?: boolean | TLSOptions

  Whether to use TLS/SSL for the connection

• url?: string | URL

  Connection URL (can be string or URL object)

• username?: string

  Database user for authentication