SQL Database Integration in Node.js

From the Express.js REST API cheat sheet · Database Integration · verified Jul 2026

SQL Database Integration

Connect Express to PostgreSQL/MySQL using query builders or ORMs

javascript

const mysql = require('mysql2/promise');

// Database connection
const pool = mysql.createPool({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydb',
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0
});

// Query examples
const getUsers = async () => {
  const [rows] = await pool.execute('SELECT * FROM users WHERE active = ?', [1]);
  return rows;
};

💡 Use Prisma or Sequelize for type-safe database access

📌 Knex.js for flexible SQL query building

⚡ Use prepared statements to prevent SQL injection

⚠️ Always use parameterized queries, never concatenate SQL

🟢 Essential - Choose ORM based on project needs

🔗 Related: pg for PostgreSQL, mysql2 for MySQL

More Node.js tasks

MongoDB with Mongoose

Back to the full Express.js REST API cheat sheet