How to separate dev and prod databases?

System Information
  • Strapi Version: 4.6.0
  • Operating System:
  • Database:
  • Node Version: v16.19.
  • NPM Version:
  • Yarn Version:


I’m using latest version strapi as of today.
Default database settings config/database.js looks like this.

const path = require('path');

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

While keep above settings for dev environment, I’d like to add postgresql database settings for production?
Where should I look docs for this?