Database
Query a SQL Database with a built-in SQL editor and Schema Explorer
Integrate the Database API with the OpenAI (ChatGPT) API
Setup the Database API trigger to run a workflow which integrates with the OpenAI (ChatGPT) API. Pipedream's integration platform allows you to integrate Database and OpenAI (ChatGPT) remarkably fast. Free for developers.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Ways to Connect Database with OpenAI (ChatGPT)#
Popular Database and OpenAI (ChatGPT) Triggers#
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
Popular Database and OpenAI (ChatGPT) Actions#
The Chat API, using the gpt-3.5-turbo or gpt-4 model. 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
Overview of Database#
The Database API on Pipedream allows users to execute SQL commands directly within workflows, enabling rich and dynamic data manipulation and storage. It supports PostgreSQL, MySQL, and SQLite, making it a versatile option for managing data across various database systems. With this API, users can perform tasks such as data insertion, querying, updates, and deletions, directly within their automations, facilitating real-time data processing and integration across multiple platforms.
Connect Database#
import postgresql from "@pipedream/postgresql";
export default {
props: {
postgresql,
sql: {
type: "sql",
auth: {
app: "postgresql",
},
label: "PostreSQL Query",
},
},
async run({ $ }) {
const args = this.postgresql.executeQueryAdapter(this.sql);
const data = await this.postgresql.executeQuery(args);
return data;
},
};
Overview of OpenAI (ChatGPT)#
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:
Connect OpenAI (ChatGPT)#
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}`,
},
})
},
})
Trusted by 1,000,000+ developers from startups to Fortune 500 companies