Skip to content

SQL editor

Write SQL with autocomplete that reads your schema, keep the queries you reuse, and see how the database runs them.

The TablePro SQL editor on a Mac, with the column completion list open over a query and its results below.

Autocomplete from your schema

Autocomplete suggests tables and columns, aliases, CTEs and subqueries included. Run the current statement, a selection or the whole script; an ordinary batch runs in one transaction and rolls back if a statement fails.

Format with ⌘⇧L, switch on Vim mode, or jump to any table, view or saved query with Open Quickly (⌘⇧O).

On iPhone and iPad, the Query tab runs SQL without autocomplete.

Parameters, history and saved queries

Write :customer_id and TablePro asks for the value before the query runs. Search your history by text, source, failures or time range: it keeps 10,000 entries for 90 days and never syncs.

Save the queries you reuse, or link a folder of .sql files to the sidebar, with two-way updates and Git status.

Linux has history and saved queries. iPhone and iPad keep the last 200 queries.

The TablePro SQL editor on a Mac with its query history open beside a query that uses a parameter.

EXPLAIN and EXPLAIN Compare

Read a query plan as a diagram, a cost tree or the engine’s own output. Run the query again after a change and compare the two runs: timing and plan differences show side by side, and anything under 15% counts as noise.

A PostgreSQL query plan drawn as a diagram in TablePro on a Mac.

Query Insights

Pro

Find the slow, failing and most-run queries in this Mac’s history. Statements that differ only in their values group together, and two periods compare side by side. It reads local history only: it is not server monitoring, and it uploads nothing.

Query Insights over the last 7 days, with a chart of succeeded and failed queries per day above the Most Run, Slowest and Got Slower lists, where one query shape is marked Got Slower.

Charts and maps

Pro

Turn a result into a bar, line, area or scatter chart in the same tab, from the first 50,000 rows. Geometry columns open on a map, and selecting a shape finds its row. Result Charts is part of Pro; Map view is free.

A query result shown as a bar chart of revenue by country in TablePro on a Mac.

Also

  • Other query languages

    Non-SQL engines use their own query language in the editor. MongoDB gets a built-in shell in the style of mongosh.

    By engine: MongoDB (MQL), Redis (Redis CLI), Cassandra (CQL), ScyllaDB (CQL), Amazon DynamoDB (PartiQL), Elasticsearch (Query DSL), etcd (etcdctl), Apache Kafka (KafkaQL), SurrealDB (SurrealQL), Typesense (Typesense API), Weaviate (GraphQL)

  • Large results

    A query returns at most 10,000 rows unless you raise the cap in Settings, up to 500,000. A LIMIT you write yourself always wins.

  • On iPhone and iPad

    The Query tab highlights SQL, runs and stops it, and shares a result as JSON, CSV or INSERT statements.

Get TablePro

Pro adds Query Insights and Result Charts. Everything else on this page is free.