{"resource_type":{"id":114,"name":"postgresql","schema":"{\n\t\"$schema\": \"https://json-schema.org/draft/2020-12/schema\",\n\t\"properties\": {\n\t\t\"dbname\": {\n\t\t\t\"description\": \"The database name\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"host\": {\n\t\t\t\"description\": \"The instance host\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"password\": {\n\t\t\t\"description\": \"The postgres users password\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"port\": {\n\t\t\t\"description\": \"The instance port\",\n\t\t\t\"type\": \"integer\"\n\t\t},\n\t\t\"region\": {\n\t\t\t\"description\": \"AWS region for IAM auth (e.g. us-east-1). Falls back to AWS_REGION env var if not set.\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"root_certificate_pem\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"The root certificate in pe format\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"sslmode\": {\n\t\t\t\"description\": \"Most cloud databases (Heroku, AWS, Supabase, etc.) require SSL. Self-hosted databases typically don't.\",\n\t\t\t\"enum\": [\n\t\t\t\t\"disable\",\n\t\t\t\t\"allow\",\n\t\t\t\t\"prefer\",\n\t\t\t\t\"require\",\n\t\t\t\t\"verify-ca\",\n\t\t\t\t\"verify-full\"\n\t\t\t],\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"use_iam_auth\": {\n\t\t\t\"default\": false,\n\t\t\t\"description\": \"Use IAM authentication (AWS RDS/Aurora). When enabled, the password field is ignored and a short-lived IAM token is generated instead.\",\n\t\t\t\"type\": \"boolean\"\n\t\t},\n\t\t\"user\": {\n\t\t\t\"description\": \"The postgres username\",\n\t\t\t\"type\": \"string\"\n\t\t}\n\t},\n\t\"required\": [\n\t\t\"dbname\",\n\t\t\"user\",\n\t\t\"password\"\n\t],\n\t\"type\": \"object\"\n}","approved":true,"app":"postgresql","description":"PostgreSQL connection","created_by":"rubenfiszel","created_at":"2023-08-27T10:00:43.813Z"}}