Query Execution #
Run a query with Cmd+Enter. SELECT executes the SQL against the associated database and displays results in a table below the editor.
Streaming (proxified connections) #
When using proxified connections, results are streamed progressively. You see rows as they arrive instead of waiting for the full result set. The table fills incrementally while the query is still running.
For local connections, results are fetched in a single round-trip.
Limits #
Two settings in your .config file control execution bounds:
| Setting | Default | Max | Description |
|---|---|---|---|
| statement_timeout_ms | 30000 | none | Max query execution time (milliseconds) |
| max_result_size_mb | 100 | 250 | Max result size before truncation (MB) |
These limits apply to both local and proxified queries. When a timeout fires, SELECT cancels the query on the database side. If the result exceeds the size limit, it is truncated and a notice is shown.
Set statement_timeout_ms to 0 to disable the timeout entirely. This is useful for long-running migrations or bulk operations.
Result caching #
Results are cached per database and file combination. Switching tabs and coming back shows the cached result instantly without re-executing. Running the query again replaces the cache.