Copilot Datagrip | Github

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.

-- 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: github copilot 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 : Next time you’re stuck writing a recursive CTE

-- daily sales report for last week: -- date, total orders, total revenue, average order value Copilot generated: Let me know in the comments