JetBrains Plugin 2.0.1 free

Execute CTEs step by step — right in your IDE.

cteXecutor automatically detects Common Table Expressions in your SQL and lets you run or copy individual CTEs with a single shortcut — no manual extraction needed.

Install Plugin View on GitHub free forever

⭐ 3 stars · IntelliJ IDEA & DataGrip 2023.1+ · 2.0.1

Features

Everything you need

Automatic CTE detection

Instantly detects all CTEs in your WITH clause and shows them in an interactive popup.

Execute from Here

Run any subselect — not just CTEs. Automatic dependency resolution includes required CTEs.

Visual highlighting

Selected CTEs are highlighted in the editor so you always know what will be executed.

Keyboard-first workflow

Ctrl+# → Space to run, → Enter to execute from here, → C to copy, → W to edit and run.

Auto cleanup

Inserted SQL is automatically removed after execution — no manual cleanup.

Zero overhead

Runs efficiently in the background. No performance impact, no telemetry.

Installation

Up and running in 2 minutes

Open IntelliJ IDEA or DataGrip

Go to Settings → Plugins → Marketplace.

Search for cteXecutor

Type "cteXecutor" and click Install, then restart your IDE.

Open a SQL file with CTEs

Open any query that uses WITH … AS (…) clauses.

Use Ctrl+# → Space

Select a CTE from the popup and it executes with automatic cleanup.

Install from Marketplace Read the docs →

Changelog

Releases

All releases ↗

v2.0.1 October 2025

fix Minor stability improvements

v2.0.0 2025

feat Execute from Here — run any subselect with dependency resolution

feat Smart detection across nested queries and SELECT statements

feat Interactive selection for execution starting points

v1.0.0 2024

feat Automatic CTE detection and interactive popup

feat Visual highlighting of selected CTEs

feat Execute and copy-to-clipboard support

feat Keyboard shortcuts (Ctrl+# combinations)

Ready to try it?

Install cteXecutor from the JetBrains Marketplace and get started in minutes.

Install Plugin View Source