> ## Documentation Index
> Fetch the complete documentation index at: https://docs.drdroid.io/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Databases

1. **Prerequisites**: Obtain the database host, port, and credentials (username and password) with read access to the databases you want to query.

2. **Configuring Playbooks**: Go to Integrations > SQL Databases in the Playbooks dashboard. Enter your database connection details.

3. **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>` |