PostgreSQL + Slack

PostgreSQL + Slack integrations

Get Slack messages for new custom query matches on PostgreSQL

Searching your database with the same query over and over can get quickly get tiresome, and even more so if you have to provide updates to the team about it. If you set up this Zap, however, both those issues will be taken care of for you automatically. After it's active, any new row found to match your custom query on PostgreSQL will automatically result in a message being sent to the Slack channel of your choice, containing all the information you need to stay on top of new items without missing a beat.

When this happens...
New Row (Custom Query)Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.
TriggerPolling
automatically do this!
Send Channel MessageTriggers when a new message is posted to a specific #channel you choose.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with PostgreSQL and Slack

Discover other triggers and actions you can use with PostgreSQL and Slack

- Table/View
  Required
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table/View
  Required
- Primary_key
  Required
- Order_by
  Required
- Trigger_column
Trigger
Polling
Try It
- Table
  Required
- ID Column
  Required
Action
Write
- Query
  Required
Action
Search

- Trigger for Bot Messages?
- Optimized data
Trigger
Instant
Try It
- Channel
  Required
- Trigger for Bot Messages?
- Optimized data
Trigger
Instant
Try It

- Channel
- User Name
- Shared
Trigger
Instant
Try It
- Search Query
  Required
- Optimized data
Trigger
Polling
Try It
- Channel ID
- Reaction
- Member ID
- Message Author ID
Trigger
Instant
Try It
- Zap Identifier
- Access type
Trigger
Instant
Try It
New User
Triggers when a new Slack user is created / first joins your org.
Trigger
Instant
Try It
- Text
  Required
- Remind when?
  Required
- Remind who?
Action
Write
- Conversation ID
  Required
- Scheduled As
  Required
- Scheduled Message ID
  Required
Action
Write
- Channel
  Required
- Add Zapier app to channel automatically?
- Message Text
  Required
- Send as a bot?
- Bot Name
- Bot Icon
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- File
- Thread
- Send Channel Message?
- Zap_id
Action
Write
- Allowed_delete_copy
- Conversation ID
  Required
- Message TS (ID)
  Required
- Posted By
Action
Write
- Canvas ID
  Required
- Operation
  Required
Action
Write
- Channel Name
  Required
Action
Write
- Status_copy
- Approval request message
  Required
- Send message as
  Required
- Approval type
  Required
- Zap_id
- Include a link to this Zap?
- Approve button URL
- Approve button label
- Add decline button
- Add details button
- Require confirmation
Action
Write
- First Name
- Last Name
- Title
- Email
- Display Name
- User
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
Get Message by Timestamp
This action retrieves a specific message from a conversation history in Slack using the message's timestamp.
Action
Write
Retrieve Thread Messages
This action retrieves all the messages sent to a specific thread in a selected channel.
Action
Write
Create Private Channel
This action creates a private channel in Slack.
Action
Write
- Conversation ID
  Required
Action
Search
- Conversation ID
  Required
- Message ID (ts)
  Required
Action
Search
- Conversation ID
  Required
- Message TS (ID)
  Required
Action
Search
- Email
  Required
- Return Raw Results?
Action
Search
- Full Name
  Required
- Return Raw Results?
Action
Search

- Table/View
  Required
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search
- Query
  Required
Action
Search
New Channel
Triggers when a new #channel is created.
Trigger
Instant
Try It
- Include_alias
Trigger
Instant
Try It
- Username
- Highlight Word
- Trigger for Bot Messages?
- Only Public Channels?
Trigger
Instant
Try It
- Channel
  Required
Trigger
Instant
Try It
- Channel
  Required
- Trigger for Bot Messages?
Trigger
Instant
Try It
New Saved Message
Triggers when you save a message.
Trigger
Instant
Try It
- Channel
  Required
- Message
  Required
- Reaction
  Required
Action
Write
- Conversation ID
  Required
Action
Write
- Channel
  Required
- Users
  Required
Action
Write
- Title
- Content
- Channel ID
Action
Write
- Send Multi Message
- Message Text
  Required
- Send as a bot?
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap_id
Action
Write
- Allowed_edit_copy
- Conversation ID
  Required
- Message TS (ID)
  Required
- Posted By
- Content Type
- Reply Broadcast
Action
Write
- Channel
  Required
- Add Zapier app to channel automatically?
- Message Text
  Required
- Send as a bot?
- Bot Name
- Bot Icon
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap_id
- File
- Thread
- Send Channel Message?
Action
Write
- Channel
  Required
- Topic
  Required
- Topic set by
Action
Write
- Status Text
- Status Emoji
- Expiration Time
Action
Write
Remove User from Channel
This action removes a specified user from a specified channel in Slack.
Action
Write
Edit Message
This action updates a specific message sent by the same Authenticated user on Slack. You need to provide the Channel ID, the Timestamp of the message to be edited, and the new text for the message.
Action
Write
Find Public Channel
This action will find a public channel in Slack using either the channel's ID or name.
Action
Write
Delete Message
This action deletes an existing message in a specific channel on Slack. You need to provide the channel ID and the message timestamp as inputs.
Action
Write
- Conversation ID
  Required
Action
Search
- Conversation ID
  Required
- Message ID (ts)
  Required
Action
Search
- Search Query
  Required
- Sort By
- Sort Direction
- Include Bot Messages in Search Results?
Action
Search
- ID
  Required
- Return Raw Results?
Action
Search
- Username
  Required
- Return Raw Results?
Action
Search

About PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn moreLearn moreHelpHelp

Related categories

Databases

Premium

Similar apps

MySQL

Databases

SQL Server

Databases

Amazon Relational Database Services (RDS)

Amazon, Databases

About Slack

Slack is a platform for team communication: everything in one place, instantly searchable, available wherever you go. Offering instant messaging, document sharing and knowledge search for modern teams.

Learn moreLearn moreHelpHelp

Related categories

Team Chat

Similar apps

Chatwork

Team Chat

Microsoft Teams

Microsoft, Team Chat

Twist

Team Chat

PostgreSQL + Slack

PostgreSQL + Slack

Get Slack messages for new custom query matches on PostgreSQL

More things you can do with PostgreSQL and Slack

Related Zap Templates

Related Zap Templates