Here’s a list of SQL databases that Ecto currently has adapters for in 2020, including AWS Redshift, AWS DynamoDB, MongoDB and others.
| Database | Supported | Notes |
|---|---|---|
| PostgreSQL 9.0+ | Out of the box | Uses MyXQL |
| MySQL 5.5+ | Out of the box | Uses Postgrex |
| MariaDB 10.3+ | Out of the box | With MySQL |
| SQLServer (TDS 7.3,7.4) | Out of the box | Uses Tds |
| AWS Redshift | Yes | None |
| AWS DynamoDB | Beta | Work in progress |
| MongoDB | Yes | Uses mongodb |
| Oracle | Yes | Uses Jamdb.Oracle |
| Cassandra | Yes | Uses cassandrex |
| Neo4j | Yes | Uses bolt_sips |
| ClickHouse | Yes | Uses clickhousex |
| Greenplum | Yes | With PostgreSQL |
| CDH Impala | No | |
| Apache Hive | No | |
| Google BigQuery | No | |
| Snowflake | No | |
| AWS Aurora | Yes | With PostgreSQL or MySQL |
| AWS RDS | Yes | With PostgreSQL, MySQL, or SQLServer |
| Google Cloud SQL | Yes | With PostgreSQL |