What do you want to automate
with n8n.io and Database?
Prompt, edit and deploy AI agents that connect to n8n.io, Database and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Overview of n8n.io#
The n8n.io API provides a platform for automating workflows in a node-based structure that allows for integrations across various services and apps. Leveraging this API within Pipedream enables you to orchestrate complex operations, connect disparate systems, and trigger actions conditionally, transforming and passing data between services without writing extensive code.
Connect n8n.io#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
n8n_io: {
type: "app",
app: "n8n_io",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.n8n_io.$auth.domain}.app.n8n.cloud/api/v1/workflows`,
headers: {
"Accept": `application/json`,
"X-N8N-API-KEY": `${this.n8n_io.$auth.api_key}`,
},
})
},
})
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;
},
};
Trusted by 1,000,000+ developers from startups to Fortune 500 companies