SQLite Installation

SQLite is the default (Quick Start) and recommended database to quickly create an app locally.

Install SQLite using starter

Use one of the following commands:

This will create a new project and launch it in the browser.

💡 TIP

The Quick Start Guide is a complete step-by-step tutorial.

Install SQLite manually

In terminal, run the following command:

Add the following to your ./config/database.js file:

module.exports = ({ env }) => ({
  connection: {
    client: 'sqlite',
    connection: {
      filename: path.join(__dirname, '..', env('DATABASE_FILENAME', '.tmp/data.db')),
    },
    useNullAsDefault: true,
  },
});

Other SQL Databases (PostgreSQL, MySQL)

Refer to the configuration section for all supported options to setup Strapi with your SQL database.

💡 TIP

Most cloud service providers offer a managed SQL database service, which is a hassle-free way to get your database up and running. To get up and running locally, you might want to try using a Docker container.