Query editor

The query editor is where you write and run queries against any connected database: SQL for PostgreSQL, MySQL, and SQLite; shell-style queries for MongoDB; and commands for Redis.

Open an editor

Click + in the tab bar and choose New Query, or use the query icon in the sidebar. The editor knows which connection and database the tab targets, shown in the footer.

Write with autocomplete

As you type, FlexTable suggests tables, columns, and keywords from the live schema.

Schema-aware. Suggestions come from the database you are actually connected to, so table names, column names, and types are real.

-- PostgreSQL / MySQL / SQLite
SELECT id, email, created_at FROM users WHERE active = true ORDER BY created_at DESC LIMIT 100;

// MongoDB
db.users.find({ active: true }).sort({ created_at: -1 }).limit(100)

# Redis
SCAN 0 MATCH user:* COUNT 100

Format your SQL

Reformat a messy statement into clean, readable SQL with one action, so shared and saved queries stay tidy.

Run and read results

Press Cmd/Ctrl + Enter (or the Run button) to execute. Results stream into the grid below and large results paginate. The result grid is the same one used for table browsing, so you can sort, filter, and inspect a cell just like a table.

Stop a running query

A long-running query can be stopped: the Run button becomes Stop while it executes. While the stop is in progress the editor shows Stopping query… (“Waiting for the database to answer. This can take a few seconds.”). FlexTable then tells you what actually happened, in the status bar and, when it matters, as a one-line strip in the result pane:

Outcome	What it means
Query stopped (for a write: “Query stopped. Nothing was saved”)	The database confirmed the query stopped before saving anything.
Query stopped and the transaction was rolled back	Nothing from this query was saved. The open transaction was rolled back too, so changes made earlier in it that were not committed are gone. The tab is no longer in a transaction.
Query stopped partway	The database stopped the query, but work that ran before the stop may already be saved. Check the data before running it again.
Stop sent, not confirmed	The database got the stop request but did not say whether the query stopped or finished. For a write, its changes may be saved, fully or in part.
Too late to stop: the query finished	The query completed before the stop arrived. For a write, its changes are saved, and running it again applies them a second time.

Re-running after a stop. When changes may already be saved, running the same query again first asks Run this query again? (“Running it again may apply the same changes twice.”). Choose Run anyway to go ahead or Cancel to check the data first.

The same outcomes apply when you stop a table load, an import or an export.

Saved queries and history

Saved queries in the Query Manager, organized into folders

Two separate things:

Saved queries - name and save a query, organize saved queries into folders, and reopen them later. Save with Cmd/Ctrl + S or the Save action in the editor.
Run history - every query you run is logged automatically, separate from saved queries, with its status, duration, rows affected, and timestamp. Open the history view (grouped by date) to copy, re-run, or reopen a past query.

Visualize and export

Chart - switch the result from Table to Chart to see it as a bar, line, area, pie, or scatter chart. See Charts.
Export - save the result as CSV, JSON, SQL, or Excel. See Import and export.

Logs

The footer Logs tab shows execution details (timing and errors) for the queries you have run.

Get started

Connections

Working with data

Database guides

Manage and settings

Help and reference

Open an editor

Write with autocomplete

Format your SQL

Run and read results

Stop a running query

Saved queries and history

Visualize and export

Logs

​Open an editor

​Write with autocomplete

​Format your SQL

​Run and read results

​Stop a running query

​Saved queries and history

​Visualize and export

​Logs

Open an editor

Write with autocomplete

Format your SQL

Run and read results

Stop a running query

Saved queries and history

Visualize and export

Logs