Skip to main content

DBHub Database Query Guide

Skill Verified Active

Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.

Purpose

To enable users to safely and efficiently explore database schemas and run SQL queries using DBHub's MCP tools, preventing common errors and promoting a structured workflow.

Features

  • Explore database schemas with `search_objects`
  • Execute SQL queries with `execute_sql`
  • Supports multiple databases and connections
  • Guides an 'explore-then-query' workflow
  • Provides error recovery steps for common database issues

Use Cases

  • When needing to understand a database structure before writing a query
  • When asked to retrieve specific data from a database
  • When needing to run a specific SQL statement against a database
  • When encountering errors during database operations

Non-Goals

  • Guessing table or column names without verification
  • Dumping entire schemas upfront without progressive disclosure
  • Using the wrong tool in multi-database setups
  • Blindly retrying failed queries without investigation

Workflow

  1. Discover available schemas
  2. Find relevant tables using patterns if necessary
  3. Inspect table structure (columns, indexes)
  4. Write and execute the precise SQL query

Practices

  • Database schema exploration
  • SQL query execution
  • Safe database interaction workflow

Installation

npx skills add bytebase/dbhub

Runs the Vercel skills CLI (skills.sh) via npx — needs Node.js locally and at least one installed skills-compatible agent (Claude Code, Cursor, Codex, …). Assumes the repo follows the agentskills.io format.

Quality Score

Verified
100 /100
Analyzed about 23 hours ago

Trust Signals

Last commit23 days ago
Stars2.7k
LicenseMIT
Status
View Source

Similar Extensions

Dsql

100

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.

Skill
awslabs

Migrate Validate

100

Validate pending migrations for foreign key consistency, rollback safety, and best practices

Skill
ruvnet

Sql Optimization

100

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.

Skill
github

Migrate Create

99

Create a new sequentially numbered database migration with up/down SQL files

Skill
ruvnet

Agentdb Query

99

Query AgentDB through the controller bridge -- semantic routing, hierarchical recall, causal graphs, context synthesis, pattern store/search

Skill
ruvnet

MySQL Read Only Query Skill

99

Execute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

Skill
sanjay3290

© 2025 SkillRepo · Find the right skill, skip the noise.