Database server requirements

MariaDB or MySQL

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

Required configuration

Drupal 10, 11, and 12 requires that the pg_trgm extension is enabled.

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.

See also #2564307: [meta] Remaining Drupal 10/11 PostgreSQL issues.

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

SQLite

Required configuration

Drupal 10 requires that the json1 extension is enabled.

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, and maybe in Drupal core, see #3457540: [meta] Add database driver for MongoDB to Core as experimental.