# Dbeaver

> DBeaver universal database tool. Use for database management.

- Skill: `majiayu000/dbeaver` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/dbeaver`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/dbeaver/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: AI & ML
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/dbeaver

---


# DBeaver

DBeaver is the free, open-source universal database manager. 2025 updates add **Gemini AI** integration to write SQL for you.

## When to Use

- **Universal Access**: Connect to Oracle, DB2, MySQL, PostgreSQL, and SQLite in one app.
- **ER Diagrams**: Generates Entity-Relationship diagrams from existing schemas.
- **Data Transfer**: Powerful import/export wizard (CSV, Excel).

## Core Concepts

### Drivers

Downloads JDBC drivers on demand.

### Projects

Organize connections and scripts into projects.

### Spatial View

Visualizes GIS data on a map.

## Best Practices (2025)

**Do**:

- **Use AI Assistant**: "Show me users capable of admin" -> Generates SQL.
- **Use Mock Data Generator**: Populate tables with realistic dummy data for testing.
- **Transaction Mode**: Set connection to "Manual Commit" for production DBs to avoid accidents.

**Don't**:

- **Don't run heavy queries on prod**: DBeaver can hang if you fetch 1M rows. Use "Result Set Fetch Size".

## References

- [DBeaver Documentation](https://dbeaver.com/docs/wiki/)