What do you want to automate

with PostgreSQL and BitMEX?

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);
  },
})

import crypto from "crypto";
import { axios } from "@pipedream/platform";

export default defineComponent({
  props: {
    bitmex: {
      type: "app",
      app: "bitmex",
    }
  },
  async run({ steps, $ }) {
    // Set verb, path, and data as needed
    const verb = "GET";
    const path = "/api/v1/user";
    const expires = Math.floor(Date.now() / 1000) + 60; // UNIX timestamp in seconds
    const data = ""; // No body for GET

    // Function to generate signature
    function generateSignature(apiSecret, verb, path, expires, data) {
      const message = verb + path + expires + data;
      return crypto
        .createHmac("sha256", apiSecret)
        .update(message)
        .digest("hex");
    }

    // Build headers
    const signature = generateSignature(
      this.bitmex.$auth.api_secret,
      verb,
      path,
      expires,
      data
    );

    const headers = {
      "api-key": this.bitmex.$auth.api_key,
      "api-expires": expires,
      "api-signature": signature,
    };

    // Perform request
    return await axios($, {
      method: verb,
      url: `${this.bitmex.$auth.api_url}${path}`,
      headers,
    });
  },
})