# Connector/Python

## MariaDB Connector/Python

MariaDB Connector/Python enables python programs to access MariaDB and MySQL databases, using an API which is compliant with the Python DB API 2.0 ([PEP-249](https://peps.python.org/pep-249)).

#### Contents

## Contents:

* [Installation](https://mariadb.com/docs/connectors/mariadb-connector-python/install)
  * [Prerequisites](https://mariadb.com/docs/connectors/install#prerequisites)
  * [Installation Options](https://mariadb.com/docs/connectors/install#installation-options)
  * [Installation from Source](https://mariadb.com/docs/connectors/install#installation-from-source)
  * [Test suite](https://mariadb.com/docs/connectors/install#test-suite)
* [Basic usage](https://mariadb.com/docs/connectors/mariadb-connector-python/usage)
  * [Connecting](https://mariadb.com/docs/connectors/usage#connecting)
  * [Passing parameters to SQL statements](https://mariadb.com/docs/connectors/usage#passing-parameters-to-sql-statements)
* [Async/Await Support](https://github.com/mariadb-corporation/mariadb-docs/blob/main/connectors/mariadb-connector-python/async-usage.md) *(New in 2.0)*
  * [Basic Async Connection](https://github.com/mariadb-corporation/mariadb-docs/blob/main/connectors/mariadb-connector-python/async-usage.md#basic-async-connection)
  * [Async Connection Pools](https://github.com/mariadb-corporation/mariadb-docs/blob/main/connectors/mariadb-connector-python/async-usage.md#async-connection-pools)
  * [FastAPI Integration](https://github.com/mariadb-corporation/mariadb-docs/blob/main/connectors/mariadb-connector-python/async-usage.md#fastapi-integration-example)
* [Connection pooling](https://mariadb.com/docs/connectors/mariadb-connector-python/pooling)
  * [Synchronous Connection Pool](https://mariadb.com/docs/connectors/pooling#synchronous-connection-pool)
  * [Asynchronous Connection Pool](https://mariadb.com/docs/connectors/pooling#asynchronous-connection-pool)
* [Migration Guide](https://github.com/mariadb-corporation/mariadb-docs/blob/main/connectors/mariadb-connector-python/migration-from-1.1-to-2.0.md) *(1.1 to 2.0)*
  * [Breaking Changes](https://github.com/mariadb-corporation/mariadb-docs/blob/main/connectors/mariadb-connector-python/migration-from-1.1-to-2.0.md#breaking-changes)
  * [New Features](https://github.com/mariadb-corporation/mariadb-docs/blob/main/connectors/mariadb-connector-python/migration-from-1.1-to-2.0.md#new-features)
  * [Migration Checklist](https://github.com/mariadb-corporation/mariadb-docs/blob/main/connectors/mariadb-connector-python/migration-from-1.1-to-2.0.md#migration-checklist)
* [API Reference](https://mariadb.com/docs/connectors/mariadb-connector-python/api)
  * [The MariaDB Connector/Python module](https://mariadb.com/docs/connectors/mariadb-connector-python/api/module)
  * [The connection class](https://mariadb.com/docs/connectors/mariadb-connector-python/api/connection)
  * [The cursor class](https://mariadb.com/docs/connectors/mariadb-connector-python/api/cursor)
  * [The ConnectionPool class](https://mariadb.com/docs/connectors/mariadb-connector-python/api/pool)
  * [Constants](https://mariadb.com/docs/connectors/mariadb-connector-python/api/constants)
* [License](https://mariadb.com/docs/connectors/mariadb-connector-python/license)
  * [MariaDB Connector/Python](https://mariadb.com/docs/connectors/license#mariadb-connector-python)
  * [MariaDB Connector/Python documentation](https://mariadb.com/docs/connectors/license#mariadb-connector-python-documentation)
* [Bug reports](https://mariadb.com/docs/connectors/mariadb-connector-python/bugs)
  * [How to report a bug?](https://mariadb.com/docs/connectors/bugs#how-to-report-a-bug)
* [MariaDB Connector/Python FAQ](https://mariadb.com/docs/connectors/mariadb-connector-python/faq)
  * [Installation](https://mariadb.com/docs/connectors/faq#installation)
  * [Connecting](https://mariadb.com/docs/connectors/faq#connecting)
  * [General](https://mariadb.com/docs/connectors/faq#general)
  * [Transactions](https://mariadb.com/docs/connectors/faq#transactions)

{% @marketo/form formId="4316" %}