# Aiven AI Database Optimizer

> AI-driven SQL and index recommendations for PostgreSQL and MySQL, integrated into the Aiven Console with a free online optimizer and IDE extensions.

Aiven AI Database Optimizer analyzes PostgreSQL® and MySQL workloads, surfaces slow queries, and generates concrete optimization steps—index suggestions, SQL rewrites, and related tuning guidance—directly in the Aiven Console. It also offers a free, standalone online SQL optimizer for ad-hoc queries and official IDE plugins (VS Code and JetBrains) to optimize queries from your editor.

The product originated as EverSQL and is now part of Aiven. For historical context and existing users, see the previous site at https://www.eversql.com/.

**How it works**
- Gathers schema and performance metadata (e.g., query frequency/latency, existing indexes) to build a holistic view of database workloads.
- Uses heuristic and AI models to propose safe, actionable changes (new or modified indexes, SQL rewrites) without requiring access to raw table data.
- Integrates with Aiven services so you can review and apply recommendations in a few clicks.

What you can do
- Identify and fix slow PostgreSQL/MySQL queries faster with AI insights.
- Get precise index recommendations and SQL rewrites to reduce CPU/memory usage and cut costs.
- Run quick one-off optimizations via the free online tool—no account required.
- Optimize from your editor using the VS Code extension or JetBrains plugin.

Notes
- Supported databases: PostgreSQL® and MySQL®.
- Available inside the Aiven platform (Console, API/CLI) and as a free web tool for single-query optimization.

## Features
- AI-driven performance insights for PostgreSQL and MySQL
- Index recommendations with estimated impact
- SQL rewrite suggestions for faster execution
- Non-intrusive analysis using schema and metadata (no raw data access required)
- Automatic surfacing of slow queries in the Aiven Console
- Free online SQL optimizer for ad-hoc queries
- VS Code extension to optimize/format queries in-editor
- JetBrains (DataGrip/IntelliJ) plugin support
- One-click review and apply flow within Aiven services
- Workload-level view to prioritize the most impactful fixes

## Integrations
Aiven for PostgreSQL, Aiven for MySQL, Aiven Console, Aiven API, Visual Studio Code, JetBrains IDEs

## Platforms
WEB, API, VSC_EXTENSION, JETBRAINS_PLUGIN

## Pricing
Open Source, Free tier available

## Links
- Website: https://aiven.io/solutions/aiven-ai-database-optimizer
- Documentation: https://aiven.io/docs/tools/query-optimizer
- Repository: https://github.com/aiven/aiven-sql-optimizer-vscode
- EveryDev.ai: https://www.everydev.ai/tools/aiven-ai-database-optimizer