What do you want to automate

with MQTT and PostgreSQL?

import mqtt from "mqtt";

export default defineComponent({
  props: {
    mqtt: {
      type: "app",
      app: "mqtt",
    }
  },
  async run({ steps, $ }) {
    const url = `${this.mqtt.$auth.protocol}://${this.mqtt.$auth.host}:${this.mqtt.$auth.port}`;
    const options = {
      clientId: this.mqtt.$auth.client_id ?? `pipedream-client-${Date.now()}`,
      connectTimeout: 5000,
      username: this.mqtt.$auth.username,
      password: this.mqtt.$auth.password,
    };

    const client = mqtt.connect(url, options);

    await new Promise((resolve) => {
      client.on("connect", () => {
        client.publish("pipedream/test", 'Welcome MQTT + Pipedream users! ' + new Date().toISOString(), () => {
          client.end();
          console.log("Message sent");
          resolve();
        });
      });
    });

    return {
      mqttClientIsConnected: client.connected,
    };
  },
})

import postgresql from "@pipedream/postgresql"

export default defineComponent({
  props: {
    postgresql,
  },
  async run({ steps, $ }) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/postgresql

    const queryObj = {
      text: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    return await this.postgresql.executeQuery(queryObj);
  },
})