Run Queries

Getting Started

Writing Your First Query

1. Select your database from the connection panel

2. Choose your query style: SQL, Mongosh, or let the editor auto-detect

3. Start typing - autocomplete will guide you

4. Run your query with Ctrl+Enter or click the Run button

Using Autocomplete

The editor provides intelligent suggestions as you type:

• Table/Collection names: Type to see available tables

• Column names: Automatically suggests columns after table selection

• Functions: Database-specific function suggestions

• Values: Suggests actual values from your data where applicable

AI Assistance

Press Ctrl+Space or simply describe `/question` what you want to do:

• "/Find all users from last month"

• "/Group sales by region"

• "/Show table structure"

The AI will suggest complete queries based on your schema.

Query Execution

Running Queries

• Single Query: Ctrl+Enter or click Run

• Multiple Queries: Only supported with `postgresql, clickhouse`.

We're working on Selected Query execution.

Results

• Tabular View: Clean, sortable results table

• Export Options: CSV, JSON, or copy to clipboard

• Performance Metrics: Query execution time and row count