To prevent the Query Builder and Schema Designer tabs from opening every time you can disable them in the
The file can be found under C:\Users\<your username>\AppData\Roaming\SQLyog or similar in other Windows OSes. Find the lines called
DefaultSchemaDesignerand change their values from 1 to 0.
SQLyog should now only open the Query tab.
(The tabs can easily be added by pressing Ctrl + K or Ctrl + Alt + D respectively or from the Powertools menu).