whodb

Explore schemas, inspect tables, and execute SQL queries across multiple database engines.

196|20|Updated Jan 17, 2026
One-click install
npx skills add https://github.com/xiaoyuge886/aigc --skill whodb-xiaoyuge886
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: whodb
Source: https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/whodb
Command: npx skills add https://github.com/xiaoyuge886/aigc --skill whodb-xiaoyuge886

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill eliminates the complexity of manual database exploration and SQL query construction by providing a unified interface to interact with various database systems.

Core Features & Use Cases

  • Schema Discovery: Automatically map out database structures, including schemas, tables, and column definitions.
  • Intelligent Querying: Execute SQL queries safely with built-in support for result limiting and formatting.
  • Use Case: A developer needs to quickly inspect a production PostgreSQL database to debug a data issue; they can use this skill to list tables, describe columns, and run a safe, limited query to verify the data without leaving the chat interface.

Quick Start

Use the whodb skill to list all tables in the public schema of the production database and then query the top 5 records from the users table.

Frequently Asked Questions about whodb

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

FAQPage Schema
How do I explore database schema and inspect tables across different database engines?

Database schema exploration is unified through a single interface that automatically maps schemas, tables, and column definitions. It supports PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Elasticsearch, and ClickHouse.

Can I run SQL queries safely to debug data issues directly within my chat interface?

SQL queries can be executed safely with built-in result limiting and formatting. This allows developers to inspect production databases, list tables, and verify records without leaving the chat interface.

Does this database query assistant work with both SQL and NoSQL environments?

Yes, the database query assistant supports both SQL and NoSQL environments. It connects to PostgreSQL, MySQL, SQLite, MongoDB, Redis, Elasticsearch, and ClickHouse for structural analysis and data retrieval.

What is the best way to list all tables in a public schema and query top records?

The best way to list tables and query records is using the unified database interface. You can list tables in a specific schema and execute a limited query to retrieve the top records from any table.

How do I manage multiple database connections without switching between separate client tools?

Managing multiple database connections is handled through MCP tools and CLI-based commands. This provides a unified interface for secure data retrieval and structural analysis across all supported database engines.

Are there limitations when executing queries on production databases?

Query execution on production databases is constrained by built-in result limiting to ensure safety. This prevents large data pulls while still allowing structural analysis and safe data verification.