dbeaver

📁 g1joshi/agent-skills 📅 3 days ago
1
总安装量
1
周安装量
#55224
全站排名
安装命令
npx skills add https://github.com/g1joshi/agent-skills --skill dbeaver

Agent 安装分布

mcpjam 1
claude-code 1
replit 1
junie 1
zencoder 1

Skill 文档

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