backend/knexfile.js

import "dotenv/config";
import { config } from "./src/config/index.js";

const base = {
  client: "mysql2",
  connection: {
    host:     process.env.DB_HOST,
    user:     process.env.DB_USER,
    port:     process.env.DB_PORT,
    password: process.env.DB_PASS,
    database: process.env.DB_SCHEMA,
    charset:  "utf8mb4",
    ssl:      config.db.ssl
  },
  migrations: {
    tableName: "knex_migrations",
    directory: "./db/migrations"
  },
  seeds: {
    tableName: "knex_seeds",
    directory: "./db/seeds"
  }
};

export default {
  development: base,
  production:  base
};