playbooks

home / skills / partme-ai / full-stack-skills / dbeaver

dbeaver skill

/skills/dbeaver

This skill helps you manage databases with DBeaver by guiding connections, SQL editing, data manipulation, and administration tasks.

npx playbooks add skill partme-ai/full-stack-skills --skill dbeaver

Review the files below or copy the command above to add this skill to your agents.

Files (2)
SKILL.md
686 B
---
name: dbeaver
description: Provides comprehensive guidance for DBeaver database tool including database connection, SQL editor, data management, and database administration. Use when the user asks about DBeaver, needs to manage databases with DBeaver, execute SQL queries, or work with DBeaver features.
license: Complete terms in LICENSE.txt
---

## When to use this skill

Use this skill whenever the user wants to:
- [待完善：根据具体工具添加使用场景]

## How to use this skill

[待完善：根据具体工具添加使用指南]

## Best Practices

[待完善：根据具体工具添加最佳实践]

## Keywords

[待完善：根据具体工具添加关键词]

Overview

This skill provides practical, hands-on guidance for using DBeaver, the multi-platform database management tool. It covers connecting to databases, configuring drivers, using the SQL editor, importing/exporting data, and basic database administration. The guidance focuses on tasks you can perform quickly in DBeaver and common troubleshooting steps. Ideal for developers, DBAs, and analysts who want actionable steps rather than conceptual theory.

How this skill works

I inspect your goal (connect, query, migrate, or manage) and provide step-by-step actions tailored to DBeaver’s UI and features. Guidance includes connection string examples, driver setup, SQL editor tips (query formatting, parameter binding, explain plans), data import/export procedures, and schema management tasks. I also offer troubleshooting for common errors, configuration suggestions, and shortcuts to speed routine workflows.

When to use it

  • Setting up a new database connection or configuring JDBC/ODBC drivers
  • Writing, formatting, and running SQL queries with the SQL editor
  • Importing or exporting table data (CSV, Excel, SQL dumps) between databases
  • Exploring schema objects, editing rows, and managing indexes or constraints
  • Troubleshooting connection failures, driver issues, or performance bottlenecks

Best practices

  • Install and update the correct JDBC driver for your database and match driver version to server version
  • Use connection templates and secure password storage (DBeaver’s secure vault or external secrets)
  • Run large data exports/imports via CSV or database-native dump tools rather than the grid editor
  • Use the SQL editor’s formatting, parameters, and execution plan features before running expensive queries
  • Work in transactions for destructive changes and keep backups or snapshots before schema migrations

Example use cases

  • Create a new PostgreSQL connection, configure SSL, and run a test query
  • Import a CSV into a MySQL table with column mapping and type casting
  • Compare two schemas and generate a migration script to synchronize changes
  • Profile a slow query using EXPLAIN and suggest index improvements
  • Export selected tables to a SQL dump for transfer to another environment

FAQ

Can DBeaver connect to cloud databases like AWS RDS or Azure?

Yes. Use the appropriate JDBC driver, enable SSL if required, and supply the cloud instance endpoint and credentials. DBeaver supports connection properties for common cloud providers.

How do I run parameterized queries in DBeaver?

Use question-mark or named parameters supported by your DB, then run the query and DBeaver will prompt for parameter values or allow binding through the UI.