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