query-builder

What it does

This skill enables AI agents to construct and execute database queries directly within the whodb environment. It allows for dynamic data retrieval, filtering, and manipulation without requiring manual SQL writing or external tool configuration.

When to use it

• You need to extract specific records from a relational database based on complex criteria.
• Your agent requires real-time access to structured data stored in whodb for decision-making.
• You want to automate repetitive data reporting tasks that involve joining multiple tables.
• You are building an application where the AI must update or insert new entries into your existing database schema.

Key capabilities

• Dynamic Query Generation: Automatically translates natural language requests into executable SQL statements.
• Schema Awareness: Understands table structures, column names, and data types within the whodb instance.
• Execution & Return: Runs queries against the live database and returns results in a usable format for the agent.
• Integration: Works seamlessly with the whodb infrastructure to ensure data consistency.

Example prompts

• "Find all users who have made purchases over $500 in the last month."
• "Update the status of order ID 12345 to 'shipped' and notify the customer."
• "Generate a summary report showing total revenue per category for Q3."

Tips & gotchas

Ensure your whodb instance is properly configured and accessible before attempting to run queries. While this skill handles standard SQL operations, extremely complex or non-standard database schemas may require additional context or manual intervention to interpret correctly.