Rewrite this using CTEs with clear names Copilot reformats it into readable WITH clauses. Writing insert scripts for a dozen columns? Start with:
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 : github copilot datagrip
-- daily sales report for last week: -- date, total orders, total revenue, average order value Copilot generated: 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: Staring at a 10-year-old stored procedure
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.
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.