{"data":{"kind":"file","path":"README.md","version_id":"ks3qf80ab9me21th32vrdci7","entry":{"name":"README.md","path":"README.md","is_directory":false,"size":1529,"modified_at":"2026-05-11T13:39:10.308000","content_hash":"a09f7dcb0c420edc9bc0a13bcd85fcac83e09f5dfc9cc9b0d60b84d2b3d1f5df"},"entries":[],"content":"# Database Optimizer\n\nA tool-use environment for SQL query optimization with simulated EXPLAIN and index analysis tools.\n\n## Overview\n\nThis environment presents slow SQL queries that need optimization. The model uses diagnostic tools to analyze query execution plans, check existing indexes, and estimate costs, then provides optimized queries.\n\n## Features\n\n- **15+ slow SQL scenarios** covering common performance anti-patterns\n- **3 diagnostic tools**: `explain_query`, `check_indexes`, `estimate_cost` — all pattern-based\n- **Tool-based interaction** with up to 5 turns for analysis\n- **Weighted reward functions**: keyword matching (30%), query correctness (40%), improvement quality (30%)\n\n## Common Issues Covered\n\n- Missing indexes\n- SELECT * with large columns\n- N+1 query patterns\n- Subqueries replaceable with JOINs\n- Implicit/cross JOINs\n- OFFSET-based pagination\n- Functions on indexed columns (non-sargable)\n- UNION vs UNION ALL\n- Correlated subqueries\n- OR conditions preventing index usage\n\n## Tools\n\n| Tool | Description |\n|------|-------------|\n| `explain_query(query)` | Returns simulated EXPLAIN output for a SQL query |\n| `check_indexes(table)` | Returns index information and recommendations for a table |\n| `estimate_cost(query)` | Returns cost estimation and optimization recommendations |\n\n## Installation\n\n```bash\nprime env install database-optimizer\n```\n\n## Evaluation\n\n```bash\nprime eval run database-optimizer -m gpt-4.1-mini\n```\n\n## Tags\n\n`tool-use` `sql` `database` `optimization` `train` `eval`\n","encoding":"utf-8","truncated":false,"total_bytes":1529},"status":null}