Github Copilot Datagrip Today

Rewrite this using CTEs with clear names Copilot reformats it into readable WITH clauses. Writing insert scripts for a dozen columns? Start with:

Next time you’re stuck writing a recursive CTE or a PIVOT , just type a comment and let Copilot do the heavy lifting. Have you tried Copilot in DataGrip? What’s your favorite use case? Let me know in the comments. github copilot datagrip

-- Rank products by sales per category Copilot writes the RANK() OVER (PARTITION BY category ORDER BY sales DESC) correctly, saving you from syntax searches. Highlight a 20-line nested subquery. Press Ctrl + Enter (or Cmd + Enter on Mac) and ask: Rewrite this using CTEs with clear names Copilot

-- Get all customers who placed orders in the last 30 days with total > $500 Copilot suggests the full SELECT ... JOIN ... WHERE ... GROUP BY instantly. It reads your schema context (if you’ve connected a database) and proposes column names from your actual tables. Forgot the syntax for ROW_NUMBER() partition? Type the goal: Have you tried Copilot in DataGrip

If you spend your days jumping between application code (VS Code/IntelliJ) and database queries (DataGrip), you’ve probably wished for the same AI assistance inside your SQL editor. Good news: GitHub Copilot works in DataGrip , and it changes how you explore, debug, and document databases.

-- daily sales report for last week: -- date, total orders, total revenue, average order value Copilot generated:

INSERT INTO users (name, email, role, created_at, updated_at) Copilot suggests the rest of the columns and even generates sample test data. Staring at a 10-year-old stored procedure? Highlight it and use Ctrl + Enter :