Spaces:
Sleeping
Sleeping
Download openenv.yaml from rajdeepchatale/sql_query_env: direct link, hf CLI and curl.
- Browser
- Download file 3.93 kB
-
https://huggingface.co/spaces/rajdeepchatale/sql_query_env/resolve/main/openenv.yaml
- Command line
-
hf download hf://spaces/rajdeepchatale/sql_query_env/openenv.yaml
-
curl -L -o openenv.yaml https://huggingface.co/spaces/rajdeepchatale/sql_query_env/resolve/main/openenv.yaml
3.93 kB
| spec_version: 1 | |
| name: sql_query_env | |
| description: > | |
| Trains agents to generate SQL queries from natural language questions. | |
| Tests across three database domains (company analytics, hospital | |
| management, e-commerce) with efficiency scoring and diagnostic feedback. | |
| type: space | |
| runtime: fastapi | |
| app: server.app:app | |
| port: 8000 | |
| tasks: | |
| # Company | |
| - id: company_easy_1 | |
| name: "Company β Engineering Employees" | |
| difficulty: easy | |
| description: "List active Engineering employees sorted by salary" | |
| domain: company | |
| - id: company_easy_2 | |
| name: "Company β Electronics Products" | |
| difficulty: easy | |
| description: "Filter electronics products by price" | |
| domain: company | |
| - id: company_medium_1 | |
| name: "Company β Revenue by Category" | |
| difficulty: medium | |
| description: "Total revenue per product category for completed orders" | |
| domain: company | |
| - id: company_medium_2 | |
| name: "Company β Department Salaries" | |
| difficulty: medium | |
| description: "Departments with average salary exceeding $100K" | |
| domain: company | |
| - id: company_hard_1 | |
| name: "Company β Budget Utilization" | |
| difficulty: hard | |
| description: "Department salary-to-budget utilization percentage" | |
| domain: company | |
| # Hospital | |
| - id: hospital_easy_1 | |
| name: "Hospital β Current Patients" | |
| difficulty: easy | |
| description: "List patients still admitted (NULL discharge date)" | |
| domain: hospital | |
| - id: hospital_medium_1 | |
| name: "Hospital β Medication Costs" | |
| difficulty: medium | |
| description: "Total medication cost for admitted patients" | |
| domain: hospital | |
| - id: hospital_hard_1 | |
| name: "Hospital β Cross-Ward Prescriptions" | |
| difficulty: hard | |
| description: "Doctors prescribing to patients outside their ward" | |
| domain: hospital | |
| # E-Commerce | |
| - id: ecommerce_easy_1 | |
| name: "E-Commerce β Premium Users" | |
| difficulty: easy | |
| description: "List premium users with signup details" | |
| domain: ecommerce | |
| - id: ecommerce_medium_1 | |
| name: "E-Commerce β Seller Revenue" | |
| difficulty: medium | |
| description: "Revenue per seller for delivered orders" | |
| domain: ecommerce | |
| - id: ecommerce_hard_1 | |
| name: "E-Commerce β Return Rate Analysis" | |
| difficulty: hard | |
| description: "Return rate per product category with edge cases" | |
| domain: ecommerce | |
| # Expert-level | |
| - id: company_hard_2 | |
| name: "Company β Salary vs Manager" | |
| difficulty: hard | |
| description: "Employees earning more than their direct manager (self-join)" | |
| domain: company | |
| - id: hospital_hard_2 | |
| name: "Hospital β Repeat Visits" | |
| difficulty: hard | |
| description: "Patients with multiple appointments with the same doctor" | |
| domain: hospital | |
| - id: ecommerce_hard_2 | |
| name: "E-Commerce β Dead Stock" | |
| difficulty: hard | |
| description: "In-stock products that have never been ordered (anti-join)" | |
| domain: ecommerce | |
| action_space: | |
| type: object | |
| properties: | |
| query: | |
| type: string | |
| description: "SQL SELECT query to execute against the database" | |
| observation_space: | |
| type: object | |
| properties: | |
| task_id: | |
| type: string | |
| difficulty: | |
| type: string | |
| enum: [easy, medium, hard] | |
| database_domain: | |
| type: string | |
| description: "Company Analytics, Hospital Management, or E-Commerce Platform" | |
| question: | |
| type: string | |
| schema_description: | |
| type: string | |
| query_result: | |
| type: string | |
| query_error: | |
| type: string | |
| feedback: | |
| type: string | |
| diagnostics: | |
| type: array | |
| description: "Structured diagnostic feedback (type, severity, message, suggestion)" | |
| efficiency_notes: | |
| type: array | |
| description: "SQL efficiency and best-practice feedback" | |
| expected_row_count: | |
| type: integer | |
| expected_columns: | |
| type: array | |
| steps_remaining: | |
| type: integer | |
| current_score: | |
| type: number | |
| history: | |
| type: array | |