App: app_1M0hNB

{
  "data": {
    "id": "app_1M0hNB",
    "name_slug": "postgresql",
    "name": "PostgreSQL",
    "auth_type": "keys",
    "description": "PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.",
    "img_src": "https://assets.pipedream.net/s.v0/app_1M0hNB/logo/orig",
    "custom_fields_json": "[{\"name\":\"host\",\"label\":\"Host\",\"description\":\"The hostname or IP address of your PostgreSQL server\",\"default\":null,\"optional\":null,\"enable_extract\":null},{\"name\":\"port\",\"label\":\"Port\",\"description\":\"Typically `5432`, unless you run PostgreSQL on a different port\",\"default\":\"5432\",\"optional\":null,\"enable_extract\":null},{\"name\":\"user\",\"label\":\"Username\",\"description\":\"The account username to log in\",\"default\":null,\"optional\":null,\"enable_extract\":null},{\"name\":\"password\",\"label\":\"Password\",\"description\":\"The account password to log in\",\"default\":null,\"optional\":null,\"type\":\"password\"},{\"name\":\"database\",\"label\":\"Database Name\",\"description\":\"The name of the PostgreSQL database to run queries against\",\"default\":null,\"optional\":null,\"enable_extract\":null},{\"name\":\"use_pd_sql_proxy\",\"label\":\"Use Shared Static IP\",\"description\":\"Enable requests from this database connection to originate from a shared static IP that you can add to your database allow-list.\\n\\n**Add this IP block to your database allow-list: `44.223.89.56/29`**\",\"default\":\"true\",\"optional\":null,\"type\":\"boolean\"},{\"name\":\"ssl_verification_mode\",\"label\":\"SSL Verification Mode\",\"description\":\"**Full Verification (default)**: Verifies that the server's SSL certificate is from a trusted Certificate Authority, and that the certificate's hostname matches the server you're connecting to.\\n\\n**Skip Verification**: Bypasses SSL certificate validation, which is not recommended. This can be useful for testing with self-signed certificates.\",\"default\":\"verify_identity\",\"optional\":false,\"type\":\"options\",\"options\":[{\"label\":\"Full Verification\",\"value\":\"verify_identity\"},{\"label\":\"Skip Verification\",\"value\":\"skip_verification\"}]},{\"name\":\"ca\",\"label\":\"SSL CA Bundle\",\"description\":\"The Certificate Authority text to use for the connection. E.g. (`-----BEGIN CERTIFICATE-----\\\\\\\\nMIIDBTCCAe2gAwIBAgIJA...`)\",\"default\":null,\"optional\":true,\"enable_extract\":true},{\"name\":\"key\",\"label\":\"SSL Private Key\",\"description\":\"The key text to use for the connection. E.g. (`-----BEGIN PRIVATE KEY-----\\\\\\\\nMIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQDQ...`)\",\"default\":null,\"optional\":true,\"enable_extract\":true},{\"name\":\"cert\",\"label\":\"SSL Client Certificate\",\"description\":\"The certificate text to use for the connection. E.g. (`-----BEGIN CERTIFICATE-----\\\\\\\\nMIIDBTCCAe2gAwIBAgIJA...`)\",\"default\":null,\"optional\":true,\"enable_extract\":true},{\"name\":\"pd_schema_explorer_retrieve_all\",\"label\":\"Retreive All Schemas\",\"description\":\"Defaults to only retrieving the `public` schema. If you need other schemas to be retrieved, set this value to `True`.\",\"default\":\"false\",\"optional\":true,\"type\":\"boolean\"}]",
    "categories": [
      "Databases"
    ],
    "featured_weight": 1000000009,
    "connect": {
      "allowed_domains": null,
      "base_proxy_target_url": null,
      "proxy_enabled": false
    }
  }
}