Prevent Sequelize from outputting SQL to the console on execution of query?

Question

I have a function to retrieve a user's profile.

app.get('/api/user/profile', function (request, response)
{
  // Create the default error container
  var error = new Error();

  var User = db.User;
  User.find({
    where: { emailAddress: request.user.username}
  }).then(function(user)
  {
    if(!user)
    {
      error.status = 500; error.message = "ERROR_INVALID_USER"; error.code = 301;
      return next(error);
    }

    // Build the profile from the user object
    profile = {
      "firstName": user.firstName,
      "lastName": user.lastName,
      "emailAddress": user.emailAddress
    }
    response.status(200).send(profile);
  });
});

When the "find" function is called it displays the select statement on the console where the server was started.

Executing (default): SELECT `id`, `firstName`, `lastName`, `emailAddress`, `password`, `passwordRecoveryToken`, `passwordRecoveryTokenExpire`, `createdAt`, `updatedAt` FROM `Users` AS `User` WHERE `User`.`emailAddress` = '[email protected]' LIMIT 1;

Is there a way to get this not to be display? Some flag that I set in a config file somewhere?

I have a question, suppose i dont want password field returned in findOrCreate () method. How can i do this ? — Sunil Sharma
– Sunil Sharma, Commented Dec 11, 2015 at 6:56
@SunilSharma exclude the attribute, search for exclude on this page sequelize.readthedocs.io/en/latest/docs/querying/#attributes — Karel Frajták
– Karel Frajták, Commented Mar 26, 2020 at 18:09

anurupr · Accepted Answer · 2023-03-05 18:23:21Z

541

When you create your Sequelize object, pass false to the logging parameter:

var sequelize = new Sequelize('database', 'username', 'password', {
  
  // disable logging; default: console.log
  logging: false

});

For more options, check the docs.

edited Mar 5, 2023 at 18:23

anurupr

2,3442 gold badges20 silver badges29 bronze badges

answered Mar 8, 2015 at 15:05

victorkt

14.7k9 gold badges56 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

thenetimp Over a year ago

you are better off starting a new question than trying to piggyback a new question on an barely related one.

Tijo Tom Over a year ago

Thank you,this is working however it gives a white space for each query executed. Can you please help me..

Lee Han Kyeol Over a year ago

For now, logging option should be a function.

Garbit Over a year ago

This doesn't seem to have an effect when using sequelize v4. Anyone found a a resolution?

Muhammad Uzair Over a year ago

getting 404 error on given webpage

Eduardo Cuomo · Accepted Answer · 2021-12-10 19:44:35Z

59

If config/config.json file is used then add "logging": false to the config.json in this case under development configuration section.

// file config/config.json
{
  "development": {
    "username": "username",
    "password": "password",
    "database": "db_name",
    "host": "127.0.0.1",
    "dialect": "mysql",
    "logging": false
  },
  "test": {
    // ...
  }
}

edited Dec 10, 2021 at 19:44

Eduardo Cuomo

19.2k7 gold badges121 silver badges98 bronze badges

answered Aug 26, 2016 at 7:27

Supawat Pusavanno

3,46434 silver badges23 bronze badges

Comments

Mostafa Abdellateef · Accepted Answer · 2017-05-09 15:50:29Z

45

As in other answers, you can just set logging:false, but I think better than completely disabling logging, you can just embrace log levels in your app. Sometimes you may want to take a look at the executed queries so it may be better to configure Sequelize to log at level verbose or debug. for example (I'm using winston here as a logging framework but you can use any other framework) :

var sequelize = new Sequelize('database', 'username', 'password', {
  logging: winston.debug
});

This will output SQL statements only if winston log level is set to debug or lower debugging levels. If log level is warn or info for example SQL will not be logged

answered May 9, 2017 at 15:50

Mostafa Abdellateef

1,15514 silver badges12 bronze badges

1 Comment

Muhammad Uzair Over a year ago

Is there a way to bit nicely format SQL queries output on terminal? it looks kinda messy especially with those joins

Ratul Sharker · Accepted Answer · 2019-10-23 10:55:41Z

20

All of these answers are turned off the logging at creation time.

But what if we need to turn off the logging on runtime ?

By runtime i mean after initializing the sequelize object using new Sequelize(.. function.

I peeked into the github source, found a way to turn off logging in runtime.

// Somewhere your code, turn off the logging
sequelize.options.logging = false

// Somewhere your code, turn on the logging
sequelize.options.logging = true

answered Oct 23, 2019 at 10:55

Ratul Sharker

8,0974 gold badges39 silver badges48 bronze badges

1 Comment

Mr.P Over a year ago

very interesting :) this is actually great.. .I will try

Antti A · Accepted Answer · 2025-04-28 08:46:21Z

9

Even if you have logging turned on, you can disable logging on one query by adding 'logging: false' as its option:

  User.findAll({ 
    where: { emailAddress: request.user.username},
    logging: false
  }).then(function(user)....

edited Apr 28 at 8:46

answered Aug 6, 2021 at 13:47

Antti A

5405 silver badges14 bronze badges

1 Comment

Leandro Melo Apr 28 at 8:27

This is what i was looking for but keep in mind that this example is malformed. It should be: User.findAll( { where: { emailAddress: request.user.username}, logging: false}) .then(function(user)....

Vikash Choudhary · Accepted Answer · 2020-03-17 08:01:59Z

Here is my answer:

Brief: I was using typeorm as a ORM library. So, to set the query logging level I have used the following option instead of directly setting the logging option as false.

Solution: File name - ormconfig.ts

{
    'type': process.env.DB_DRIVER,
    'host': process.env.DB_HOST,
    'port': process.env.DB_PORT,
    'username': process.env.DB_USER,
    'password': process.env.DB_PASS,
    'database': process.env.DB_NAME,
    'migrations': [process.env.MIGRATIONS_ENTITIES],
    'synchronize': false,
    'logging': process.env.DB_QUERY_LEVEL,
    'entities': [
        process.env.ORM_ENTITIES
    ],
    'cli': {
        'migrationsDir': 'migrations'
     }
}

And, in the envrionment variable set the DB_QUERY_LEVEL as ["query", "error"].

Result: As a result it will log only when the query has error else it won't.

Ref link: typeorm db query logging doc

Hope this helps! Thanks.

groenhen · Accepted Answer · 2018-02-05 02:55:42Z

3

Based on this discussion, I built this config.json that works perfectly:

{
  "development": {
    "username": "root",
    "password": null,
    "logging" : false,
    "database": "posts_db_dev",
    "host": "127.0.0.1",
    "dialect": "mysql",
    "operatorsAliases": false 
  }
}

edited Feb 5, 2018 at 2:55

groenhen

3,02725 gold badges51 silver badges69 bronze badges

answered Feb 4, 2018 at 21:41

Stephen Hulme

394 bronze badges

Comments

ROOT · Accepted Answer · 2020-03-17 08:34:13Z

2

I solved a lot of issues by using the following code. Issues were : -

Not connecting with database
Database connection Rejection issues
Getting rid of logs in console (specific for this).

const sequelize = new Sequelize("test", "root", "root", {
  host: "127.0.0.1",
  dialect: "mysql",
  port: "8889",
  connectionLimit: 10,
  socketPath: "/Applications/MAMP/tmp/mysql/mysql.sock",
  // It will disable logging
  logging: false
});

edited Mar 17, 2020 at 8:34

ROOT

11.7k5 gold badges35 silver badges49 bronze badges

answered Jan 16, 2020 at 13:38

user12602844

2 Comments

thenetimp Over a year ago

people still use MAMP?

user12602844 Over a year ago

Yes, for development, if you have another best free option, please let me know, thanks

STREET MONEY · Accepted Answer · 2019-10-11 06:17:57Z

I am using Sequelize ORM 6.0.0 and am using "logging": false as the rest but posted my answer for latest version of the ORM.

const sequelize = new Sequelize(
        process.env.databaseName,
        process.env.databaseUser,
        process.env.password,
        {
            host: process.env.databaseHost,
            dialect: process.env.dialect,
            "logging": false,
            define: {
                // Table names won't be pluralized.
                freezeTableName: true,
                // All tables won't have "createdAt" and "updatedAt" Auto fields.
                timestamps: false
            }
        }
    );

Note: I am storing my secretes in a configuration file .env observing the 12-factor methodology.

Josef · Accepted Answer · 2021-06-09 01:04:17Z

1

new Sequelize({
    host: "localhost",
    database: "database_name",
    dialect: "mysql",
    username: "root",
    password: "password",
    logging: false        // for disable logs
})

edited Jun 9, 2021 at 1:04

Josef

3,6522 gold badges26 silver badges27 bronze badges

answered Jun 8, 2021 at 5:40

Swayam Gupta

212 bronze badges

Collectives™ on Stack Overflow

Prevent Sequelize from outputting SQL to the console on execution of query?

10 Answers 10

5 Comments

Comments

1 Comment

1 Comment

1 Comment

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

5 Comments

Comments

1 Comment

1 Comment

1 Comment

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related