Pricing information for DataGrip is supplied by the software provider or retrieved from publicly accessible pricing materials. Final cost negotiations to purchase DataGrip must be conducted with the seller. Pricing information was last updated on March 12, 2018. JetBrains DataGrip Explain Plan.
Meet DataGrip, our new database IDE that is tailored to suit the specific needs of professional SQL developers.
Intelligent query console
Allows you to execute queries in different modes and provides a local history that keeps track of all your activity and protects you from losing your work.
Efficient schema navigation
Lets you jump to any table, view, or procedure by its name via the corresponding action, or directly from its usages in the SQL code.
Explain plan
Gives you an extended insight into how your queries work and into the database engine behavior, so you can make your queries more efficient.
Smart code completion
DataGrip provides context-sensitive code completion, helping you to write SQL code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in code you're editing.
On-the-fly analysis and quick-fixes
DataGrip detects probable bugs in your code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, using keywords as identifiers and always offers a way to fix the problems.
Refactorings that work in SQL files and schemas
DataGrip correctly resolves all references in your SQL code and helps you refactor them. When you rename a variable or an alias, it will update their usages throughout the entire file. The actual table names in the database are updated when you rename references to them from your queries. There is even a preview of usages of tables/views inside other views, stored procedures and functions.
Version control integration
We provide unified support for all major version control systems: Git, SVN, Mercurial and many others.
Join Our Customers
Companies all over the world use DataGrip. Join them and get the best development experience.
Database
management systems
Is your favourite database missing?
In this article I will show you how to view stored procedure/function definition using DataGrip tool.
In toolbar navigate to View -> Tool Windows -> Database or press Alt + 1 key combination.
Fig.1. Database in View menu
Datagrip Er Diagram
In opened explorer expand [your database], [your schema] and routines branch. Find interesting procedure/function, than right click on it and select SQL Scripts.
Fig. 2. SQL Scripts options
In SQL Scripts select one of the following:
Datagrip Show Session Panel
- Source Editor - to open trigger code with all properties statements in editor
- SQL Generator… - to open SQL Generator window, which allows generate different types of SQL (e.g. routine definition)
Fig. 3. SQL Generator window and options
Datagrip Community
- Request and Copy Original DDL - to copy only routine DDL statement without additional statements (only
CREATE PROCEDURE/CREATE FUNCTION) - Generate DDL to Clipboard - to copy routine DDL statement with additional statements (like
exec sp_addextendedpropertyin SQL Server) - Generate DDL to Console - to open routine DDL statement with additional statements in database console