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 · 2.0.1 · IntelliJ IDEA & DataGrip 2023.1+
cteXecutor in action — CTE detection and execution
cteXecutor in action — CTE detection and executioncteXecutor screenshot 1cteXecutor screenshot 2cteXecutor screenshot 3
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

1
Open IntelliJ IDEA or DataGrip
Go to Settings → Plugins → Marketplace.
2
Search for cteXecutor
Type "cteXecutor" and click Install, then restart your IDE.
3
Open a SQL file with CTEs
Open any query that uses WITH … AS (…) clauses.
4
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 ↗
3.0.2 May 3, 2026
Upgrade necessary version
3.0.1 May 3, 2026
Replace deprecated `ActionUtil.performActionDumbAwareWithCallbacks` with `ActionUtil.performAction`
2.0.1 Oct 27, 2025
fix problems of new ExecuteFromHere, where execution of dependencies did not properly work
fix problem of execution being part of the do and undo process of IDE, which lead to problems
Upgrade necessary version
2.0.0 Oct 25, 2025
feat "Execute from Here" action with smart dependency resolution
Execute SQL from anywhere - inside CTEs, subqueries, or main queries
Automatically detects and includes all required CTEs and dependencies
Interactive popup showing execution options and affected elements
Keyboard shortcut: Ctrl+# then Enter
break "Run CT-Query" shortcut changed from Ctrl+# Enter to Ctrl+# Space
1.1.3 Jul 28, 2025
change color of selected code to standard of jetbrains execution
add padding for options in popup
fix wrong title for copy and edit popup
1.1.1 Jul 9, 2025
fix problem with not taking every next element up to comma, so don't expect the next to be a comma anymore
delete everything to the end of the document, for safety reasons
changed shortcuts to number sign instead of r
1.1.0 Jul 8, 2025
Added "Copy and Edit SQL" action, allowing you to append WHERE clauses or other modifications at the end of CTE queries
Refactored code structure to reduce duplication
Renamed actions for improved clarity and usability

Ready to try it?

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

Install Plugin View Source