Postgresql
PostgreSQL connection
| 1 | { |
| 2 | "$schema": "https://json-schema.org/draft/2020-12/schema", |
| 3 | "properties": { |
| 4 | "dbname": { |
| 5 | "description": "The database name", |
| 6 | "type": "string" |
| 7 | }, |
| 8 | "host": { |
| 9 | "description": "The instance host", |
| 10 | "type": "string" |
| 11 | }, |
| 12 | "password": { |
| 13 | "description": "The postgres users password", |
| 14 | "type": "string" |
| 15 | }, |
| 16 | "port": { |
| 17 | "description": "The instance port", |
| 18 | "type": "integer" |
| 19 | }, |
| 20 | "region": { |
| 21 | "description": "AWS region for IAM auth (e.g. us-east-1). Falls back to AWS_REGION env var if not set.", |
| 22 | "type": "string" |
| 23 | }, |
| 24 | "root_certificate_pem": { |
| 25 | "default": "", |
| 26 | "description": "The root certificate in pe format", |
| 27 | "type": "string" |
| 28 | }, |
| 29 | "sslmode": { |
| 30 | "description": "Most cloud databases (Heroku, AWS, Supabase, etc.) require SSL. Self-hosted databases typically don't.", |
| 31 | "enum": [ |
| 32 | "disable", |
| 33 | "allow", |
| 34 | "prefer", |
| 35 | "require", |
| 36 | "verify-ca", |
| 37 | "verify-full" |
| 38 | ], |
| 39 | "type": "string" |
| 40 | }, |
| 41 | "use_iam_auth": { |
| 42 | "default": false, |
| 43 | "description": "Use IAM authentication (AWS RDS/Aurora). When enabled, the password field is ignored and a short-lived IAM token is generated instead.", |
| 44 | "type": "boolean" |
| 45 | }, |
| 46 | "user": { |
| 47 | "description": "The postgres username", |
| 48 | "type": "string" |
| 49 | } |
| 50 | }, |
| 51 | "required": [ |
| 52 | "dbname", |
| 53 | "user", |
| 54 | "password" |
| 55 | ], |
| 56 | "type": "object" |
| 57 | } |