To create a code similar to the “Find Row” action in Pipedream, you can use the following component: import pg from "pg"; export default defineComponent({ props: { postgresql: { type: "app", app: "postgresql", }, schema: { type: "string", label: "Schema", description: "Select the schema you want to use", }, table: { type: "string", label: "Table", description: "Enter the table name you want to search in", }, column: { type: "string", label: "Column", description: "Enter the column name you want to search by", }, value: { type: "string", label: "Value", description: "Enter the value you want to search for", }, }, async run({ steps, $ }) { const { host, user, password, port, database } = this.postgresql.$auth; const client = new pg.Client({ host, database, user, password, port, }); await client.connect(); const query = `SELECT * FROM "${this.schema}"."${this.table}" WHERE "${this.column}" = $1;`; this.results = (await client.query(query, [this.value])).rows; await client.end(); }, }); This component connects to your PostgreSQL database using the provided credentials, searches for a row in the specified table and schema based on the given column and value, and stores the result in this.results. Make sure your PostgreSQL database is accessible from Pipedream, either through the public internet or via an SSH server.