Database server requirements

MySQL, MariaDB, or equivalent

Drupal 10

• MariaDB 10.3.7+
• MySQL/Percona 5.7.8+

Drupal 11

• MariaDB 10.6+
• MySQL/Percona 8.0+

Required configuration

• InnoDB as the primary storage engine
• The PDO database extension

Drupal itself will generally operate with a default MariaDB/MySQL configuration. A more complex site will likely require configuration changes for the database.

PostgreSQL

Drupal 10

Drupal 10 requires PostgreSQL 12 or higher with the pg_trgm extension enabled.

Drupal 11

Drupal 11 requires PostgreSQL 16 or higher with the pg_trgm extension enabled.

See remaining issues with PostgreSQL support in Drupal here.

Note: Some contributed modules include MySQL-specific code. Issue reports can be filed in the contributed modules' queues when this occurs.

Enabling pg_trgm

To enable, run CREATE EXTENSION pg_trgm; as a user with appropriate permissions (CREATE EXTENSION docs). This must be run while you are connected to the database for your Drupal site. Running it on another database on the same server will not work. Connect to your database by running \connect DBNAME in psql.

SQLite

Drupal 10

Drupal 10 requires SQLite 3.26 or higher with the json1 extension enabled.

Drupal 11

Drupal 11 requires SQLite 3.45 or higher.

Note: Some contributed modules include MySQL-specific code. Issue reports can be filed in the contributed modules' queues when this occurs.

Other database servers

Microsoft SQL Server and MongoDB are supported by contributed modules.