RubyMine
 
2023.1
Get RubyMine
You are viewing the documentation for an earlier version of RubyMine.

Query consoles

Last modified: 21 June 2023

Query or database consoles are SQL files in which you can compose and execute SQL statements. Unlike scratch files, consoles are attached to a data source. You can use a query console in the same way as you use a terminal. Just type and run your code.

When you create a data source, a query console is created automatically. If necessary, you can create additional consoles. Each console creates a new connection. If you do not want to create new connections, enable single session mode.

All the created query consoles are located in the internal Database Consoles directory. To open this folder, open the Project tool window () and navigate to Scratches and Consoles | Database Consoles. On your machine, the query console files are stored in the consoles subdirectory of the IDE configuration directory.

For information about working with query results in query consoles, refer to Query results.

Language and Framework-Specific Guidelines