Skip to content
  • docs
  • sql playground

SQL Playground

The SQL Playground is a dedicated environment for writing and executing raw SQL queries directly against your database tables.

To access this tool, select SQL Playground from the left-hand sidebar menu.

Query Editor

Section titled “Query Editor”

The main “Playground” area allows you to write standard SQL statements. You can perform simple SELECT queries or complex JOIN operations (e.g., linking students with cities).

Execution Methods

Section titled “Execution Methods”

There are multiple ways to execute your code, giving you flexibility depending on your workflow:

  1. Line Execution: Click the Blue Play Triangle (▶) located in the gutter next to a specific line number to run just that statement. alt text

  2. Context Menu (Right-Click): Right-click anywhere in the editor to open a menu where you can select Execute SQL Query or run a specific line (e.g., “Execute Line 1”). alt text

  3. Keyboard Shortcut: Press Ctrl + Enter to execute the query immediately without using the mouse.

  4. Operations Panel: Click the large Run (▶) button located in the top-right corner, a “Select Operation” panel lists suggested or context-aware queries (e.g., “Select All From students”). alt text

Toolbar Actions

Section titled “Toolbar Actions”

The toolbar at the top of the editor provides tools to manage your code:

  • Format: Use the Magic Wand icon to automatically format and indent your SQL code for better readability. alt text

  • History: Access a log of your previously executed queries. alt text

  • Download: Download the current queries to your local machine. alt text

  • Copy: Use the Copy icon to copy the editor’s content to your clipboard. alt text

  • Clear: Use the Broom icon to clear or delete all queries from the editor. alt text

Results Panel

Section titled “Results Panel”

The Results section at the bottom displays the output of your execution.

  • Data Grid: The data is presented in a table format with columns corresponding to your query (e.g., first_name, age, name_city).
  • Row Count: The total number of records returned is displayed in the top right (e.g., “9 rows found”).
  • Column Visibility: You can customize the view by clicking the column selector icon in the results header to toggle specific columns on or off.

alt text