-- 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 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 :
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.
-- daily sales report for last week: -- date, total orders, total revenue, average order value Copilot generated:
Github Copilot Datagrip [work] Here
-- 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 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 :
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.
-- daily sales report for last week: -- date, total orders, total revenue, average order value Copilot generated: