Server Output

Overview

The Server output log lets you view messages generated by database scripts and procedures directly in the SQL Editor. This feature helps debug queries, monitor script execution, and track informational or warning messages from the server.

Open server output log

Before executing scripts, enable the Server output log:

1. In the SQL Editor toolbar, click Show server output button ().

2. Run your SQL queries or procedural scripts.

Tip: Scripts typically use statements like RAISE (PostgreSQL) or PRINT (SQL Server) to send these messages to the output log. Adjust message visibility by configuring log levels with statements like SET to show more detailed information. For details about log message types, see your database system’s documentation.

View log messages

After executing the scripts, switch to the Output tab.

Search log messages

To quickly find a specific log type your search text into the search field at the top of the Output tab. Matching logs appear instantly.

Tip: Clear the search field to see all logs again.

Filter log messages

To simplify viewing specific message types, filter logs:

1. In the Output tab toolbar, click Filter button ().
2. Select the log message types you want to display:
   • Debug
   • Log
   • Info
   • Notice
   • Warning
   • Error

Filtering only affects displayed logs - it doesn't change what's stored or generated by your database scripts.

Wrap log messages

To wrap long log messages in the Output tab:

1. In the Output tab toolbar, click the settings button ().
2. Select the Wrap mode checkbox.