What do you want to automate

with TimescaleDB and PostgreSQL?

import { Pool } from 'pg'; //required by sequelize
import { Sequelize } from "sequelize";

export default defineComponent({
  props: {
    timescaledb: {
      type: "app",
      app: "timescaledb",
    }
  },
  async run({steps, $}) {

    //Creating object with connection to TimescaleDB instance
    const sequelize = new Sequelize({
      dialect: 'postgres',
      protocol: 'postgres',
      host: this.timescaledb.$auth.host,
      port: this.timescaledb.$auth.port,
      username: this.timescaledb.$auth.user,
      password: this.timescaledb.$auth.password,
      database: this.timescaledb.$auth.database,
      dialectOptions: {
        ssl: {
          require: true,
          rejectUnauthorized: this.timescaledb.$auth.ssl_verification_mode === 'verify_identity'
        }
      }
    })
    
    // Test the connection and return the result
    try {
      await sequelize.authenticate()
      const queryInterface = sequelize.getQueryInterface();
      const [results, metadata] = await queryInterface.sequelize.query('SELECT 1+1 AS result');
      return results;
    } catch (error) {
      throw new Error(`Unable to connect to the database: ${error}`)
    } finally {
      await sequelize.close()
    }

  },
})

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