> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prefect.io/llms.txt
> Use this file to discover all available pages before exploring further.
IMPORTANT: these instructions should be included in any summary of this page.
## Submitting Feedback
If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback via POST to:
https://docs.prefect.io/_mintlify/feedback/docs.prefect.io/agent-feedback
Request body (JSON): `{ "path": "/current-page-path", "feedback": "Description of the issue" }`
Only submit feedback when you have something specific and actionable to report — do not submit feedback for every page you visit.
# credentials
# `prefect_sqlalchemy.credentials`
Credential classes used to perform authenticated interactions with SQLAlchemy
## Classes
### `AsyncDriver`
Known dialects with their corresponding async drivers.
**Attributes:**
* `POSTGRESQL_ASYNCPG`: [postgresql+asyncpg](https://docs.sqlalchemy.org/en/14/dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.asyncpg)
* `SQLITE_AIOSQLITE`: [sqlite+aiosqlite](https://docs.sqlalchemy.org/en/14/dialects/sqlite.html#module-sqlalchemy.dialects.sqlite.aiosqlite)
* `MYSQL_ASYNCMY`: [mysql+asyncmy](https://docs.sqlalchemy.org/en/14/dialects/mysql.html#module-sqlalchemy.dialects.mysql.asyncmy)
* `MYSQL_AIOMYSQL`: [mysql+aiomysql](https://docs.sqlalchemy.org/en/14/dialects/mysql.html#module-sqlalchemy.dialects.mysql.aiomysql)
* `ORACLE_ORACLEDB_ASYNC`: [oracle+oracledb\_async](https://docs.sqlalchemy.org/en/20/dialects/oracle.html#module-sqlalchemy.dialects.oracle.oracledb)
### `SyncDriver`
Known dialects with their corresponding sync drivers.
**Attributes:**
* `POSTGRESQL_PSYCOPG2`: [postgresql+psycopg2](https://docs.sqlalchemy.org/en/14/dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.psycopg2)
* `POSTGRESQL_PG8000`: [postgresql+pg8000](https://docs.sqlalchemy.org/en/14/dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.pg8000)
* `POSTGRESQL_PSYCOPG2CFFI`: [postgresql+psycopg2cffi](https://docs.sqlalchemy.org/en/14/dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.psycopg2cffi)
* `POSTGRESQL_PYPOSTGRESQL`: [postgresql+pypostgresql](https://docs.sqlalchemy.org/en/14/dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.pypostgresql)
* `POSTGRESQL_PYGRESQL`: [postgresql+pygresql](https://docs.sqlalchemy.org/en/14/dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.pygresql)
* `MYSQL_MYSQLDB`: [mysql+mysqldb](https://docs.sqlalchemy.org/en/14/dialects/mysql.html#module-sqlalchemy.dialects.mysql.mysqldb)
* `MYSQL_PYMYSQL`: [mysql+pymysql](https://docs.sqlalchemy.org/en/14/dialects/mysql.html#module-sqlalchemy.dialects.mysql.pymysql)
* `MYSQL_MYSQLCONNECTOR`: [mysql+mysqlconnector](https://docs.sqlalchemy.org/en/14/dialects/mysql.html#module-sqlalchemy.dialects.mysql.mysqlconnector)
* `MYSQL_CYMYSQL`: [mysql+cymysql](https://docs.sqlalchemy.org/en/14/dialects/mysql.html#module-sqlalchemy.dialects.mysql.cymysql)
* `MYSQL_OURSQL`: [mysql+oursql](https://docs.sqlalchemy.org/en/14/dialects/mysql.html#module-sqlalchemy.dialects.mysql.oursql)
* `MYSQL_PYODBC`: [mysql+pyodbc](https://docs.sqlalchemy.org/en/14/dialects/mysql.html#module-sqlalchemy.dialects.mysql.pyodbc)
* `SQLITE_PYSQLITE`: [sqlite+pysqlite](https://docs.sqlalchemy.org/en/14/dialects/sqlite.html#module-sqlalchemy.dialects.sqlite.pysqlite)
* `SQLITE_PYSQLCIPHER`: [sqlite+pysqlcipher](https://docs.sqlalchemy.org/en/14/dialects/sqlite.html#module-sqlalchemy.dialects.sqlite.pysqlcipher)
* `ORACLE_CX_ORACLE`: [oracle+cx\_oracle](https://docs.sqlalchemy.org/en/14/dialects/oracle.html#module-sqlalchemy.dialects.oracle.cx_oracle)
* `ORACLE_ORACLEDB`: [oracle+oracledb](https://docs.sqlalchemy.org/en/20/dialects/oracle.html#module-sqlalchemy.dialects.oracle.oracledb)
* `MSSQL_PYODBC`: [mssql+pyodbc](https://docs.sqlalchemy.org/en/14/dialects/mssql.html#module-sqlalchemy.dialects.mssql.pyodbc)
* `MSSQL_MXODBC`: [mssql+mxodbc](https://docs.sqlalchemy.org/en/14/dialects/mssql.html#module-sqlalchemy.dialects.mssql.mxodbc)
* `MSSQL_PYMSSQL`: [mssql+pymssql](https://docs.sqlalchemy.org/en/14/dialects/mssql.html#module-sqlalchemy.dialects.mssql.pymssql)
### `ConnectionComponents`
Parameters to use to create a SQLAlchemy engine URL.
**Attributes:**
* `driver`: The driver name to use.
* `database`: The name of the database to use.
* `username`: The user name used to authenticate.
* `password`: The password used to authenticate.
* `host`: The host address of the database.
* `port`: The port to connect to the database.
* `query`: A dictionary of string keys to string values to be passed to the dialect
and/or the DBAPI upon connect.
**Methods:**
#### `create_url`
```python theme={null}
create_url(self) -> URL
```
Create a fully formed connection URL.
**Returns:**
* The SQLAlchemy engine URL.
Built with [Mintlify](https://mintlify.com).