ExploreConnectDocsChangelogPricingTemplatesPartnersString
Sign in
Sign up
← PostgreSQL

Execute SQL Query with PostgreSQL API

Pipedream makes it easy to connect APIs for PostgreSQL and 2,800+ other apps remarkably fast.

Trigger workflow on
HTTP requests, schedules and app events
Next, do this
Execute SQL Query with the PostgreSQL API
No credit card required
Intro to Pipedream
▶
Watch us build a workflow
Watch us build a workflow
8 min
Watch now ➜

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

Developers ♥ Pipedream

Getting Started

Create a workflow to Execute SQL Query with the PostgreSQL API. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Configure the Execute SQL Query action
    1. Connect your PostgreSQL account
    2. Configure PostgreSQL Query
  2. Select a trigger to run your workflow on HTTP requests, schedules or app events
  3. Deploy the workflow
  4. Send a test event to validate your setup
  5. Turn on the trigger

Integrations

Execute Custom Query with PostgreSQL API on New Requests (Payload Only) from HTTP / Webhook API
HTTP / Webhook + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Item in Feed from RSS API
RSS + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Message from Discord API
Discord + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Message In Channels from Slack API
Slack + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Message in Channel from Discord Bot API
Discord Bot + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Submission from Typeform API
Typeform + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Custom Events from Zoom API
Zoom + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Submission (Instant) from Jotform API
Jotform + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Custom Webhook Events from Stripe API
Stripe + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Scheduled Tasks from Pipedream API
Pipedream + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on npm Download Counts from npm API
npm + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New or Updated Event (Instant) from Google Calendar API
Google Calendar + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Query Results from Snowflake API
Snowflake + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Activity Created Event from Strava API
Strava + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Account Created from Zoom Admin API
Zoom Admin + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New or Modified File or Folder from Dropbox API
Dropbox + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New or Removed Documents in a Collection from Fauna API
Fauna + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New or changed appointments from SuperSaaS API
SuperSaaS + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Invitee Cancelled (Instant) from Calendly API
Calendly (Key) + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Deploy Failure (Instant) from Netlify API
Netlify + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Stories for a Tag from Dev.to API
Dev.to + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Weather for ZIP Code from HERE API
HERE + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Action Created from iAuditor by SafetyCulture API
iAuditor by SafetyCulture + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Asset Uploaded from Shotstack API
Shotstack + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Assignment Done from Google Classroom API
Google Classroom + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Balance Updated from Mocean API API
Mocean API + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on BigQuery - New Row from Google Cloud API
Google Cloud + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Booking Contact Updated from Slottable API
Slottable + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Box Changed Stage (Instant) from Streak API
Streak + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Budget Snapshot Event (Instant) from Procore API
Procore + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Cancelled Booking with Customer from Appointedd API
Appointedd + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Card Due Date Reminder from Trello API
Trello + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Card Expired from Pipefy API
Pipefy + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Catalog Item Updated from Square API
Square + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Category Overspent from You Need a Budget API
You Need a Budget + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Changed Collection Item (Instant) from Webflow API
Webflow + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Changes to Specific Files from Google Drive API
Google Drive + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Channel Updates (Instant) from Telegram Bot API
Telegram + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Chat Status Updated from HelpCrunch API
HelpCrunch + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Client Updated from RiskAdvisor API
RiskAdvisor + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Completed Task from Todoist API
Todoist + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Contact Created from Apollo.io API
Apollo.io + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Contact Created from Mailjet API
Mailjet + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Contact Status Updated from Ambivo API
Ambivo + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Contact Unsubscribed from Vision6 API
Vision6 + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Contact Updated from HubSpot API
HubSpot + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Customer Card Expired (Instant) from Chargebee API
Chargebee + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Customer Created (Instant) from Customer Fields API
Customer Fields + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Customer Created from Plain API
Plain + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Customer Updated (Instant) from Loyverse API
Loyverse + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Daily schedule from Schedule API
Schedule + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Dataset Refresh Completed from Microsoft Power BI API
Microsoft Power BI + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Document Completed from Crove API
Crove + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Document Creation Failed (Instant) from PandaDoc API
PandaDoc + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Document Export Failed from Cloudpress API
Cloudpress + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Edit Event (Instant) from WaiverFile API
WaiverFile + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Envelope Sent or Complete from Docusign API
Docusign + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Envelope Sent or Complete from Docusign Developer API
Docusign Developer + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Event Created from Team Up API
Team Up + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Events (Instant) from Twilio SendGrid API
Twilio SendGrid + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Exchange Rate Updated from CurrencyScoop API
CurrencyScoop + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on File Deleted from DigitalOcean Spaces API
DigitalOcean Spaces + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Form Created from 123FormBuilder API
123FormBuilder + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Incident Updated (Instant) from Statuspage API
Statuspage + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Inventory Updated from Lightspeed Retail POS API
Lightspeed Retail POS + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Inventory Updated from Sellercloud API
Sellercloud + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Issue Created (Instant) from Linear (API key) API
Linear (API key) + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Issue Created (Instant) from Linear (OAuth) API
Linear (OAuth) + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Issue Created from PractiTest API
PractiTest + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Issued Credential from Accredible API
Accredible + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Item Position Changed from Miro Developer App API
Miro Developer App + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Job Finished (Instant) from Cloud Convert API
Cloud Convert + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Job Run Completed (Instant) from dbt Cloud API
dbt Cloud + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Lead Details Updated from CINC API
CINC + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Link Clicked from Mailchimp API
Mailchimp + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Member Created from Patreon API
Patreon + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Message Received from LoopMessage API
LoopMessage + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on Missed Inbound Call (Instant) from Ringcentral API
RingCentral + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New 1-on-1 Created from 15Five API
15Five + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Abandoned Cart from Shopify (Developer App) API
Shopify + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Account Created from Recurly API
Recurly + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Account Data Change from 46elks API
46elks + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Account Event (Instant) from Overledger API
Overledger + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Account from Amilia API
Amilia + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Action (Instant) from Stormboard API
Stormboard + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Action (Instant) from Ticket Tailor API
Ticket Tailor + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Action Created from Hive API
Hive + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Action Created from Pushcut API
Pushcut + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Action Performed from PostHog API
PostHog + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Activity (Instant) from lemlist API
lemlist + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Activity (Instant) from timeBuzzer API
timeBuzzer + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Activity (Instant) from Zenkit API
Zenkit + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Activity from ForceManager API
ForceManager + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Activity from Satuit API
Satuit + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Activity from Workamajig API
Workamajig + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Activity Status Change from Teamgate API
Teamgate + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Address Created from Tidy API
Tidy + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Admin Activity By Application Name from Google Workspace Admin API
Google Workspace Admin + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Affiliate Campaign from Relavate API
Relavate + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New Agent Reply from SupportBee API
SupportBee + PostgreSQL
 
Try it

Details

This is a pre-built, source-available component from Pipedream's GitHub repo. The component is developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Execute SQL Query on PostgreSQL
Description:Execute a custom PostgreSQL query. See [our docs](https://pipedream.com/docs/databases/working-with-sql) to learn more about working with SQL in Pipedream.
Version:3.0.5
Key:postgresql-execute-custom-query

Code

import postgresql from "../../postgresql.app.mjs"; export default { name: "Execute SQL Query", key: "postgresql-execute-custom-query", description: "Execute a custom PostgreSQL query. See [our docs](https://pipedream.com/docs/databases/working-with-sql) to learn more about working with SQL in Pipedream.", version: "3.0.5", annotations: { destructiveHint: false, openWorldHint: true, readOnlyHint: false, }, type: "action", props: { postgresql, // eslint-disable-next-line pipedream/props-description sql: { type: "sql", auth: { app: "postgresql", }, label: "PostgreSQL Query", }, }, async run({ $ }) { const args = this.postgresql.executeQueryAdapter(this.sql); const data = await this.postgresql.executeQuery(args); $.export("$summary", `Returned ${data.length} ${data.length === 1 ? "row" : "rows"}`); return data; }, };

Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.
LabelPropTypeDescription
PostgreSQLpostgresqlappThis component uses the PostgreSQL app.
PostgreSQL Querysqlsql

Authentication

PostgreSQL uses API keys for authentication. When you connect your PostgreSQL account, Pipedream securely stores the keys so you can easily authenticate to PostgreSQL APIs in both code and no-code steps.

Connecting to Restricted Databases

Either enable the shared static IP for this account below, or configure a VPC to deploy any workflow in your workspace to a private network with a dedicated static IP. Learn more in our docs

SSL Setup

Configure SSL on your PostgreSQL database by providing the CA (Certificate Authority), and choosing between Full Verification, Verify Certificate Authority (CA), or Skip Verification. Skipping verification is not recommended as this has serious security implications

About PostgreSQL

PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

More Ways to Use PostgreSQL

Triggers

New Column from the PostgreSQL API

Emit new event when a new column is added to a table. See the documentation

 
Try it
New or Updated Row from the PostgreSQL API

Emit new event when a row is added or modified. See the documentation

 
Try it
New Row from the PostgreSQL API

Emit new event when a new row is added to a table. See the documentation

 
Try it
New Row Custom Query from the PostgreSQL API

Emit new event when new rows are returned from a custom query that you provide. See the documentation

 
Try it
New Table from the PostgreSQL API

Emit new event when a new table is added to the database. See the documentation

 
Try it

Actions

Delete Row(s) with the PostgreSQL API

Deletes a row or rows from a table. See the documentation

 
Try it
Find Row with the PostgreSQL API

Finds a row in a table via a lookup column. See the documentation

 
Try it
Find Row With Custom Query with the PostgreSQL API

Finds a row in a table via a custom query. See the documentation

 
Try it
Insert Row with the PostgreSQL API

Adds a new row. See the documentation

 
Try it
Query SQL Database with the PostgreSQL API

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

 
Try it
Update Row with the PostgreSQL API

Updates an existing row. See the documentation

 
Try it
Upsert Row with the PostgreSQL API

Adds a new row or updates an existing row. See the documentation

 
Try it

Explore Other Apps

1
-
24
of
2,800+
apps by most popular

Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Anthropic (Claude)
Anthropic (Claude)
AI research and products that put safety at the frontier. Introducing Claude, a next-generation AI assistant for your tasks, no matter the scale.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Telegram
Telegram
Telegram, is a cloud-based, cross-platform, encrypted instant messaging (IM) service.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
Shopify
Shopify
Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
Premium
AWS
AWS
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Premium
Twilio SendGrid
Twilio SendGrid
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Premium
Klaviyo
Klaviyo
Email Marketing and SMS Marketing Platform
Premium
Zendesk
Zendesk
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
Premium
ServiceNow
ServiceNow
The smarter way to workflow
Slack
Slack
Slack is a channel-based messaging platform. With Slack, people can work together more effectively, connect all their software tools and services, and find the information they need to do their best work — all within a secure, enterprise-grade environment.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.
abcdefghijklmnopqrstuvwxyz#
Pipedream, Inc. — San Francisco, CA
AboutTwitterDocsCommunityTermsPrivacyTry String