# Amazon Aurora DSQL cluster connectivity tools
<a name="aws-sdks"></a>

 Aurora DSQL is compatible with many third-party database drivers and ORM libraries. AWS provides two types of tools to simplify working with Aurora DSQL: 
+ **[Connectors](https://docs.aws.amazon.com/aurora-dsql/latest/userguide/SECTION_connectors.html)** – Authentication plugins that extend database drivers to handle IAM token generation automatically. Use connectors when working directly with database drivers.
+ **Adapters and dialects** – Extensions for specific ORM frameworks that provide IAM authentication and improved Aurora DSQL compatibility. Use adapters when working with a supported ORM framework.

## Aurora DSQL adapters and dialects
<a name="aurora-dsql-adapters"></a>

The following table shows the available adapters and dialects for Aurora DSQL.


| Programming language | ORM/Framework | Repository link | 
| --- |--- |--- |
| Java | Hibernate | [https://github.com/awslabs/aurora-dsql-orms/tree/main/java/hibernate](https://github.com/awslabs/aurora-dsql-orms/tree/main/java/hibernate) | 
| Python | Django | [https://github.com/awslabs/aurora-dsql-orms/tree/main/python/django](https://github.com/awslabs/aurora-dsql-orms/tree/main/python/django) | 
| Python | SQLAlchemy | [https://github.com/awslabs/aurora-dsql-orms/tree/main/python/sqlalchemy](https://github.com/awslabs/aurora-dsql-orms/tree/main/python/sqlalchemy) | 
| Python | Tortoise ORM | [https://github.com/awslabs/aurora-dsql-orms/tree/main/python/tortoise-orm](https://github.com/awslabs/aurora-dsql-orms/tree/main/python/tortoise-orm) | 

## Database driver samples
<a name="database-drivers"></a>

The following table shows sample code for connecting to Aurora DSQL using third-party database drivers.


| Programming language | Driver | Sample repository link | 
| --- |--- |--- |
| C\$1\$1 | libpq | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/cpp/libpq](https://github.com/aws-samples/aurora-dsql-samples/tree/main/cpp/libpq) | 
| C\$1 (.NET) | Npgsql | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/dotnet/npgsql](https://github.com/aws-samples/aurora-dsql-samples/tree/main/dotnet/npgsql) | 
| Go | pgx | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/go/pgx](https://github.com/aws-samples/aurora-dsql-samples/tree/main/go/pgx) | 
| Java | HikariCP \$1 pgJDBC | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/java/pgjdbc](https://github.com/aws-samples/aurora-dsql-samples/tree/main/java/pgjdbc) | 
| JavaScript | node-postgres (AWS Lambda) | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/lambda](https://github.com/aws-samples/aurora-dsql-samples/tree/main/lambda) | 
| JavaScript | node-postgres | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/javascript/node-postgres](https://github.com/aws-samples/aurora-dsql-samples/tree/main/javascript/node-postgres) | 
| JavaScript | Postgres.js | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/javascript/postgres-js](https://github.com/aws-samples/aurora-dsql-samples/tree/main/javascript/postgres-js) | 
| Python | asyncpg | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/python/asyncpg](https://github.com/aws-samples/aurora-dsql-samples/tree/main/python/asyncpg) | 
| Python | Psycopg | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/python/psycopg](https://github.com/aws-samples/aurora-dsql-samples/tree/main/python/psycopg) | 
| Python | Psycopg2 | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/python/psycopg2](https://github.com/aws-samples/aurora-dsql-samples/tree/main/python/psycopg2) | 
| Ruby | pg | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/ruby/ruby-pg](https://github.com/aws-samples/aurora-dsql-samples/tree/main/ruby/ruby-pg) | 
| Rust | SQLx | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/rust/sqlx](https://github.com/aws-samples/aurora-dsql-samples/tree/main/rust/sqlx) | 

## ORM and framework samples
<a name="orm-libraries"></a>

The following table shows sample code for using third-party ORM libraries and frameworks with Aurora DSQL.


| Programming language | ORM/Framework | Sample repository link | 
| --- |--- |--- |
| Java | Hibernate | [https://github.com/awslabs/aurora-dsql-orms/tree/main/java/hibernate/examples/pet-clinic-app](https://github.com/awslabs/aurora-dsql-orms/tree/main/java/hibernate/examples/pet-clinic-app) | 
| Java | Liquibase | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/java/liquibase](https://github.com/aws-samples/aurora-dsql-samples/tree/main/java/liquibase) | 
| Java | Spring Boot | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/java/spring\$1boot](https://github.com/aws-samples/aurora-dsql-samples/tree/main/java/spring_boot) | 
| Python | Django | [https://github.com/awslabs/aurora-dsql-orms/tree/main/python/django/examples/pet-clinic-app](https://github.com/awslabs/aurora-dsql-orms/tree/main/python/django/examples/pet-clinic-app) | 
| Python | SQLAlchemy | [https://github.com/awslabs/aurora-dsql-orms/tree/main/python/sqlalchemy/examples/pet-clinic-app](https://github.com/awslabs/aurora-dsql-orms/tree/main/python/sqlalchemy/examples/pet-clinic-app) | 
| Python | Tortoise ORM | [https://github.com/awslabs/aurora-dsql-orms/tree/main/python/tortoise-orm/example](https://github.com/awslabs/aurora-dsql-orms/tree/main/python/tortoise-orm/example) | 
| Ruby | Rails | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/ruby/rails](https://github.com/aws-samples/aurora-dsql-samples/tree/main/ruby/rails) | 
| TypeScript | Prisma | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/typescript/prisma](https://github.com/aws-samples/aurora-dsql-samples/tree/main/typescript/prisma) | 
| TypeScript | Sequelize | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/typescript/sequelize](https://github.com/aws-samples/aurora-dsql-samples/tree/main/typescript/sequelize) | 
| TypeScript | TypeORM | [https://github.com/aws-samples/aurora-dsql-samples/tree/main/typescript/type-orm](https://github.com/aws-samples/aurora-dsql-samples/tree/main/typescript/type-orm) |