​

SQL Editor

​

Writing Queries

SELECT * FROM users LIMIT 10;
SELECT COUNT(*) FROM orders;

• On databases with transaction support, the batch runs in a transaction: if a statement fails, execution stops and all changes roll back. Databases without transactions run each statement as-is, with no rollback.
• The error names the failing statement (“Statement 3/5 failed: …”).
• The last SELECT result appears in the data grid.
• Each statement is recorded individually in query history.

​

Per-Tab Database Picker

• Changing the picker affects only that tab. Switching the active database elsewhere keeps existing tabs on their bound database.
• The picker lists the databases visible in the sidebar, so it follows the sidebar database filter.
• Databases whose driver reconnects the session to switch show a lock instead of a menu; those tabs follow the connection’s active database.

​

Find and Replace

​

Query Execution

​

Automatic Row Limit

• The default cap is 10,000 rows. Pick 100 to 500,000 in Settings > Data (Row cap), or turn off Truncate query results to disable it.
• Your query is sent exactly as you wrote it. TablePro never changes the SQL, it stops reading once it reaches the cap.
• Your own LIMIT, FETCH FIRST, or TOP always wins: the query is not capped for that run.
• EXPLAIN, SHOW, writes, and DDL are never limited.

​

Results

• Result tabs: every result gets a tab above the grid; multi-statement runs produce one tab per statement. Switch with Cmd+Option+[ / Cmd+Option+], close with Cmd+Shift+W. Hover a tab to see its query.
• Pinning: right-click a tab and choose Pin Result, or press Cmd+Option+P. The next query lands in a new tab instead of overwriting the pinned one. Pinned tabs cannot be closed or cleared until unpinned.
• Panel: toggle the results panel with Cmd+Option+R or the toolbar button; it auto-expands when a query executes. The toolbar trash button clears the query and results together; to keep the query, right-click the results and choose Clear Results.
• Errors: a red banner above the results shows the database error message with a Fix with AI button.
• Non-SELECT statements (INSERT, UPDATE, DELETE, DDL) show a success view with affected row count and execution time.

​

SQL Formatting

• Breaks lines per clause (SELECT, FROM, WHERE, JOIN) and indents 2 spaces
• Uppercases keywords
• Preserves comments, string literals, and your cursor position
• Keeps dialect identifier quoting (MySQL backticks, PostgreSQL double quotes)
• Handles JOINs, subqueries, CASE expressions, CTEs (including recursive), window functions, and set operations

select u.id,u.name,count(o.id) as order_count from users u left join orders o on u.id=o.user_id where u.status='active' group by u.id,u.name having count(o.id)>5 order by order_count desc;

SELECT
  u.id,
  u.name,
  COUNT(o.id) AS order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE u.status = 'active'
GROUP BY u.id, u.name
HAVING COUNT(o.id) > 5
ORDER BY order_count DESC;

​

Vim Mode

​

Editor Settings

​

AI Assistance

​

SQL Files

• Double-click in Finder (or Open With > TablePro)
• File > Open File… (Cmd+O)
• Drag files onto the dock icon

​

Saving

• Cmd+S saves back to the source file. Untitled tabs trigger Save As.
• Cmd+Shift+S opens Save As.

​

External Modifications

​

Linked Folders