Master DataGrip: Essential Tips for Efficient MySQL & MongoDB Management

Download

Download DataGrip from the official JetBrains website: https://www.jetbrains.com/datagrip/

Appearance Settings

Adjust the IDE font size via File->Settings → Appearance & Theme, and the editor font size via Editor->Font.

Create Data Source

To work with a database, first create a data source. Click the plus sign → Data Source->MySQL, fill in the connection details, and add the missing serverTimezone parameter (e.g., Asia/Shanghai) in the Advanced options before testing the connection.

Table Management

After a successful connection, all tables appear in the left pane.

Right‑click a table → Modify Table to view its definition.

Double‑click a table to browse its data with pagination.

Hide unwanted columns via the column‑header context menu.

Use the filter bar to write WHERE clauses for data filtering.

Right‑click the database name → New Table to create a table, add columns, and preview the generated SQL.

Export data to CSV, HTML, Excel, JSON, and other formats.

SQL Editing Tips

Open a query console with Right‑click → Open Query Console.

Enjoy intelligent code completion for tables, columns, and SQL keywords.

Replace * with explicit columns by selecting * and pressing Alt+Enter.

When a table alias is used, press Alt+Enter to prepend the alias to all selected columns.

For INSERT INTO statements, use the intention action to generate the column list automatically.

Hover over functions to see detailed documentation.

Format SQL with Ctrl+Alt+L.

View execution logs and local history via Right‑click → Local History->Show History.

Run Explain Plain on a statement to view its execution plan.

MongoDB Support

Create a MongoDB data source via the plus sign → Data Source->MongoDB, configure the connection, test it, browse collections, set filter conditions, and insert documents.

Conclusion

This guide covers the most common operations and handy shortcuts for managing MySQL and MongoDB databases with DataGrip, enabling users familiar with other JetBrains tools to become productive quickly.