Diagnose a database symptom (SIXTA)
sixta_diagnoseSIXTA's deepest free analysis: bring a symptom ('p99 spiked after Tuesday's deploy', 'this endpoint times out') plus whatever artifacts exist — query, EXPLAIN output, table DDL, diagnostics excerpts — and get one coherent diagnosis: ranked hypotheses with the evidence for each, and next steps ordered by information gained. Runs SIXTA's deterministic analyzers across all artifacts, then a synthesis pass connects them. Use for vague or multi-artifact problems where no single tool fits; for a single query/plan/DDL artifact, prefer the specific tool. Anonymous use is limited to a couple of calls — do not call repeatedly. Input is analyzed in memory and never stored.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | No | Optional: the suspect SQL query | |
| engine | Yes | Database engine: postgresql or mysql | |
| symptom | Yes | The problem in the user's words — what changed, when, what it affects, and any cause they already suspect or setting they ask about (pass these through; SIXTA will address each lead) | |
| version | No | Engine version, e.g. '16' (PostgreSQL major) or '8.0.35' (MySQL). Omit for a modern default; some verdicts are version-dependent and the assumption is stated in the result. | |
| table_ddl | No | Optional: CREATE TABLE / index DDL, or a proposed migration | |
| diagnostics | No | Optional: pasted diagnostics the user ran themselves (pg_stat_statements excerpts, SHOW ENGINE INNODB STATUS, vacuum stats) | |
| explain_output | No | Optional: EXPLAIN / EXPLAIN ANALYZE output (any format) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| engine | No | Engine the analysis targeted, when known. | |
| report | Yes | The full human-readable SIXTA report (markdown). | |
| findings | No | Named findings as structured data, when the tool produces them. | |
| finding_count | No | Number of findings/issues identified. | |
| overall_severity | No | Highest severity across findings (Critical/High/Medium/Low/Info). |