Dbeaver

🌐Community
by teachingai · vlatest · Repository

Dbeaver allows you to seamlessly manage and interact with databases from a single interface, boosting developer productivity and data access.

Install on your platform

We auto-selected Claude Code based on this skill’s supported platforms.

1

Run in terminal (recommended)

terminal
claude mcp add dbeaver npx -- -y @trustedskills/dbeaver
2

Or manually add to ~/.claude/settings.json

~/.claude/settings.json
{
  "mcpServers": {
    "dbeaver": {
      "command": "npx",
      "args": [
        "-y",
        "@trustedskills/dbeaver"
      ]
    }
  }
}

Requires Claude Code (claude CLI). Run claude --version to verify your install.

About This Skill

What it does

This skill enables an AI agent to interact with and manage databases using Dbeaver, a universal database tool. It allows agents to configure database connections (supporting types like MySQL, PostgreSQL, Oracle, and MongoDB), write and execute SQL queries, export data in various formats, import data into tables, and generate Entity-Relationship (ER) diagrams for visualizing table relationships. Essentially, it provides comprehensive database management capabilities within the agent's workflow.

When to use it

  • You need to configure a new connection to a specific database type (e.g., PostgreSQL).
  • You want to execute SQL queries and analyze results directly from the AI agent.
  • You require exporting data from a table into formats like CSV, JSON, or Excel.
  • You need to import data from files into existing database tables.
  • You want to visualize the relationships between tables in a database using an ER diagram.

Key capabilities

  • Connection Management: Configure and manage connections to various databases.
  • SQL Query Execution: Write, execute, and analyze SQL queries within Dbeaver’s editor.
  • Data Export: Export data to CSV, JSON, SQL INSERT statements, or Excel formats.
  • Data Import: Import data from files into database tables.
  • ER Diagram Generation: Generate visual representations of table relationships (ER diagrams).
  • Driver Management: Automatically downloads and updates database drivers.

Example prompts

  • "Connect to a PostgreSQL database with host localhost, port 5432, database 'mydb', username 'admin' and password '****'."
  • "Execute the following SQL query: SELECT table_name FROM information_schema.tables."
  • "Export all data from the 'customers' table to a CSV file."

Tips & gotchas

  • Driver Updates: Dbeaver automatically downloads drivers, but periodic updates are recommended for optimal performance and compatibility.
  • Secure Credentials: Enable encrypted password storage within connection properties to protect sensitive information.
  • Transaction Mode: Be mindful of transaction mode, especially in production environments, to prevent unintended data changes.

Tags

🛡️

TrustedSkills Verification

Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.

Security Audits

Gen Agent Trust HubPass
SocketPass
SnykPass

Details

Version
vlatest
License
Author
teachingai
Installs
33

🌐 Community

Passed automated security scans.