Database Expert
cin12211/orca-q
Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration.
Database operations including querying, schema exploration, and data analysis.
Install Whodb
$ npx skills add xiaoyuge886/aigc --skill whodb -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install xiaoyuge886/aigc whodb --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/whodb .claude/skills/whodb && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "whodb" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/whodb into .claude/skills/whodb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "whodb", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/whodbType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add xiaoyuge886/aigc --skill whodb -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install xiaoyuge886/aigc whodb --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/whodb .agents/skills/whodb && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "whodb" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/whodb into .agents/skills/whodb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "whodb", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add xiaoyuge886/aigc --skill whodb -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install xiaoyuge886/aigc whodb --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/whodb .cursor/skills/whodb && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "whodb" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/whodb into .cursor/skills/whodb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "whodb", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/xiaoyuge886/aigc.git --path .claude/skills/whodb--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add xiaoyuge886/aigc --skill whodb -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install xiaoyuge886/aigc whodb --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/whodb .gemini/skills/whodb && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "whodb" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/whodb into .gemini/skills/whodb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "whodb", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install xiaoyuge886/aigc whodbInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add xiaoyuge886/aigc --skill whodb -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/whodb .github/skills/whodb && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "whodb" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/whodb into .github/skills/whodb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "whodb", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add xiaoyuge886/aigc --skill whodb -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install xiaoyuge886/aigc whodb --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/whodb .opencode/skills/whodb && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "whodb" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/whodb into .opencode/skills/whodb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "whodb", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
whodb- GitHub stars
- 198
- Token cost
- ~894 tokens
- SKILL.md length
- 208 words
- Files
- 1
- Skills in repo
- 9
- Repo updated
- First seen
- Licence
- MIT
At a glance
Database operations including querying, schema exploration, and data analysis.
- Works in 5 steps: List connections: whodb_connections → List schemas:… → List tables:… → …
- Tasks that involve NoSQL databases
- SKILL.md covers MCP Tools (Preferred), CLI Commands (Fallback), Workflow Examples and Best Practices
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Whodb is an agent skill from xiaoyuge886/aigc. Database operations including querying, schema exploration, and data analysis. Activates for tasks involving PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Elasticsearch, or ClickHouse databases.
Its SKILL.md is about 890 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Databases, covering NoSQL databases, Database administration and Search implementation. It works with ClickHouse, Elasticsearch, MariaDB and MongoDB. The repository describes itself as: AIGC 智能 Agent 平台是一个强大的 AI 应用框架，通过集成 Claude AI 模型和丰富的技能生态系统，为用户提供智能化、场景化的 AI 解决方案。平台采用前后端分离架构，支持多租户、会话管理、技能扩展等企业级特性。 The licence is MIT.
When your agent uses it
- Tasks that involve NoSQL databases
- Tasks that involve Database administration
- Tasks that involve Search implementation
Example prompts
- “/whodb”
Workflow steps
5 steps, taken from the first numbered list in SKILL.md.
- List connections: whodb_connections
- List schemas: whodb_schemas(connection="name")
- List tables: whodb_tables(connection="name", schema="public")
- Describe table: whodb_columns(connection="name", table="users")
- Sample data: whodb_query(connection="name", query="SELECT * FROM users LIMIT 5")
What it can do on your machine
Read from SKILL.md and the folder at commit e970014. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are bash).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Whodb loads about 894 tokens when it runs. Until then it costs about 52 tokens; SKILL.md has 208 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from xiaoyuge886/aigc at commit e970014, republished under its MIT licence (© xiaoyuge886). 208 words, ~894 tokens.
Download SKILL.mdSave it as
.claude/skills/whodb/SKILL.md (or your agent's skills folder).- name
- whodb
- description
- Database operations including querying, schema exploration, and data analysis. Activates for tasks involving PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Elasticsearch, or ClickHouse databases.
WhoDB Database Assistant
You have access to WhoDB for database operations. Use these tools and commands to help users with database tasks.
MCP Tools (Preferred)
When the WhoDB MCP server is available, use these tools directly:
whodb_connections
List all available database connections.
No parameters required.
Returns: List of connection names with type and source (env/saved).whodb_query
Execute SQL queries against a database.
Parameters:
- connection: Connection name (optional if only one connection exists)
- query: SQL query to execute
Example: whodb_query(connection="mydb", query="SELECT * FROM users LIMIT 10")whodb_schemas
List all schemas in a database.
Parameters:
- connection: Connection name (optional if only one connection exists)
Example: whodb_schemas(connection="mydb")whodb_tables
List all tables in a schema.
Parameters:
- connection: Connection name (optional if only one connection exists)
- schema: Schema name (optional, uses default if not specified)
Example: whodb_tables(connection="mydb", schema="public")whodb_columns
Describe columns in a table.
Parameters:
- connection: Connection name (optional if only one connection exists)
- table: Table name (required)
- schema: Schema name (optional)
Example: whodb_columns(connection="mydb", table="users")CLI Commands (Fallback)
If MCP tools are unavailable, use the CLI directly via Bash:
Query Execution
whodb-cli query "SELECT * FROM users LIMIT 10" --connection mydb --format jsonSchema Discovery
# List schemas
whodb-cli schemas --connection mydb --format json
# List tables
whodb-cli tables --connection mydb --schema public --format json
# Describe columns
whodb-cli columns --connection mydb --table users --format jsonConnection Management
# List connections
whodb-cli connections list --format json
# Test connection
whodb-cli connections test mydb
# Add new connection (interactive)
whodb-cli connections add --name mydb --type Postgres --host localhost --database mydbData Export
# Export to CSV
whodb-cli export --connection mydb --table users --output users.csv
# Export query results
whodb-cli export --connection mydb --query "SELECT * FROM orders" --output orders.xlsxWorkflow Examples
Explore a New Database
- List connections:
whodb_connections - List schemas:
whodb_schemas(connection="name") - List tables:
whodb_tables(connection="name", schema="public") - Describe table:
whodb_columns(connection="name", table="users") - Sample data:
whodb_query(connection="name", query="SELECT * FROM users LIMIT 5")
Answer Data Questions
- Understand the schema first - check table structure
- Write targeted queries with appropriate filters
- Always use LIMIT for exploratory queries
- Present results in a clear, readable format
Best Practices
- Always explore schema first before writing queries
- Use LIMIT for exploratory queries to avoid overwhelming output
- Prefer specific columns over SELECT * for clarity
- Check foreign keys via whodb_columns to understand relationships
- Use JSON format (--format json) when parsing output programmatically
- Never expose credentials - use connection names, not connection strings
© xiaoyuge886, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
Just SKILL.md in .claude/skills/whodb of xiaoyuge886/aigc.
Open the folder on GitHubat commit e970014
Compare with similar skills
Whodb next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Whodb this skillxiaoyuge886/aigc | 198 | — | ~894 | Automated safety check: Pass | MIT | |
| Database Expertcin12211/orca-q | 224 | — | ~2.8k | Automated safety check: Pass | MIT | |
| Mirrord DB Branchingmetalbear-co/mirrord | 5.4k | — | ~14k | Automated safety check: Pass | MIT | |
| DB SculptorEliasOulkadi/shokunin | 114 | — | ~3.1k | Automated safety check: Notes | MIT | |
| Automating Database Backupsjeremylongshore/tons-of-skills-marketplace | 2.8k | — | ~1.5k | Automated safety check: Pass | MIT | |
| How To Communicatedatabasus/databasus | 8.9k | — | ~3.9k | Automated safety check: Pass | MIT |
Similar skills
Mirrord DB Branching
metalbear-co/mirrord
Helps users configure mirrord.json for database branching, enabling isolated database copies for safe development and testing.
DB Sculptor
EliasOulkadi/shokunin
Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…
Automating Database Backups
jeremylongshore/tons-of-skills-marketplace
Automate database backup processes with scheduling, compression, and encryption.
How To Communicate
databasus/databasus
Communicate clearly in every response, progress update and agent-authored document.
Chdb SQL
vemetric/vemetric
A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse…
More from xiaoyuge886/aigc
All 9 skills in this repoDocs Management
xiaoyuge886/aigc
Single source of truth and librarian for ALL Claude official documentation.
Xagent
xiaoyuge886/aigc
XAgent是一个智能跨域分析助手，基于SOP驱动的规划、多工具协调和多层次数据分析框架，提供专业的商业智能和数据分析能力。当用户需要进行数据分析、业务分析、生成报告或需要结构化的问题解决方案时使用。
Data Analysis
xiaoyuge886/aigc
Perform data analysis tasks including data cleaning, statistical analysis, visualization, and insight generation.
Investment Due Diligence Report
xiaoyuge886/aigc
投资尽调报告专业生成工具。当用户需要撰写投资尽调报告、尽职调查报告、投资分析报告时使用此skill。支持处理Excel财务数据、PDF文档等多种格式数据源，自动生成包含执行摘要、业务分析、财务分析、风险提示、投资建议等核心章节的专业报告。无论用户明确要求"写报告"还是提到"分析投资标的"、"评估项目"、"做DD"等相关需求时，都应使用此skill。
Minio Uploader
xiaoyuge886/aigc
简化版MinIO文件上传工具，支持一键上传文件到MinIO对象存储并获取访问链接. An agent skill from xiaoyuge886/aigc.
Todo Master
xiaoyuge886/aigc
专业的待办事项管理技能，指导如何有效使用 TodoWrite 工具进行任务规划、进度跟踪和状态管理。当用户需要处理复杂任务、多步骤工作流或需要任务规划时使用。
Related
Categories
Questions about Whodb
What does Whodb do?
Database operations including querying, schema exploration, and data analysis. Whodb is an agent skill from xiaoyuge886/aigc. Database operations including querying, schema exploration, and data analysis.
When should I use Whodb?
Whodb fits situations like: tasks that involve NoSQL databases; tasks that involve Database administration; tasks that involve Search implementation.
How do I install Whodb in Claude Code?
Run `npx skills add xiaoyuge886/aigc --skill whodb -a claude-code`. Or copy the skill folder (.claude/skills/whodb in xiaoyuge886/aigc) into .claude/skills/whodb in your project. Claude Code loads it when a task matches its description.
How do I install Whodb in Codex?
Run `npx skills add xiaoyuge886/aigc --skill whodb -a codex`. Or copy the skill folder (.claude/skills/whodb in xiaoyuge886/aigc) into .agents/skills/whodb in your project. Codex loads it when a task matches its description.
Can I use Whodb in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add xiaoyuge886/aigc --skill whodb -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/whodb, .gemini/skills/whodb, .github/skills/whodb and .opencode/skills/whodb in your project.
What does Whodb need to run?
SKILL.md names no scripts, command-line tools or credentials: Whodb is instructions for the agent only.
Does Whodb access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Whodb safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Whodb use?
Whodb is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Whodb use?
About 894 tokens (SKILL.md is roughly 3.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Whodb?
Skills that share tags, products or a category with Whodb: Database Expert (cin12211/orca-q, 224 stars), Mirrord DB Branching (metalbear-co/mirrord, 5.4k stars), DB Sculptor (EliasOulkadi/shokunin, 114 stars) and Automating Database Backups (jeremylongshore/tons-of-skills-marketplace, 2.8k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Whodb?
xiaoyuge886 (a GitHub user) maintains it in xiaoyuge886/aigc, which has 198 GitHub stars. The repository holds 9 skills in this directory. The repository was last updated on July 14, 2026.
Source: xiaoyuge886/aigc on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.