Agent-Skills.md

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

UncategorizedID: teachingai/full-stack-skills/dbeaver

Repository

teachingai/full-stack-skills
partme-aiLicense: NOASSERTION
20635

Install this agent skill to your local

pnpm dlx add-skill https://github.com/partme-ai/full-stack-skills/tree/HEAD/skills/database-skills/dbeaver

Skill Files

Browse the full folder contents for dbeaver.

Download Skill

Loading file tree…

skills/database-skills/dbeaver/SKILL.md

Skill Metadata

Name
dbeaver
Description
"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."

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