> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/connectors/mariadb-connector-python.md).

# 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)).

{% hint style="info" %}
**Version 2.0 is currently a Release Candidate (RC); version 1.1 is the latest stable (GA) release.** Because 2.0 is not yet GA, install it with the `--pre` flag (for example `pip install --pre mariadb`); a plain `pip install mariadb` installs the latest stable release (1.1). See the [Installation](/docs/connectors/mariadb-connector-python/install.md) page for details. Do not use non-stable (non-GA) releases in production.
{% endhint %}

#### Contents

## Contents:

* [Installation](/docs/connectors/mariadb-connector-python/install.md)
  * [Prerequisites](/docs/connectors/mariadb-connector-python/install.md#prerequisites)
  * [Installation Options](/docs/connectors/mariadb-connector-python/install.md#installation-options)
  * [Installation from Source](/docs/connectors/mariadb-connector-python/install.md#installation-from-source)
  * [Test suite](/docs/connectors/mariadb-connector-python/install.md#test-suite)
* [Basic usage](/docs/connectors/mariadb-connector-python/usage.md)
  * [Connecting](/docs/connectors/mariadb-connector-python/usage.md#connecting)
  * [Passing parameters to SQL statements](/docs/connectors/mariadb-connector-python/usage.md#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](/docs/connectors/mariadb-connector-python/pooling.md)
  * [Synchronous Connection Pool](/docs/connectors/mariadb-connector-python/pooling.md#synchronous-connection-pool)
  * [Asynchronous Connection Pool](/docs/connectors/mariadb-connector-python/pooling.md#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](/docs/connectors/mariadb-connector-python/api.md)
  * [The MariaDB Connector/Python module](/docs/connectors/mariadb-connector-python/api/module.md)
  * [The connection class](/docs/connectors/mariadb-connector-python/api/connection.md)
  * [The cursor class](/docs/connectors/mariadb-connector-python/api/cursor.md)
  * [The ConnectionPool class](/docs/connectors/mariadb-connector-python/api/pool.md)
  * [Constants](/docs/connectors/mariadb-connector-python/api/constants.md)
* [License](/docs/connectors/mariadb-connector-python/license.md)
  * [MariaDB Connector/Python](/docs/connectors/mariadb-connector-python/license.md#mariadb-connector-python)
  * [MariaDB Connector/Python documentation](/docs/connectors/mariadb-connector-python/license.md#mariadb-connector-python-documentation)
* [Bug reports](/docs/connectors/mariadb-connector-python/bugs.md)
  * [How to report a bug?](/docs/connectors/mariadb-connector-python/bugs.md#how-to-report-a-bug)
* [MariaDB Connector/Python FAQ](/docs/connectors/mariadb-connector-python/faq.md)
  * [Installation](/docs/connectors/mariadb-connector-python/faq.md#installation)
  * [Connecting](/docs/connectors/mariadb-connector-python/faq.md#connecting)
  * [General](/docs/connectors/mariadb-connector-python/faq.md#general)
  * [Transactions](/docs/connectors/mariadb-connector-python/faq.md#transactions)

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