skills.rest
clidey
clideyOFFICIAL
Explore all skills by this author →
Website𝕏@clideyofficialGitHub

whodb

Manage database connections, run queries, and explore schemas across multiple engines.

5.0k|237|Updated Jun 11, 2024
Search Tags:#database#queries#CLI#PostgreSQL#MySQL#data-analysis#schema-exploration
One-click install
npx skills add https://github.com/clidey/whodb --skill whodb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: whodb
Source: https://github.com/clidey/whodb/tree/main/cli/external-plugin/whodb/skills/whodb
Command: npx skills add https://github.com/clidey/whodb --skill whodb

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides a unified toolset to manage and query databases from a single interface, enabling faster data access and insight without writing bespoke scripts.

Core Features & Use Cases

  • Connection management: list, inspect, and manage database connections across engines.
  • Query & schema exploration: execute SQL, discover schemas, and inspect tables/columns.
  • Data analysis & cross-engine tasks: support for PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Elasticsearch, and ClickHouse.
  • Use Case: Quickly validate schemas and retrieve sample data for reporting across multiple databases.

Quick Start

List connections with whodb_connections, then:

  • whodb_schemas(connection="name")
  • whodb_tables(connection="name", schema="public")
  • whodb_columns(connection="name", table="users")

Frequently Asked Questions about whodb

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run SQL queries across multiple database engines like PostgreSQL and MySQL?▼

You can run SQL queries across PostgreSQL, MySQL, MariaDB, and SQLite by listing available connections first, then executing queries through a unified interface without writing bespoke scripts.

Can I explore database schemas and inspect table columns from a single CLI?▼

Yes, you can explore database schemas and inspect table columns from a single CLI by discovering schemas, listing tables, and retrieving column details across supported engines.

Does this database CLI tool support NoSQL and search engines like MongoDB, Redis, and Elasticsearch?▼

Yes, this database CLI tool supports NoSQL and search engines including MongoDB, Redis, and Elasticsearch, allowing you to manage connections and inspect data alongside relational databases.

What is the best way to validate schemas and retrieve sample data for reporting across different databases?▼

The best way to validate schemas and retrieve sample data for reporting is to use a unified database interface that supports cross-engine schema discovery and data inspection for PostgreSQL, MySQL, MongoDB, and ClickHouse.

Do I need to install separate client libraries to connect to ClickHouse and MariaDB?▼

No, you do not need separate client libraries to connect to ClickHouse and MariaDB; the unified interface handles connection management and query execution with MCP tools and CLI fallbacks.

Why use a unified database interface instead of individual CLI clients for schema exploration?▼

A unified database interface solves the problem of fragmented database access by replacing multiple individual CLI clients with a single tool for connection listing, schema discovery, and data inspection.

Related Skills

Explore More Software Engineering Skills→
heinschulieheinschulie

database

Provision managed PostgreSQL, Redis, MySQL, and MongoDB databases via Railway templates.

Community
Intermediate
promptrankspromptranks

prk-psv-export

Export validated PSV samples to SQL or JSON for database import.

Official
Intermediate
9Ashwin9Ashwin

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and statistical summaries.

Community
Advanced
bughqbughq
2

stacks-database

Manage database lifecycle operations for Stacks applications across multiple SQL dialects.

Official
Advanced