## Supported projects

The following projects can be used to implement Python applications using the YugabyteDB YSQL API.

| Project | Documentation and Guides | Latest Driver Version | Supported YugabyteDB Version |
| ------- | ------------------------ | ------------------------ | ---------------------|
| Yugabyte Psycopg2 Smart Driver [Recommended] | [Documentation](yugabyte-psycopg2/) <br /> [Reference](yugabyte-psycopg2-reference/)| 2.9.3 | 2.8 and above |
| PostgreSQL Psycopg2 Driver | [Documentation](postgres-psycopg2/) <br /> [Reference](postgres-psycopg2-reference/) | 2.9.3 | 2.8 and above |
| PostgreSQL Psycopg3 Driver | [Documentation](postgres-psycopg3/) <br /> [Reference](postgres-psycopg3-reference/) | 3.2.9 | 2.20 and above |
| aiopg | [Documentation](aiopg/) | 1.4 | 2.8 and above |
| YugabyteDB Python Driver for YCQL | [Documentation](ycql/) | [3.25.0](https://github.com/yugabyte/cassandra-python-driver/tree/master) | |

| Project | Documentation and Guides | Example Apps |
| ------- | ------------------------ | ------------ |
| SQLAlchemy | [Documentation](sqlalchemy/) <br/> [Hello World](../orms/python/ysql-sqlalchemy/) | [SQLAlchemy ORM App](https://github.com/YugabyteDB-Samples/orm-examples/tree/master/python/sqlalchemy)
| Django | [Documentation](django/) <br/> [Hello World](../orms/python/ysql-django/) | [Django ORM App](https://github.com/YugabyteDB-Samples/orm-examples/tree/master/python/django) |

Learn how to establish a connection to a YugabyteDB database and begin basic CRUD operations by referring to [Connect an app](yugabyte-psycopg2/) or [Use an ORM](sqlalchemy/).

## Prerequisites

To develop Python applications for YugabyteDB, you need the following:

- **Python**

  Ensure your system has Python3 installed. To check the version of Python installed, use the following command:

  ```sh
  python -V
  ```

  If not already installed, download and install it from the [Python Downloads](https://www.python.org/downloads/) page.

- **YugabyteDB cluster**

  - Create a free cluster on YugabyteDB Aeon. Refer to [Use a cloud cluster](/stable/quick-start-yugabytedb-managed/). Note that YugabyteDB Aeon requires SSL.
  - Alternatively, set up a standalone YugabyteDB cluster by following the steps in [Install YugabyteDB](/stable/quick-start/macos/).

## Next step

[Connect an app](yugabyte-psycopg2/)