DataGrip

DataGrip is the database IDE. It supports PostgreSQL, MySQL, Redis, Mongo, Snowflake, BigQuery, and more.

When to Use

• SQL Development: Writing complex queries with auto-complete that knows your schema.
• Data Exploration: Viewing tables, filtering, exporting to CSV/JSON.
• Schema Management: Generating DDL scripts, visualizing diagrams.

Core Concepts

Data Sources

Drivers for connections. Auto-downloads JDBC drivers.

Console

The query editor. Ctrl+Enter executes current statement.