SQL Playground

The SQL Playground is a direct query interface to your project’s database. It runs in the same connection your app uses, so what you can do depends on the role you are signed in as. To access this tool, open a table on the Data page (Rows or Schema tab) and click SQL Playground under DB-Level Tools, next to ERD.

​

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

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.
2. Context Menu (Right-Click): Right-click anywhere in the editor to open a menu where you can select Execute SQL Query.
3. Keyboard Shortcut: Press Ctrl + Enter (⌘ + Enter on Mac) to execute the query immediately without using the mouse.
4. Execute Button: Click Execute in the top-right corner of the editor.

​

Toolbar Actions

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

• Format SQL: Use the Magic Wand icon to automatically format and indent your SQL code for better readability.
• Query History: Access a log of your previously executed queries.
• Download SQL: Download the current queries to your local machine.
• Copy SQL: Use the Copy icon to copy the editor’s content to your clipboard.
• Clear Editor: Use the Broom icon to clear or delete all queries from the editor.

​

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.
• Row Count and Timing: The number of records returned and the query runtime are displayed in the top right (e.g., “5 rows found | 313ms”).
• Column Visibility: You can customize the view by clicking the column selector icon in the results header to toggle specific columns on or off.

​

DDL statements

Schema changes (CREATE, ALTER, DROP) are not executed in the playground — they belong in the Data workflow which produces tracked migrations.

​

Per-environment data

The playground binds to the active environment. Switch environments to query staging or production data. Production access is typically restricted to admin roles.

​

Best practices

• Use transactions for multi-statement writes — BEGIN; ...; COMMIT;
• Limit destructive queries — always test with a WHERE clause first
• Use EXPLAIN to inspect query plans for slow reads
• Avoid manually inserting rows that should go through the application layer (validation, hooks)

​

FAQ