There is a newer version of the record available.

Published September 27, 2026 | Version 1.1.0

AI Database Optimizer and SQL Optimization Dataset

Authors/Creators

  • 1. Polytechnic College of Yaroslav-the-Wise Novgorod State University

Description

AI Database Optimizer analyses and optimizes SQL queries for MySQL and PostgreSQL. Recommendations of large language models (GigaChat, YandexGPT, OpenAI-compatible, local models via Ollama) are accepted only after safety, schema, result-equivalence and benchmark checks.

The release includes SQL Optimization Dataset v1.1.0 (directory dataset/, CC BY 4.0): 704 measured records from eight experiments, including a comparison of GigaChat-2, GigaChat-2-Pro, GigaChat-2-Max, Qwen2.5-Coder-7B and a rule-based rewriter, with original and candidate SQL, execution plans, per-run timings, equivalence checksums, outcome labels and full LLM prompts and responses.

Программа анализа и оптимизации SQL-запросов с проверкой рекомендаций языковых моделей и открытый датасет результатов экспериментов.

Files

ykvlev/ai-db-optimizer-v1.1.0.zip

Files (697.7 kB)

Name Size
md5:324307699a32181084ad46d89c71e61f
697.7 kB Preview Download

Additional details

Related works