with PostgreSQL and OpenAI (ChatGPT)?
Emit new event when a new column is added to a table. See the documentation
Emit new event when a row is added or modified. See the documentation
Emit new event when a new row is added to a table. See the documentation
Emit new event when new rows are returned from a custom query that you provide. See the documentation
Emit new event when a new table is added to the database. See the documentation
Emit new event when a new batch is completed in OpenAI. See the documentation
Emit new event when a new file is created in OpenAI. See the documentation
Emit new event when a new fine-tuning job is created in OpenAI. See the documentation
Emit new event every time a run changes its status. See the documentation
The Chat API, using the gpt-3.5-turbo
or gpt-4
model. See the documentation
Chat using the web search tool. See the documentation
Chat with your models and allow them to invoke functions. Optionally, you can build and invoke workflows as functions. See the documentation
Finds a row in a table via a custom query. See the documentation
Chat with your files knowledge base (vector stores). See the documentation
Summarizes text using the Chat API. See the documentation
Classify items into specific categories using the Chat API. See the documentation
Translate text from one language to another using the Chat API. See the documentation
Transcribes audio into the input language. See the documentation
Creates an image given a prompt returning a URL to the image. See the documentation
Get a vector representation of a given input that can be easily consumed by machine learning models and algorithms. See the documentation
OpenAI recommends using the Chat action for the latest gpt-3.5-turbo
API, since it's faster and 10x cheaper. This action creates a completion for the provided prompt and parameters using the older /completions
API. See the documentation
Send a message or question about an image and receive a response. See the documentation
Cancels a run that is in progress. See the documentation
Sends a message and generates a response, storing the message history for a continuous conversation. See the documentation
Send a chat via the Responses API, mixing built-in tools and MCP server tools. See the documentation
Generates audio from the input text. See the documentation
Creates an assistant with a model and instructions. See the documentation
Creates and executes a batch from an uploaded file of requests. See the documentation
Creates a job that fine-tunes a specified model from a given dataset. See the documentation
Classifies if text is potentially harmful. See the documentation
Creates a thread with optional messages and metadata, and optionally runs the thread using the specified assistant. See the documentation
Create a vector store file. See the documentation
Deletes a specified file from OpenAI. See the documentation
Deletes a vector store file. See the documentation
Returns a list of files that belong to the user's organization. See the documentation
Lists the messages for a given thread. See the documentation
Returns a list of run steps belonging to a run. See the documentation
Returns a list of runs belonging to a thread. See the documentation
Returns a list of vector store file. See the documentation
Returns a list of vector stores. See the documentation
Modifies an existing OpenAI assistant. See the documentation
Retrieves a specific file from OpenAI. See the documentation
Retrieves the contents of the specified file. See the documentation
Retrieves a specific run within a thread. See the documentation
Retrieve a specific run step in a thread. See the documentation
Retrieve a vector store file. See the documentation
Submits tool outputs to a run that requires action. See the documentation
Upload a file that can be used across various endpoints/features. The size of individual files can be a maximum of 512mb. See the documentation
On Pipedream, you can leverage the PostgreSQL app to create workflows that automate database operations, synchronize data across platforms, and react to database events in real-time. Think handling new row entries, updating records from webhooks, or even compiling reports on a set schedule. Pipedream's serverless platform provides a powerful way to connect PostgreSQL with a variety of apps, enabling you to create tailored automation that fits your specific needs.
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); }, })
OpenAI provides a suite of powerful AI models through its API, enabling developers to integrate advanced natural language processing and generative capabilities into their applications. Here’s an overview of the services offered by OpenAI's API:
Use Python or Node.js code to make fully authenticated API requests with your OpenAI account:
import { axios } from "@pipedream/platform" export default defineComponent({ props: { openai: { type: "app", app: "openai", } }, async run({steps, $}) { return await axios($, { url: `https://api.openai.com/v1/models`, headers: { Authorization: `Bearer ${this.openai.$auth.api_key}`, }, }) }, })