query_database
Run read-only SQL queries on enterprise sales database to analyze customers, products, orders, and more. Use aggregate functions and joins for insights.
Instructions
Run a read-only SQL query against the enterprise database.
Tables: customers, products, orders, order_items, employees.
Examples: SELECT * FROM customers WHERE tier = 'enterprise' LIMIT 10 SELECT region, COUNT(*) as customers FROM customers GROUP BY region SELECT p.name, SUM(oi.quantity) as sold FROM order_items oi JOIN products p ON oi.product_id = p.id GROUP BY p.name ORDER BY sold DESC LIMIT 5
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SELECT SQL query to execute. Only SELECT statements allowed. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | Result rows as dicts | |
| columns | Yes | Column names in result order | |
| row_count | Yes | Number of rows returned |