---

name: sql-connectors description: "Guides awswrangler Redshift, Data API, and direct MySQL, PostgreSQL, SQL Server, and Oracle connector workflows." disable-model-invocation: true metadata: disco-role: operating license: Apache 2.0

SQL Connectors

Use this sub-skill when the user is working with relational database connections or SQL copy/unload flows.

Typical triggers:

• "connect to Redshift"
• "read SQL from MySQL or PostgreSQL"
• "write a pandas DataFrame to SQL Server"
• "use the RDS Data API"
• "use Redshift COPY or UNLOAD"
• "open an Oracle connection"

Read references/api-reference.md for the connector families and their key methods. Read references/workflows.md for choosing the right connection path and moving data in or out. Read references/troubleshooting.md for missing driver, secret, timeout, SSL, and permission failures. Use ../../scripts/check_runtime.py from the root skill to confirm the required connector extras before attempting a live database workflow.

Include here

• Redshift direct connector workflows, including connect_temp, copy, and unload.
• Redshift and RDS Data API workflows.
• MySQL, PostgreSQL, SQL Server, and Oracle direct connectors.
• read_sql_query, read_sql_table, and to_sql for the supported database families.

Exclude or route elsewhere

• S3 file staging, dataset reads and writes, and Delta Lake go to s3-lakehouse.
• Glue Catalog, Athena, Data Quality, and Clean Rooms go to catalog-and-query.
• Runtime, extras, and Ray/Modin mode questions go to runtime-and-config.
• DynamoDB, Timestream, OpenSearch, Neptune, QuickSight, CloudWatch, EMR, STS, Secrets Manager, and Chime go to service-integrations.

Common user outcomes

A future agent should be able to:

• choose the correct connector family,
• open a connection with the right secret, catalog, or database arguments,
• run parameterized SQL,
• write pandas data back to a table,
• and decide when Redshift COPY/UNLOAD or Data API is the better fit.

Shared references

• references/api-reference.md
• references/workflows.md
• references/troubleshooting.md