mcpField
D
dbeaver

dbeaver

github.com/partme-aiData & databases71674 installsUpdated 3w ago
Repository

About dbeaver

A reference skill for using DBeaver to work with databases. It covers connection setup, SQL queries, data import and export, ER diagrams, and connection management.

Key features

  1. 01Database connection setup
  2. 02SQL editing and execution
  3. 03Data import and export
  4. 04ER diagram generation
  5. 05Connection and driver management

Use cases

  1. 01Connect to a database
  2. 02Run and inspect SQL queries
  3. 03Move data between files and tables
  4. 04Visualize schema relationships

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/partme-ai/full-stack-skills --skill dbeaver

After installing, type/dbeaverin Claude Code to confirm it loaded.

Bundled filesLICENSE.txt

Details

From the project README

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

Comments

Markdown supported