What do you want to automate
with Database and Peach?
Prompt, edit and deploy AI agents that connect to Database, Peach and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Start for free — no credit card required
Watch a demo
Popular Database and Peach Actions#
Send Template Message with the Peach API
Send a predefined message to a contact within the Peach app. See the documentation
Integrate the Database API with the Peach API
Setup the Database API trigger to run a workflow which integrates with the Peach API. Pipedream's integration platform allows you to integrate Database and Peach remarkably fast. Free for developers.
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#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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;
},
};
Connect Peach#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
peach: {
type: "app",
app: "peach",
}
},
async run({steps, $}) {
const data = {
"name": `John Smith`,
"phone_number": `+919876543210`,
"email": `john.smith@example.com`,
}
return await axios($, {
method: "post",
url: `https://app.trypeach.io/api/v1/contacts`,
headers: {
"Authorization": `${this.peach.$auth.api_token}`,
},
data,
})
},
})
Start for free — no credit card required
Watch a demo
Trusted by 1,000,000+ developers from startups to Fortune 500 companies