whodb

Name: whodb
Availability: InStock
Author: Clidey

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

Ready to run

npx skills add https://github.com/clidey/whodb --skill whodb

💬 Prompt for ChatGPT / Claude Chat▼

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.