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`
Athena (AWS)	`awsathena+rest://<AWS_ACCESS_KEY_ID>:<AWS_SECRET_ACCESS_KEY>@athena.<aws-region>.amazonaws.com/<database>?s3_staging_dir=<s3_bucket_for_storing_results>`