IntelliJ parity
Roadmap
Every feature JetBrains documents for Database Tools, woven into one cloth. Each square is a feature, in the order I think it matters to a day's work, left to right and top to bottom. The solid squares are supported, the hatched ones are what 1.0 still needs, and the seam is where 1.0 gets cut. Hover a square to see what it is; click it to find it in the list.
80of 252features supported
- 80 supported
- 37 before 1.0
- 125 after 1.0
- 10 not planned
1.0
What 1.0 means. The top 117 squares, the essential and important tiers, all solid, and the settings format frozen. That's 37 to go. Until then the extension stays in preview and a minor version may still change
tablecloth.dataSources.
Next up Create/Modify Table · Full-text search across selected data sources/schemas/tables
The list
Essentialfelt every session
57 of 65 supported
1PostgreSQL, MySQL/MariaDB, SQLite data sources
2Auth: User & Password, pgpass, No auth
3Test Connection
4SSH tunnel: password / key pair (OpenSSH, PuTTY) / OpenSSH config & agent
5SSL with CA file and verification mode (Require / Verify CA / Full)
6Read-only data source
7Default transaction mode (Auto/Manual) and isolation level per data source
8Passwords in OS keychain
9Tree: schemas, tables, views, columns, indexes, keys, routines, sequences, types
10PK/FK/index icon combinations on columns
11Refresh (Ctrl+F5)
12Jump to Query Console (Ctrl+Shift+F10)
13Edit Data (F4)
14Go to DDL (Ctrl+B)
15Export Data to File
16SQL Scripts > Run SQL Script
17Query console per data source; create new (Ctrl+Shift+Q)
18Default console (F4 on source)
19Default schema / search_path switcher in console toolbar
20Execute statement at caret / selection (Ctrl+Enter) with statement frame
21Run whole script
Choose the statement under the caret
With the caret inside a subquery, ⌘⏎ asks which statement you meant. A setting makes it stop asking: the smallest subquery, the whole statement, or everything from the caret.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT s.customer_id, s.spent
2FROM (SELECT customer_id, sum(total) AS spent
3 FROM orders
4 WHERE status = 'shipped'
5 GROUP BY customer_id) s
6WHERE s.spent > 500;
Choose statement to execute
SELECT customer_id, sum(total) AS spent FROM orders WHERE … GROUP BY customer_idsubquery
SELECT s.customer_id, s.spent FROM (…) s WHERE s.spent > 500whole statement
Always run: Ask · Smallest subquery · Largest statement · Everything from caret
0 0Tablecloth: 2 statements at the caretacme-dev · acme · publicLn 3, Col 18SQL
Run exactly the selection
Select part of a script and ⌘⏎ runs the selection: as separate statements, or as one when you ask. A setting decides whether a partial selection grows to whole statements first.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1UPDATE orders SET status = 'shipped' WHERE id = 1042;
2INSERT INTO audit (order_id, event) VALUES (1042, 'shipped');
3SELECT * FROM orders WHERE id = 1042;
Run selection
Run as 2 separate statements⌘⏎
Run as a single statementExecute Selection as Single
Selection: Smart expand · Exact · Whole statements
0 0Tablecloth: 2 statements selectedacme-dev · acme · public2 lines selectedSQL
24Cancel running statements (Ctrl+F2), gutter progress indicator, cancel connection creation
25Parameters
:name, ?, $1, ${name} with values dialog; named vs positional26Query History dialog (Ctrl+Alt+E) with search, paste, delete
27Transaction mode Auto/Manual, isolation, Commit, Roll Back, Submit and Commit on console toolbar
28Result tab per statement
29Custom result tab title from a comment before the query
30Output tab log (statements, errors, timestamps, affected rows, duration)
31Paging (500 default), First/Prev/Next/Last, page size, show all
32Reload page (Ctrl+F5)
33Table / Tree / Text / Transpose views
34Value editor
35Find on Current Page (Ctrl+F) with Filter Rows
36Local (client-side) column filters in header; clear all
37WHERE and ORDER BY fields with completion
38Header sort, stacked multi-sort with Alt, numbered priority
39Related Rows (F4): referenced and referencing, multi-value
40Inline cell editing with local change set
41Add / Delete / Clone row
42Set NULL / Set DEFAULT
43Submit (Ctrl+Enter) with Preview Pending Changes (DML)
44Revert Selected / all
45Transaction mode / isolation / Roll Back per editor
46Extractors: SQL Inserts/Updates/Insert-Multirow/One-row, CSV/TSV/pipe, HTML, JSON, Markdown, Pretty, XML, Excel, Python DataFrame, Where clause
47Copy with active extractor (Ctrl+C)
48Export Data dialog to file/clipboard, selection-aware
49Import CSV with mapping, create table, delimiter detection, batches, stop/skip on error
50Object name completion with qualification and dialect quoting
51Keyword completion by clause
52Function completion
53JOIN completion from foreign keys (JOIN + ON), invert-operands option
54Reformat code (Ctrl+Alt+L)
55Unresolved reference (Error) with quick-fixes
Ambiguous column, flagged before the server sees it
A bare column that exists in two joined tables gets a warning in the editor, with a fix for each side.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT id, email, total
2FROM orders o
3JOIN customers c ON c.id = o.customer_id
4WHERE status = 'shipped';
Ambiguous column reference id: it exists in orders (o) and customers (c)
Qualify as o.idQualify as c.id
0 0Tablecloth: 1 warningacme-dev · acme · publicLn 1, Col 9SQL
57DELETE/UPDATE without WHERE (inspection + pre-execution warning dialog)
Column should be in GROUP BY
A selected column that is neither grouped nor aggregated is flagged, with the two ways out as quick fixes.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT customer_id, status, count(*)
2FROM orders
3GROUP BY customer_id;
Column status must appear in the GROUP BY clause or be used in an aggregate function
Add status to GROUP BYWrap in min(status)
0 0Tablecloth: 1 warningacme-dev · acme · publicLn 1, Col 21SQL
59Go to Database Object / Search Everywhere
Modify Table, as a form
The Modify Table dialog edits columns, keys, indexes and constraints as a form and shows the ALTER statements it will run. Nothing runs until you press OK.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM orders LIMIT 10;
Modify Table
public.orders on acme-dev
ColumnsKeysIndexesForeign KeysChecks
| Name | Type | Not null | Default | Comment |
|---|---|---|---|---|
| id | bigint | ✓ | identity | |
| customer_id | bigint | ✓ | ||
| status | order_status | ✓ | 'pending' | |
| total | numeric(10,2) | ✓ | ||
| note | text | Free-text note from support | ||
| created_at | timestamptz | ✓ | now() | |
| shipped_at | timestamptz |
Preview
ALTER TABLE public.orders ADD COLUMN shipped_at timestamptz;
CancelOpen in ConsoleOK
0 0Tablecloth: Modify Tableacme-dev · acme · publicLn 1, Col 1SQL
Modify Column
One column at a time: type, nullability, default and comment, with the statements shown before they run.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
id
customer_id
status
total
note
idx_orders_status
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM orders LIMIT 10;
Modify Column
public.orders.note
Namenote
Typetext
Not nullAuto-increment
Default''
CommentFree-text note from support
Preview
ALTER TABLE public.orders ALTER COLUMN note SET DEFAULT '';
COMMENT ON COLUMN public.orders.note IS 'Free-text note from support';
CancelOK
0 0Tablecloth: Modify Columnacme-dev · acme · publicLn 1, Col 1SQL
62Go to DDL (read)
Edit DDL in place, submit a migration
Go to DDL opens the definition read-only today. Here the same document is editable: change the view's SELECT, press ⌘K, and Tablecloth shows the script it generated before anything runs.
shipped_orders.sql (DDL) — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
shipped_orders.sqlDDLconsole [acme.public]
1CREATE OR REPLACE VIEW public.shipped_orders AS
2SELECT o.id,
3 o.customer_id,
4 c.email,
5 o.status,
6 o.total,
7 o.created_at
8FROM orders o
9JOIN customers c ON c.id = o.customer_id
10WHERE o.status = 'shipped'::order_status;
11
Submit Changes
2 statements will run on acme-dev · acme.public
Server definition unchanged since you opened it at 10:42
-- column list changed; CREATE OR REPLACE will not do
-- the view is recreated and its grants re-applied
DROP VIEW public.shipped_orders;
CREATE VIEW public.shipped_orders AS
SELECT o.id, o.customer_id, c.email,
o.status, o.total, o.created_at
FROM orders o
JOIN customers c ON c.id = o.customer_id
WHERE o.status = 'shipped'::order_status;
GRANT SELECT ON public.shipped_orders TO reporting;
CancelOpen in ConsoleSubmit
0 0Tablecloth: DDL of view public.shipped_orders · 2 lines addedacme-dev · acme · publicLn 10, Col 42SQL
64Explain Plan (tree + table Query Plan tab, costs)
65Explain Analyse
Importantweekly
22 of 52 supported
66Switch schema: Automatic / Manual (persist search_path)
67Auto sync
68Schema selection ("N of M") for introspection
69Show internal system schemas
70Data source colours
71Project vs Global scope (Make Global / Move to Project)
72Duplicate / Remove data source
73Deactivate / disconnect (Ctrl+F2)
Speed search in the tree
Start typing with the tree focused and it narrows to matching objects across every expanded source. Enter jumps to the match, Escape clears.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
order_items
orders
views1
shipped_orders
object types2
order_status
acme-staging
acme-prodread-only
ord4 matches
console [acme.public]
1SELECT * FROM orders WHERE id = 1042;
0 0Tablecloth: 4 objects match "ord"acme-dev · acme · publicLn 1, Col 1SQL
Filter the tree by object type
A filter on the toolbar hides whole object types, so a schema with two hundred routines can show only its tables and views.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
shipped_orders
acme-staging
acme-prodread-only
analytics
Show
TablesViewsRoutinesSequencesObject typesIndexes
console [acme.public]
1SELECT * FROM orders WHERE id = 1042;
0 0Tablecloth: showing tables and viewsacme-dev · acme · publicLn 1, Col 1SQL
76Properties (Shift+Enter)
77Copy Reference (Ctrl+Alt+Shift+C) fully qualified name
Copy a table to another source
Copy Table takes structure and data to another schema or data source, with the column mapping shown before it starts.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM orders LIMIT 10;
Copy Table
public.orders from acme-dev
Target data sourceacme-staging
Schemapublic
Table nameorders
Copy structureCopy data (2,400 rows)Drop target if it exists
| Column | Type | Target column |
|---|---|---|
| id | bigint | id |
| customer_id | bigint | customer_id |
| status | order_status | status |
| total | numeric(10,2) | total |
| note | text | note |
CancelCopy
0 0Tablecloth: Copy Tableacme-dev · acme · publicLn 1, Col 1SQL
79Import Data from File(s)
Truncate, with the options spelled out
Truncate from the context menu, with restart identity and cascade as checkboxes and the statement shown before it runs.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT count(*) FROM orders;
Truncate Table
public.orders on acme-dev · 2,400 rows
Restart identityCascade to order_items
Preview
TRUNCATE TABLE public.orders RESTART IDENTITY;
CancelTruncate
0 0Tablecloth: Truncate Tableacme-dev · acme · publicLn 1, Col 1SQL
SQL Generator
Generate DDL for any selection of objects with the options IntelliJ offers, to the clipboard, a console, or a directory of files.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM orders LIMIT 10;
SQL Generator
3 tables, 1 view, 2 types selected on acme-dev
Add IF NOT EXISTSQualify namesConstraints inside CREATE TABLESkip DEFINER
LayoutOne file per object
OutputDirectory: ./db/schema
customers.sql
CREATE TABLE IF NOT EXISTS public.customers
(
id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
email varchar(120) NOT NULL UNIQUE,
name text,
created_at timestamptz NOT NULL DEFAULT now()
);
CancelGenerate
0 0Tablecloth: SQL Generatoracme-dev · acme · publicLn 1, Col 1SQL
Modify Comment
Comments on tables and columns from the context menu, without remembering the COMMENT ON syntax.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
id
customer_id
status
total
note
idx_orders_status
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM orders LIMIT 10;
Modify Comment
public.orders.note
CommentFree-text note from support
Preview
COMMENT ON COLUMN public.orders.note IS 'Free-text note from support';
CancelOK
0 0Tablecloth: Modify Commentacme-dev · acme · publicLn 1, Col 1SQL
83Manage Shown Schemas
84Rename / duplicate / persist consoles
85Attach / detach a data source on any .sql file
86Run .sql file on a data source from Project view / drag onto source
When the caret is outside a statement
Press ⌘⏎ on a blank line and nothing happens today. This makes it a choice: run the whole script, run everything below the caret, or keep doing nothing.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM orders WHERE status = 'shipped';
2
3
4SELECT * FROM customers;
Nothing at the caret · run:
Do nothingdefault
Run the whole script
Run everything below the caret
0 0Tablecloth: no statement at the caretacme-dev · acme · publicLn 3, Col 1SQL
Run a routine with parameters
Execute Routine from the tree asks for each parameter with its type, and shows the call it will make.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
routines1
refresh_totals
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM orders LIMIT 10;
Execute Routine
public.refresh_totals(since timestamptz) returns integer
| Parameter | Type | Value |
|---|---|---|
| since | timestamptz | '2026-09-01' |
Output to consoleOutput to file…
Call
SELECT public.refresh_totals('2026-09-01');
CancelExecute
0 0Tablecloth: Execute Routineacme-dev · acme · publicLn 1, Col 1SQL
Playground or Script resolution
In Playground mode a USE or SET search_path in the console changes what unqualified names mean from then on; in Script mode they resolve against the console schema. The mode sits in the toolbar.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SET search_path TO archive;
2
3SELECT count(*) FROM orders;
PlaygroundUSE and SET search_path change the context
Scriptnames resolve against the console schema
archive.orders · resolved through search_path set on line 1
0 0Tablecloth: resolving in Playground modeacme-dev · acme · publicLn 3, Col 22SQL
Pin a result tab
Pin a result tab and later runs open next to it instead of replacing it.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1-- shipped orders
2SELECT o.id, c.email, o.total FROM orders o JOIN customers c ON c.id = o.customer_id WHERE o.status = 'shipped';
3
4SELECT * FROM customers;
Pin Tab
Rename Tab…
Close
Close Others
PROBLEMSOUTPUTTERMINALTABLECLOTH
Database
acme-dev
console
shipped ordersacme.public.customers
| idbigint | emailvarchar | totalnumeric | |
|---|---|---|---|
| 1 | 3 | user3@example.com | 212.40 |
| 2 | 6 | user6@example.com | 88.00 |
| 3 | 9 | user9@example.com | 301.15 |
‹ 1-812 of 812 ›
0 0Tablecloth: 1 tab pinnedacme-dev · acme · publicLn 4, Col 1SQL
Edit the result of a JOIN
A result set that reads two tables is editable when both keys are in it, and Submit writes an UPDATE per table.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT o.id, c.id AS customer, c.email, o.status, o.total
2FROM orders o JOIN customers c ON c.id = o.customer_id
3WHERE o.status = 'pending';
Submit Changes
2 statements, 2 tables · acme-dev
UPDATE public.customers SET email = 'grace.hopper@example.com' WHERE id = 22;
UPDATE public.orders SET status = 'shipped' WHERE id = 1042;
CancelSubmit
PROBLEMSOUTPUTTERMINALTABLECLOTH
Database
acme-dev
console
acme.public.orders
| idbigint | customerbigint | emailvarchar | statusorder_status | totalnumeric | |
|---|---|---|---|---|---|
| 1 | 1042 | 22 | grace.hopper@example.com | shipped | 129.00 |
| 2 | 1043 | 5 | user5@example.com | pending | 44.10 |
‹ 1-788 of 788 ›
0 0Tablecloth: editing customers and orders · 2 pending changesacme-dev · acme · publicLn 3, Col 28SQL
Record view
One row as a form beside the grid, which is how a wide row is meant to be read. It follows the selection.
orders — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
ordersacme.publicconsole [acme.public]
WHEREORDER BY
| idbigint | customer_idbigint | statusorder_status | totalnumeric | notetext | created_attimestamptz | |
|---|---|---|---|---|---|---|
| 1 | 1040 | 13 | delivered | 61.20 | <null> | 2026-09-01 11:43 |
| 2 | 1041 | 76 | pending | 18.99 | <null> | 2026-09-01 11:43 |
| 3 | 1042 | 22 | shipped | 129.00 | gift wrap | 2026-09-01 11:43 |
| 4 | 1043 | 5 | pending | 44.10 | <null> | 2026-09-01 11:44 |
| 5 | 1044 | 91 | shipped | 302.50 | <null> | 2026-09-01 11:44 |
‹ 1-500 of 2,400 ›
Record · orders #1042
id1042customer_id22statusshippedtotal129.00notegift wrapcreated_at2026-09-01 11:43
0 0Tablecloth: 500 rows fetched · row 1042 selectedacme-dev · acme · public1 rowSQL
93Filter by (cell context menu)
94Column list, hide/show columns (Ctrl+F12)
Go to Row
⌘G asks for a row number, or column:row, and the grid scrolls there and selects it.
orders — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
ordersacme.publicconsole [acme.public]
WHEREORDER BY
| idbigint | customer_idbigint | statusorder_status | totalnumeric | notetext | created_attimestamptz | |
|---|---|---|---|---|---|---|
| 1 | 1202 | 8 | pending | 20.00 | <null> | 2026-09-02 08:10 |
| 2 | 1203 | 44 | shipped | 75.90 | <null> | 2026-09-02 08:11 |
| 3 | 1204 | 22 | delivered | 15.00 | left at door | 2026-09-02 08:11 |
| 4 | 1205 | 3 | pending | 99.00 | <null> | 2026-09-02 08:12 |
‹ 1,001-1,500 of 2,400 ›
Go to Row
1204
row, or column:row (for example total:1204)
0 0Tablecloth: row 1204 of 2,400acme-dev · acme · public1 rowSQL
96View Query / Copy Query to Console / to Clipboard
Value completion in cells
Editing a cell offers the values already in that column, so a status is picked rather than typed.
orders — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
ordersacme.publicconsole [acme.public]
WHEREORDER BY
| idbigint | customer_idbigint | statusorder_status | totalnumeric | notetext | created_attimestamptz | |
|---|---|---|---|---|---|---|
| 1 | 1040 | 13 | delivered | 61.20 | <null> | 2026-09-01 11:43 |
| 2 | 1041 | 76 | pending | 18.99 | <null> | 2026-09-01 11:43 |
| 3 | 1042 | 22 | shipped | 129.00 | gift wrap | 2026-09-01 11:43 |
| 4 | 1043 | 5 | shi | 44.10 | <null> | 2026-09-01 11:44 |
| 5 | 1044 | 91 | shipped | 302.50 | <null> | 2026-09-01 11:44 |
‹ 1-500 of 2,400 ›
shipped1,203 rows
pending788
delivered409
0 0Tablecloth: editing orders.status · 1 pending changeacme-dev · acme · publicLn 4SQL
98Paste multi-line tab-separated text into the grid (auto-split into cells); no paste-format selector for CSV yet
Conflicts on submit
If a row changed on the server after you loaded it, Submit stops and shows both versions instead of overwriting the other person's edit.
orders — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
ordersacme.publicconsole [acme.public]
WHEREORDER BY
| idbigint | customer_idbigint | statusorder_status | totalnumeric | notetext | created_attimestamptz | |
|---|---|---|---|---|---|---|
| 1 | 1040 | 13 | delivered | 61.20 | <null> | 2026-09-01 11:43 |
| 2 | 1041 | 76 | pending | 18.99 | <null> | 2026-09-01 11:43 |
| 3 | 1042 | 22 | shipped | 129.00 | gift wrap | 2026-09-01 11:43 |
| 4 | 1043 | 5 | pending | 44.10 | <null> | 2026-09-01 11:44 |
| 5 | 1044 | 91 | shipped | 302.50 | <null> | 2026-09-01 11:44 |
‹ 1-500 of 2,400 ›
Conflicting changes
orders · row id 1042 changed on the server since you loaded it
| Column | Yours | Server (app_user, 10:47) |
|---|---|---|
| total | 129.00 | 132.50 |
| note | 'gift wrap' | 'gift wrap, rush' |
Keep mineTake the server'sMerge cell by cell
CancelApply
0 0Tablecloth: submit stopped · 1 conflictacme-dev · acme · public2 pending changesSQL
100CSV Formats dialog (delimiters, quoting, null text, headers, trim, preview)
Dump and restore with the native tools
pg_dump and pg_restore, mysqldump and mysql, driven from a dialog that shows the command it will run.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM orders LIMIT 10;
Export with pg_dump
acme on acme-dev
Data sourceacme-dev
Schemaspublic
FormatCustom (-Fc)
Data onlySchema onlyInclude large objects
Output~/dumps/acme-2026-09-05.dump
Command
pg_dump -h localhost -p 15544 -U postgres -Fc -n public acme \
> ~/dumps/acme-2026-09-05.dump
CancelRun
0 0Tablecloth: pg_dump 16.4 found on PATHacme-dev · acme · publicLn 1, Col 1SQL
102Alias generation on table completion (auto-add setting)
103Live templates sel/selc/selw/ins/upd/tab/col + context templates (Ctrl+J)
Constant conditions
A condition that can only ever be true or false gets flagged, because it is nearly always a typo for the other operator.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT id, total FROM orders
2WHERE status = 'shipped' AND status = 'pending';
Condition is always false: status cannot equal both 'shipped' and 'pending'
Change AND to ORSimplify to status IN (…)
0 0Tablecloth: 1 warningacme-dev · acme · publicLn 2, Col 7SQL
Arity and type checks
The number of values against the column list, the argument count of a function, and the type of a literal against its column are all checked as you type.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1INSERT INTO customers (email, name)
2VALUES ('grace@example.com');
VALUES has 1 expression but 2 columns are listed (email, name)
Add a value for nameRemove name from the column list
0 0Tablecloth: 1 erroracme-dev · acme · publicLn 2, Col 8SQL
Identifier should be quoted
A reserved word used as a name is flagged before the server rejects it, with the quoted form as the fix.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1CREATE TABLE order (
2 id bigint PRIMARY KEY
3);
order is a reserved word in PostgreSQL; quote it or rename it
Quote as "order"Rename…
0 0Tablecloth: 1 erroracme-dev · acme · publicLn 1, Col 14SQL
Comparison with NULL
= NULL is never true. It gets a warning and a one-click IS NULL.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT id FROM orders
2WHERE note = NULL;
Comparison with NULL is never true; use IS NULL
Replace with IS NULL
0 0Tablecloth: 1 warningacme-dev · acme · publicLn 2, Col 7SQL
Rename with usages
Rename a table or column and every usage Tablecloth can see comes with it: dependent views, attached SQL files, open consoles. Preview first, then refactor.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
id
customer_id
status
total
note
idx_orders_status
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT note FROM orders WHERE id = 1042;
Rename Column
public.orders.note
New namememo
Search in comments and stringsUpdate dependent views
| Usage | Where |
|---|---|
| shipped_orders | view definition |
| reports/monthly.sql | lines 12, 31 |
| console [acme.public] | line 7 |
Preview
ALTER TABLE public.orders RENAME COLUMN note TO memo;
CREATE OR REPLACE VIEW public.shipped_orders AS …
CancelPreviewRefactor
0 0Tablecloth: 4 usages foundacme-dev · acme · publicLn 1, Col 1SQL
Find usages
Where is this column used? Views, foreign keys, attached SQL files and consoles, listed in the panel.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT o.id, c.email FROM orders o
2JOIN customers c ON c.id = o.customer_id;
PROBLEMSOUTPUTTERMINALTABLECLOTH
Database
acme-dev
console
Usages of orders.customer_id
shipped_ordersview
JOIN customers c ON c.id = o.customer_id fk_orders_customerforeign key
REFERENCES customers (id) reports/monthly.sqlline 12
GROUP BY o.customer_id console [acme.public]line 2
ON c.id = o.customer_id 0 0Tablecloth: 4 usagesacme-dev · acme · publicLn 2, Col 30SQL
Go to Declaration
⌘-click a table or column in SQL and its DDL opens, the same way it does for a function in code.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT o.id, c.email, o.total
2FROM orders o
3JOIN customers c ON c.id = o.customer_id;
public.orders · table · 6 columns, 2,400 rows
⌘-click to open the DDL
⌘-click to open the DDL
0 0Tableclothacme-dev · acme · publicLn 2, Col 9SQL
Create and modify indexes
An index as a form: name, uniqueness, the columns with their order, and the statement it produces.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
id
customer_id
status
total
note
idx_orders_status
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM orders ORDER BY created_at DESC;
Create Index
on public.orders
Nameidx_orders_customer_created
UniqueConcurrently
| Column | Order |
|---|---|
| customer_id | ASC |
| created_at | DESC |
Preview
CREATE INDEX CONCURRENTLY idx_orders_customer_created
ON public.orders (customer_id, created_at DESC);
CancelOK
0 0Tablecloth: Create Indexacme-dev · acme · publicLn 1, Col 1SQL
Primary keys
Pick the key columns, including a composite key, and see the ALTER before it runs.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM order_items LIMIT 10;
Modify Primary Key
public.order_items
Nameorder_items_pkey
| Column | Type | In key |
|---|---|---|
| order_id | bigint | ✓ |
| product_id | bigint | ✓ |
| quantity | integer |
Preview
ALTER TABLE public.order_items
ADD CONSTRAINT order_items_pkey PRIMARY KEY (order_id, product_id);
CancelOK
0 0Tablecloth: Modify Primary Keyacme-dev · acme · publicLn 1, Col 1SQL
Foreign keys
Target table, column mapping, ON DELETE and ON UPDATE, deferrable: the dialog, then the statement.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
customers
order_items
orders
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM order_items LIMIT 10;
Create Foreign Key
public.order_items → public.orders
Namefk_order_items_order
Target tablepublic.orders
| Column | References |
|---|---|
| order_id | id |
On deleteCASCADE
On updateNO ACTION
DeferrableInitially deferred
Preview
ALTER TABLE public.order_items ADD CONSTRAINT fk_order_items_order
FOREIGN KEY (order_id) REFERENCES public.orders (id)
ON DELETE CASCADE DEFERRABLE;
CancelOK
0 0Tablecloth: Create Foreign Keyacme-dev · acme · publicLn 1, Col 1SQL
Modify View
The view's query, owner and grants in one dialog, with the CREATE OR REPLACE it will run.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM shipped_orders LIMIT 10;
Modify View
public.shipped_orders
Ownerapp_owner
QuerySELECT * FROM orders
WHERE status = 'shipped'
WHERE status = 'shipped'
| Role | Privileges |
|---|---|
| reporting | SELECT |
Preview
CREATE OR REPLACE VIEW public.shipped_orders AS
SELECT * FROM orders WHERE status = 'shipped';
GRANT SELECT ON public.shipped_orders TO reporting;
CancelOK
0 0Tablecloth: Modify Viewacme-dev · acme · publicLn 1, Col 1SQL
Drop, with a confirmation you can edit
Dropping from the tree shows what will go, with IF EXISTS and CASCADE as checkboxes and an editable script.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM shipped_orders LIMIT 10;
Drop 2 Objects
on acme-dev · acme.public
| Object | Type |
|---|---|
| shipped_orders | view |
| idx_orders_status | index |
IF EXISTSCASCADEQualify names
Statements (editable)
DROP VIEW IF EXISTS public.shipped_orders;
DROP INDEX IF EXISTS public.idx_orders_status;
CancelDrop
0 0Tablecloth: Dropacme-dev · acme · publicLn 1, Col 1SQL
The plan as a diagram
The same plan drawn as a tree of nodes, with the expensive one marked, for when the table view is too much to read.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
shipped_orders
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1EXPLAIN
2SELECT o.id, c.email, o.total
3FROM orders o
4JOIN customers c ON c.id = o.customer_id
5WHERE o.status = 'shipped';
PROBLEMSOUTPUTTERMINALTABLECLOTH
Database
acme-dev
console
shipped ordersPlan
Explain Analyse
Hash Joincost 61.3 · 812 rows
Seq Scanorders · 48.0 · 812 rows
Hash3.5 · 120 rows
Seq Scancustomers · 2.2 · 120 rows
0 0Tablecloth: plan for 1 statementacme-dev · acme · publicLn 5, Col 28SQL
Full-text search in data
Search a value across every text column of the selected schemas, and open the matching rows as filtered grids.
console [acme.public] — acme
Database
acme-dev
acme
public
tables3
views1
sequences3
object types2
acme-staging
acme-prodread-only
analytics
console [acme.public]
1SELECT * FROM customers WHERE name ILIKE '%hopper%';
Full-Text Search
acme-dev
Search forhopper
acme-devpublicarchive
ContainsStarts withMatches (regex)
Match caseText columns only
| Table | Column | Rows |
|---|---|---|
| customers | name | 2 |
| orders | note | 1 |
CloseOpen in Panel
0 0Tablecloth: 3 rows in 2 tables match "hopper"acme-dev · acme · publicLn 1, Col 1SQL
1.0
Usefuloccasional
0 of 75 supported
118"URL only" connection type / direct JDBC URL editing
119SSL client certificate + client key files (mutual TLS), truststore option
120Time zone per data source
121Keep-alive query every N seconds
122Auto-disconnect after N seconds
123Startup script
124Single database mode
125Object filter pattern (e.g.
table:-payment_.*)126Colour propagation to editor tab headers, editor backgrounds, toolbars; folder colour with "Apply to Children"
127Group data sources in folders (nested, F6 To Folder, reorder, To Top Level)
128Additional nodes: triggers, check/unique constraints, materialized views, users & roles (Server Objects), domains/composite types, extensions
129View in Groups options: Databases and Schemas; Server/Database Objects; Object Elements; Schema Objects; by Prefix; Separate Procedures and Functions; Constraints under schema; Sort alphabetically
130Scroll from Editor
131Expand All / Collapse All
132Quick Documentation (Ctrl+Q) on tree object
133Generate DDL to Clipboard (Ctrl+Alt+Shift+G) / to Query Console (Ctrl+Alt+Shift+B)
134Request and Copy Original DDL
135Enable/Disable Triggers and Constraints
136Modify Grants
137Query Files folder per data source in tree; create query file from source
138SQL resolution scopes: map directories/files to data sources; project-wide mapping
139"Database Script" run configuration (saved targets + script files)
140Run a file against multiple data sources at once (Ctrl+Shift+F10)
141Execute to File
142Custom parameter patterns (regex; add/remove/reorder; scope scripts / string literals / per language; substitute inside SQL strings)
143Long-running query notification (>20 s)
144Custom statement delimiter
145Toggle "Open results in new tab" vs reuse
146In-Editor Results (results rendered under the query, with paging)
147Sessions tree: data sources > sessions > clients with connection status
148Switch Session for a console/file; Switch Data Source for a client; session modes (single shared / two sessions / dedicated)
149Update Interval (auto-refresh)
150Value editor extras: image preview, JSON/XML format toggle, array elements as grid, "edit array values as text"
151Aggregate view (+ custom aggregator scripts)
152Charts (bar, pie, area, line, scatter, bubble, stock, area range, histogram; series; PNG export)
153Filter/sort history dropdown
154Client-side sort toggle ("Sort via ORDER BY" off)
155Reorder columns by drag; Reset View
156Set Highlighting Language per column/cell (HTML, JSON, XML, RegExp, ...)
157Change Display Type for binary values
158Quick Documentation on a cell (long text, related record preview)
159Data view settings: temporal time zone, custom date/time formats, decimal & grouping separators, number pattern, Infinity/NaN rendering
160Import extras: write errors to file, insert inconvertible values as NULL, disable indexes & triggers / lock table, encoding picker, first-column-is-header
161Data loaders: open/import Excel, JSON, Parquet, Shapefile as tables; custom Groovy loaders
162Edit CSV/TSV files as tables (Text/Data tabs, format config, sort, hide/move columns, export, import to DB)
163Non-strict FK suggestions by column-name matching
164Window function completion inserts
OVER(); INSERT column/VALUES list completion; new-object completion in ALTER; abbreviation matching165Configurable SQL code style (per driver/data source), keyword case, code-generation name templates for FK/index
166Quick documentation / parameter info in editor
167SQL dialect per global / project / directory / file; Generic SQL to silence syntax errors
168Each derived table should have alias; Missing column aliases; Duplicating column name in SELECT; Column shadowed by alias; Redundant alias expressions
169Redundant ELSE NULL; redundant COALESCE args; redundant ordering direction; redundant/multiple row limiting; CASE vs COALESCE/IF
170Unused CTE; Unused subquery item; Unused variable; Unreachable code; Missing return statement
171Statement with side effects in read-only mode
172Quick-fix interactive preview; Fix all occurrences
173Suppress inspection via comment; severity configuration; inspection profiles/scopes; batch Inspect Code with export
174Extract subquery as CTE
175Select In (Alt+F1) / Go To > Database (Alt+Shift+B) from editor or grid
176Structure tool window for SQL files (statement outline)
177Bookmarks (F11, mnemonic) on database objects
178Create Check constraint
179Create/Modify Database (owner, template, tablespace, grants)
180Create/Modify Schema
181Create/Modify User / Role with Grants pane
182Generate (Alt+Insert) other objects: functions, procedures, triggers, sequences, enums, domains, composite types, materialized views, rules, extensions, ...
183Database Changes tool window (pending edits, Show Diff, Submit, Roll back, Group by)
184Server-side change detection: gutter diff, conflict handling (Force / Abort & Sync / merge), Revert or Keep local, colour states
185DDL data sources (from SQL files, DDL mappings, dump, auto-sync, code-gen settings)
186Virtual foreign keys (manual, regex rules with debugger, store relation from JOIN)
187ER diagram for data source / schema / selected tables (Ctrl+Alt+Shift+U; popup Ctrl+Alt+U)
188Explain Plan (Raw) / Explain Analyse (Raw); Copy Original Query Plan
189Compare Structure With (Ctrl+D): Object Properties diff + DDL diff, show identical, swap origin/target
190Migration script: select changes, options (qualify, constraints, recreate), preview, execute, open in console
191Compare Data (tables/views/result sets) with tolerance, detect column insertion, colour-coded diff
192Options: match case; contains / starts / ends / matches / LIKE pattern; text / FTS-indexed / numeric / all columns; first N matches per table
Occasionalnice to have
0 of 50 supported
193~36 fully supported DBMS + ~19 basic-support (Oracle, SQL Server, MongoDB, Snowflake, Redis, ClickHouse, BigQuery, DuckDB, ...)
194Cloud IAM/OAuth authentication (AWS, Azure, GCP)
195Kubernetes port forwarding tab
196Regex schema pattern filter
197Show template databases (PostgreSQL)
198Copy Data Source to clipboard as XML / Import from Clipboard / import from other tools
199Export/import global data source settings as ZIP
200Show Elements: All Namespaces, Empty Groups, Intermediate Nodes, Generated Objects, Virtual Objects, Query Files
201Node details: Comments Instead of Details; Schema Refresh Time
202View group contents as a table (F4 on family node)
203Force Refresh, Forget This Schema Cache, Dump Metadata Model, Introspector Diagnostic Files, JDBC log, Diagnostic Mode
204Introspection Level submenu (1/2/3 per database/schema, level icons)
205Drag object names from tree into editor
206Console tab name template and default file name settings
207Data source name/icon/search-path colour shown on query files in the file tree
208Local History for consoles
209Read-only lock toggle on console/file
210Run from Structure tool window (statement outline, multi-select)
211Array parameters (comma-separated expansion)
212Services tool window display options (when to show, focus, tab per session, show internal session)
213Delete session; open session in separate tab; Jump to Source
214Geo viewer (WKT/WKB/PostGIS on a map)
215Heatmap colouring (sequential/diverging)
216Quick actions popup toolbar for cells (customisable)
217Open URL / Open File from a cell value
218Read-only lock toggle on a data editor
219Export Table to Clipboard (whole table, ignores page limit)
220Generate UUID
221Load File… into cell / Save LOB… to file
222"Submit changes immediately" setting
223Custom scripted extractors (Groovy/JavaScript)
224Export dialog extras: add row header, add computed/generated columns, add table definition (DDL), output query to separate Excel sheet
225Export several selected tables at once (one file per table)
226Drag a file from Project view onto a table/schema to import
227Custom alias table (table name -> preferred alias)
228Postfix completion (
.cfrom), surround templates, custom templates with variables, template sharing229"Store table relation" intention on a JOIN (Alt+Enter)
230Adding NOT NULL column without default; Index is dependent on column; Auto-increment duplicate; Deprecated type
231Ill-formed date/time literals; Implicit string truncation; Unicode N prefix; Check USING clause columns; Misleading references; Named arguments; positional after named
232SQL dialect detection; No data sources configured; Current console schema not introspected; SQL source modification detection
233Extract variable (routine bodies, Ctrl+Alt+V)
234Extract query as table function (Ctrl+Alt+M)
235Navigation bar (Alt+Home) across data sources and files
236Related Symbol (Ctrl+Alt+Home)
237"Warn when editing outdated DDL"
238Virtual views (saved query shown as an object)
239Virtual columns (computed IDE-only columns)
240Diagram tools: column comments toggle, colours, search (Ctrl+F), zoom/pan, add tables by drag, refresh
241Export: Mermaid, PlantUML, Graphviz DOT, drawio, graphml, IDEA .uml, PNG, print, send to yEd/diagrams.net/Mermaid Live
242Flame graph (Total Cost / Startup Cost)
Out of scopea different product, or a different editor
0 of 10 supported
243JDBC driver management (auto-download, version picker, custom driver jars/class/properties)
244Data source templates saved to JetBrains Account
245Scripted Extensions (Generate POJOs)
246SQL injection into string literals of other languages (completion, parameters, dialect)
247Routine-body inspections: illegal cursor state, suspicious trigger code, transaction statements in triggers, GOTO usage
248Analyze SQL Plan with AI
249PL/SQL debugger (Oracle)
250AI Assistant: generate SQL from prompt, create data source from URL via AI, plan analysis
251MCP server for database tools
252Enable DBMS_OUTPUT (Oracle / Db2)
How things get on this page
The tiers are my judgement of how often a feature is felt in a day's work, so the order will move as I use the thing. I build what I actually use, and the seam exists so the small stuff can never hold up 1.0. If there's something in Database Tools you use every week and it's ranked too low, open an issue and say what it's for.