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
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. Rewrite this using CTEs with clear names Copilot
-- daily sales report for last week: -- date, total orders, total revenue, average order value Copilot generated: Have you tried Copilot in DataGrip
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 :
-- 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:
-- 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: