Full-stack-skills dbeaver

Guides DBeaver usage for database connection management, SQL development, data import/export, and ER diagram generation across MySQL, PostgreSQL, Oracle, MongoDB, and other databases. Use when the user needs to configure DBeaver connections, write queries in the SQL editor, export data, or generate ER diagrams.

install

source · Clone the upstream repo

git clone https://github.com/partme-ai/full-stack-skills

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/partme-ai/full-stack-skills "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/database-skills/dbeaver" ~/.claude/skills/partme-ai-full-stack-skills-dbeaver && rm -rf "$T"

manifest: skills/database-skills/dbeaver/SKILL.md

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

Create a connection - New Connection > Select database type > Configure host/port/credentials > Test Connection
Write SQL - Open SQL Editor (F3) > Write query > Execute (Ctrl+Enter)
Manage data - Right-click table > Export Data or Import Data > Choose format
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

Driver management - DBeaver auto-downloads drivers on first connect; update drivers periodically
Secure credentials - Enable encrypted password storage in connection properties
Transaction mode - Switch to manual commit in production to prevent accidental changes
Result set navigation - Use filters, sorting, and pagination for large result sets
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