datagrip

DataGrip database IDE from JetBrains. Use for database management.

7 stars

byG1Joshi

View on GitHub Installation ↓

Best use case

datagrip is best used when you need a repeatable AI agent workflow instead of a one-off prompt.

DataGrip database IDE from JetBrains. Use for database management.

Teams using datagrip should expect a more consistent output, faster repeated execution, less prompt rewriting.

When to use this skill

You want a reusable workflow that can be run more than once with consistent structure.

When not to use this skill

You only need a quick one-off answer and do not need a reusable workflow.
You cannot install or maintain the underlying files, dependencies, or repository context.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/datagrip/SKILL.md --create-dirs "https://raw.githubusercontent.com/G1Joshi/Agent-Skills/main/skills/tools/datagrip/SKILL.md"

Manual Installation

Download SKILL.md from GitHub
Place it in .claude/skills/datagrip/SKILL.md inside your project
Restart your AI agent — it will auto-discover the skill

How datagrip Compares

Feature / Agent	datagrip	Standard Approach
Platform Support	Not specified	Limited / Varies
Context Awareness	High	Baseline
Installation Complexity	Unknown	N/A

Frequently Asked Questions

What does this skill do?

DataGrip database IDE from JetBrains. Use for database management.

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

SKILL.md Source

# 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.

### Introspection

It downloads metadata about tables/columns so auto-complete works offline.

## Best Practices (2025)

**Do**:

- **Use "Compare Structure"**: Diff two databases (e.g. Prod vs Staging) and generate migration scripts.
- **Use Visualizer**: Right click a result set -> "Show Visualization" (Charts).
- **Use Color Settings**: Set "Prod" transparent red to avoid accidental drops.

**Don't**:

- **Don't `UPDATE` without `WHERE`**: DataGrip warns you. Listen to it.

## References

- [DataGrip Documentation](https://www.jetbrains.com/datagrip/documentation/)