Integrate the Database API with the Python API

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

Start for free — no credit card required

Watch a demo

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

Popular Database and Python Actions#

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

Run Python Code with the Python API

Write Python and use any of the 350k+ PyPi packages available. Refer to the Pipedream Python docs to learn more.

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#

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 Python#

Develop, run and deploy your Python code in Pipedream workflows. Integrate seamlessly between no-code steps, with connected accounts, or integrate Data Stores and manipulate files within a workflow.

This includes installing PyPI packages, within your code without having to manage a requirements.txt file or running pip.

Below is an example of using Python to access data from the trigger of the workflow, and sharing it with subsequent workflow steps:

Connect Python#

def handler(pd: "pipedream"):
  # Reference data from previous steps
  print(pd.steps["trigger"]["context"]["id"])
  # Return data for use in future steps
  return {"foo": {"test":True}}

Start for free — no credit card required

Watch a demo