dbeaver

When to use this skill

Use this skill whenever the user wants to:

• Configure DBeaver database connections (MySQL, PostgreSQL, Oracle, MongoDB, etc.)
• Write and execute SQL queries in the DBeaver SQL editor
• Export data to CSV, JSON, SQL, or Excel formats
• Import data from files into database tables
• Generate ER diagrams to visualize table relationships
• Manage multiple database connections, bookmarks, and drivers

How to use this skill

Workflow

1. Create a connection - New Connection > Select database type > Configure host/port/credentials > Test Connection
2. Write SQL - Open SQL Editor (F3) > Write query > Execute (Ctrl+Enter)
3. Manage data - Right-click table > Export Data or Import Data > Choose format
4. Generate ER diagram - Right-click schema > View Diagram > Arrange tables

Quick-Start Example: Connect and Query

1. File > New > Database Connection
2. Select "PostgreSQL" > Enter:
   Host: localhost
   Port: 5432
   Database: mydb
   Username: admin
   Password: ****
3. Click "Test Connection" to verify
4. Open SQL Editor (F3), run:
   SELECT table_name, pg_size_pretty(pg_total_relation_size(table_name::text))
   FROM information_schema.tables
   WHERE table_schema = 'public'
   ORDER BY pg_total_relation_size(table_name::text) DESC;

Data Export

Right-click table > Export Data >
  Format: CSV / JSON / SQL INSERT / Excel
  Options: Set delimiter, encoding, header row
  Target: File or clipboard

Best Practices

1. Driver management - DBeaver auto-downloads drivers on first connect; update drivers periodically
2. Secure credentials - Enable encrypted password storage in connection properties
3. Transaction mode - Switch to manual commit in production to prevent accidental changes
4. Result set navigation - Use filters, sorting, and pagination for large result sets
5. Keyboard shortcuts - Ctrl+Enter to execute, Ctrl+Shift+E to explain plan, F3 for SQL editor

Keywords

dbeaver, database, SQL, PostgreSQL, MySQL, Oracle, MongoDB, 数据库管理, SQL editor, ER diagram, data export, data import, database tool