query-builder

Query Builder

Convert natural language questions into SQL queries using the database schema.

These database-only MCP tools require the database module enabled through whodb setup. Keep the MCP command at whodb mcp serve. For platform resources, use the WhoDB skill and discover available whodb_platform_* tools instead.

When to Use

Activate when user asks questions like:

• "Show me all users who signed up last month"
• "Find orders greater than $100"
• "Which products have low inventory?"
• "Get the top 10 customers by total spend"

Workflow

1. Understand the Schema

Before generating SQL, always check the table structure:

whodb_tables(connection="...") → Get available tables
whodb_columns(table="relevant_table") → Get column names and types

2. Identify Intent

Parse the natural language request:

• Subject: What entity? (users, orders, products)
• Filter: What conditions? (last month, > $100, active)
• Aggregation: Count, sum, average, max, min?
• Grouping: By what dimension?
• Ordering: Sort by what? Ascending/descending?
• Limit: How many results?

3. Map to Schema

• Match entities to table names
• Match attributes to column names
• Identify foreign key joins needed

4. Generate SQL

Build the query following SQL best practices:

SELECT columns
FROM table
[JOIN other_table ON condition]
WHERE filters
[GROUP BY columns]
[HAVING aggregate_condition]
ORDER BY column [ASC|DESC]
LIMIT n;

5. Execute and Present

whodb_query(query="generated SQL")

Translation Patterns

Natural Language	SQL Pattern
"last week/month/year"	WHERE date_col >= DATE_SUB(NOW(), INTERVAL 1 WEEK)
"more than X" / "greater than X"	WHERE col > X
"top N"	ORDER BY col DESC LIMIT N
"how many"	SELECT COUNT(*)
"total" / "sum of"	SELECT SUM(col)
"average"	SELECT AVG(col)
"for each" / "by"	GROUP BY col
"between X and Y"	WHERE col BETWEEN X AND Y
"contains" / "like"	WHERE col LIKE '%term%'
"starts with"	WHERE col LIKE 'term%'
"is empty" / "is null"	WHERE col IS NULL
"is not empty"	WHERE col IS NOT NULL