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


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.


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.
Plans as a diagram: PostgreSQL, MySQL, SQLite, MariaDB, CockroachDB, PGlite, ClickHouse, DuckDB, Cloudflare D1, Turso, libSQL, Google Cloud Spanner, Dameng DM8, SAP HANA
Plans as text: TiDB, OceanBase, Databend, Amazon Redshift, Snowflake, SurrealDB, Teradata, Trino, Cloudflare R2 SQL
Dry-run cost: Google BigQuery


Query Insights
ProFind 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.


Charts and maps
ProTurn 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.


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.