Database

Query a SQL Database with a built-in SQL editor and Schema Explorer

Integrate the Database API with the Slack API

Setup the Database API trigger to run a workflow which integrates with the Slack API. Pipedream's integration platform allows you to integrate Database and Slack remarkably fast. Free for developers.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Query SQL Database with Database API on New Message In Channels (Instant) from Slack API
Slack + Database
 
Try it
Query SQL Database with Database API on New Channel Created (Instant) from Slack API
Slack + Database
 
Try it
Query SQL Database with Database API on New Direct Message (Instant) from Slack API
Slack + Database
 
Try it
Query SQL Database with Database API on New Interaction Events (Instant) from Slack API
Slack + Database
 
Try it
Query SQL Database with Database API on New Keyword Mention (Instant) from Slack API
Slack + Database
 
Try it
New Message In Channels (Instant) from the Slack API

Emit new event when a new message is posted to one or more channels

 
Try it
New Channel Created (Instant) from the Slack API

Emit new event when a new channel is created.

 
Try it
New Direct Message (Instant) from the Slack API

Emit new event when a message was posted in a direct message channel

 
Try it
New Interaction Events (Instant) from the Slack API

Emit new events on new Slack interactivity events sourced from Block Kit interactive elements, Slash commands, or Shortcuts.

 
Try it
New Keyword Mention (Instant) from the Slack API

Emit new event when a specific keyword is mentioned in a channel

 
Try it
Query SQL Database with the Database API

Execute a SQL Query. See our docs to learn more about working with SQL in Pipedream.

 
Try it
Send Message with the Slack API

Send a message to a user, group, private channel or public channel. See the documentation

 
Try it
Reply to a Message Thread with the Slack API

Send a message as a threaded reply. See postMessage or scheduleMessage docs here

 
Try it
Add Emoji Reaction with the Slack API

Add an emoji reaction to a message. See the documentation

 
Try it
Archive Channel with the Slack API

Archive a channel. See the documentation

 
Try it

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;
  },
};

Overview of Slack

The Pipedream Slack app enables you to build event-driven workflows that interact with the Slack API. Once you authorize the Pipedream app's access to your workspace, you can use Pipedream workflows to perform common Slack actions or write your own code against the Slack API.

The Pipedream Slack app is not a typical app. You don't interact with it directly as a bot, and it doesn't add custom functionality to your workspace out of the box. It makes it easier to automate anything you'd typically use the Slack API for, using Pipedream workflows.

  • Automate posting updates to your team channels
  • Create a bot to answer common questions
  • Integrate with your existing tools and services
  • And much more!

Connect Slack

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    slack: {
      type: "app",
      app: "slack",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://slack.com/api/users.profile.get`,
      headers: {
        Authorization: `Bearer ${this.slack.$auth.oauth_access_token}`,
      },
    })
  },
})
Save Zoom Cloud Recordings to Google Drive and Share on Slack
Save Zoom Cloud Recordings to Google Drive and Share on Slack
Save Zoom Cloud Recordings to Google Drive and Share on Slack.
Run a Pipedream workflow on PagerDuty on-call rotations
Run a Pipedream workflow on PagerDuty on-call rotations
Run common workflows, or any Node.js code you'd like, each time a new user rotates onto an on-call schedule.

Community Posts

Airtable Webhooks with Slack + Pipedream
Airtable Webhooks with Slack + Pipedream
We love Airtable here at Pipedream. But Airtable lacks one killer feature — webhooks. We took advantage of Airtable’s Slack notifications and built a way to send webhooks to an HTTP endpoint every time a record is created or updated in a base. It takes 10 minutes to setup and it’s free.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo