AI Assistant in DataGrip

Empower your database workflow!

AI Assistant employs multiple large language models and transparently makes them work for you.

It is powered by OpenAI and Google as the primary third-party providers.

Schema-aware AI chat

Using the AI chat inside DataGrip has one important advantage: AI Assistant knows your database! You can refer to objects without having to give additional context. All you need to do is attach the schema to the chat.

The sky is the limit when it comes to what you can do, but here are just a couple of examples for inspiration:

Curious about which tables contain BLOB columns?

Want to find out which film has the largest cast?

Text-to-SQL

Of course, you can talk to your database in more than just the chat. You can also simply formulate your queries within the query console in natural language!

Any language works! Chinese, German – use whatever is most convenient for you!

The query console is also aware of the database schema, so the generated query is crafted with an understanding of the context.

Fix SQL errors

Sometimes you may still want to create queries yourself. Do you remember all the tiny differences between SQL dialects? If not, AI Assistant will help you out here as well.

AI Assistant can fix any error in your SQL query – give it a try!

Don’t remember the proper keyword? Fixed!

Don’t remember a column name? Fixed!

Simply have no clue what is wrong with the query? Fixed!

More tasks for AI Assistant

Convert SQL to another dialect

Manual rewriting is no longer necessary when migrating your database from Oracle to PostgreSQL.

Plans and Pricing

Advanced

Pro

AI-powered coding companion for all IDEs with the JetBrains AI service

$8.33

/per month

(billed annually at $100.00)

Limited

Trial

All AI features from the Pro plan with limitations on time and usage volume

Free

Trial lasts 7 days