Whodb

What it does

This skill, Whodb, provides AI agents with the ability to interact with databases using either Model Context Protocol (MCP) tools or command-line interface (CLI) commands. It allows agents to list database connections, execute SQL queries, discover schemas and tables, and describe table columns. This enables users to retrieve information from databases and perform basic data exploration tasks directly through the AI agent.

When to use it

• When you need to quickly query a database for specific information (e.g., "Show me the top 10 users").
• To explore the structure of a database, including available schemas, tables, and columns.
• For automated data retrieval tasks where an agent needs to access and process data stored in a relational database.

Key capabilities

• Database Connection Listing: Lists all available database connections (whodb_connections).
• SQL Query Execution: Executes SQL queries against specified databases (whodb_query).
• Schema Discovery: Lists schemas within a database (whodb_schemas).
• Table Listing: Lists tables within a schema (whodb_tables).
• Column Description: Describes the columns of a given table (whodb_columns).
• CLI Fallback: Provides CLI commands as an alternative when MCP tools are unavailable.

Example prompts

• "List all available database connections."
• "Execute this SQL query: SELECT * FROM users LIMIT 10 against the 'mydb' connection."
• "What tables exist in the 'public' schema of the 'mydb' database?"

Tips & gotchas

• The skill prioritizes using MCP tools for interaction. Ensure these are available for optimal performance.
• If a single database connection is configured, you can often omit the connection parameter from commands.
• Familiarity with SQL syntax is required to effectively utilize the query execution capabilities.