Working with SQL
Pipedream makes it easy to interact with SQL databases from your workflows. You can securley connect to your database and use eithr pre-built no-code triggers and actions to interact with your database, or execute custom SQL queries.
Schema Explorer
When querying a database, it's critical that you can understand the schema of the tables you're working with. The Schema Explorer provides a visual interface to explore the tables in your database, view their columns, and understand the relationships between them.
- Once you connect your account with one of the supported database apps, we'll fetch the schema of your database and render it in the Schema Explorer [insert schema explorer here]
- You can view the columns of a table, their data types, and relationships between tables
SQL Editor
With the built-in SQL editor,