SQL Databases
-
Prerequisites: Obtain the database host, port, and credentials (username and password) with read access to the databases you want to query.
-
Configuring Playbooks: Go to Integrations > SQL Databases in the Playbooks dashboard. Enter your database connection details.
-
Testing the Integration: Create a playbook that includes a step to run a simple SELECT query against your database and verify the results are fetched correctly.
Connection String URI for different databases:
| Database | Connection String URI format |
|---|---|
| MySQL | mysql+pymysql://user:pass@localhost:3306/db |
| PostgreSQL | postgresql+psycopg2://user:pass@localhost:5432/db |
| Trino | trino://user:pass@host:port/catalog/schema |
Updated about 2 months ago