adithyak/ mysql-index-advisor

Updated 2 days ago

A specialized MySQL performance tuning assistant built on top of qwen3-coder:480b-cloud. Drop in a slow query or EXPLAIN output — get back exact indexes and reasoning, no fluff.

cloud

ollama run adithyak/mysql-index-advisor

curl http://localhost:11434/api/chat \
  -d '{
    "model": "adithyak/mysql-index-advisor",
    "messages": [{"role": "user", "content": "Hello!"}]
  }'

from ollama import chat

response = chat(
    model='adithyak/mysql-index-advisor',
    messages=[{'role': 'user', 'content': 'Hello!'}],
)
print(response.message.content)

import ollama from 'ollama'

const response = await ollama.chat({
  model: 'adithyak/mysql-index-advisor',
  messages: [{role: 'user', content: 'Hello!'}],
})
console.log(response.message.content)

Models

Name

1 model

Size / Usage

Context

Input

mysql-index-advisor:latest

1.5kB · - context window · Text · 2 days ago

mysql-index-advisor:latest

1.5kB

-

Text

Readme

mysql-index-advisor

A specialized MySQL performance tuning assistant built on top of qwen3-coder:480b-cloud.
Drop in a slow query or EXPLAIN output — get back exact indexes and reasoning, no fluff.

Model Summary

Property	Value
Base Model	qwen3-coder:480b-cloud
Temperature	0.1 (deterministic, precise)
Context Window	8192 tokens
Domain	MySQL query optimization & indexing
Use Case	Backend developers, DBAs, DevOps

What It Does

Given a slow query or EXPLAIN output, the model will:

Identify the bottleneck (full table scan, filesort, temporary table etc)
Suggest the exact CREATE INDEX statement
Explain why that index helps
Warn if the index might hurt write performance
Suggest query rewrites if needed

Install & Run

# Pull the model
ollama pull adithyak/mysql-index-advisor

# Run it
ollama run adithyak/mysql-index-advisor

Requirements: - Ollama installed - ~8GB free disk space

Example Usage

Input:

SELECT * FROM booking WHERE active = 1 AND location = 'ABC' ORDER BY created_at DESC
Table has 2 million rows.

Output:

-- active has low cardinality, location is more selective — put location first
CREATE INDEX idx_booking_location_created
ON booking(location, active, created_at DESC);

With explanation of why and any write performance tradeoffs.

What It Won’t Do

Will not suggest indexes for tables under 1000 rows
Will not give vague answers like “add an index on that column”
Will not ignore cardinality or row counts

# mysql-index-advisor

A specialized MySQL performance tuning assistant built on top of `qwen3-coder:480b-cloud`.  
Drop in a slow query or EXPLAIN output — get back exact indexes and reasoning, no fluff.

---

## Model Summary

| Property | Value |
|---|---|
| Base Model | qwen3-coder:480b-cloud |
| Temperature | 0.1 (deterministic, precise) |
| Context Window | 8192 tokens |
| Domain | MySQL query optimization & indexing |
| Use Case | Backend developers, DBAs, DevOps |

---

## What It Does

Given a slow query or EXPLAIN output, the model will:

1. Identify the bottleneck (full table scan, filesort, temporary table etc)
2. Suggest the exact `CREATE INDEX` statement
3. Explain why that index helps
4. Warn if the index might hurt write performance
5. Suggest query rewrites if needed

---

## Install & Run

```bash
# Pull the model
ollama pull adithyak/mysql-index-advisor

# Run it
ollama run adithyak/mysql-index-advisor
```

**Requirements:**
- [Ollama](https://ollama.com) installed
- ~8GB free disk space

---

## Example Usage

**Input:**
```
SELECT * FROM booking WHERE active = 1 AND location = 'ABC' ORDER BY created_at DESC
Table has 2 million rows.
```

**Output:**
```sql
-- active has low cardinality, location is more selective — put location first
CREATE INDEX idx_booking_location_created
ON booking(location, active, created_at DESC);
```
With explanation of why and any write performance tradeoffs.

---

## What It Won't Do

- Will not suggest indexes for tables under 1000 rows
- Will not give vague answers like "add an index on that column"
- Will not ignore cardinality or row counts

Paste, drop or click to upload images (.png, .jpeg, .jpg, .svg, .gif)