Analyze execution plans, indexes, deadlocks, code quality, and server health. Get prioritized, ready-to-run fixes in minutes. Powered by GPT-5.4 and Claude on Microsoft Foundry.
Six focused tuning goals, one workspace. Pick the goal that matches your problem: Query Tuner for a specific slow query, Index Tuning for database-wide gains, and more.
Query Tuner
Paste any SQL query. Get prioritized execution-plan analysis, index recommendations with DDL, and rewrite suggestions with before/after examples.
Index Tuning
Find every missing, duplicate, and unused index across your databases, with the impact data to prove each one is worth fixing.
Server Health
Evaluate your SQL Server's health so you know what's working well, what's at risk, and what to fix first.
Database Code Review
Review your stored procedures, functions, views and triggers against best practices for performance and transaction management. Get actionable refactor guidance.
Deadlock Analysis
Find what is causing your deadlocks and how to fix them.
Blocking and Locking Analysis
Investigate any active blocking and locking to determine their root cause. Identify fixes and their impact.
New · Query Tuner
Fix one slow query — fast.
Query Tuner analyzes any individual SQL query you provide. It pulls the estimated execution plan, identifies every referenced table, and gathers targeted metadata. Then it feeds everything to an AI reasoning model and returns a prioritized HTML report.
Execution-plan analysis: operator-level cost breakdown, plus warnings for TempDB spills, implicit conversions, and missing statistics.
Index recommendations: ready-to-run DDL scripts you can review and deploy.
Query rewrites: before/after examples, not vague advice.
Plays inline. Clicking loads the YouTube player from youtube-nocookie.com.
Choose the AI model that fits the job
Switch models per analysis. Models are hosted on Azure using Microsoft Foundry; your data stays inside the Azure trust boundary. Prefer your own deployment? Bring your own Foundry endpoint with our 5-step setup guide.
Model
Availability
Best for
OpenAI GPT-5.4
All editions
General-purpose reasoning across all tuning goals.
Anthropic Claude Sonnet 4.6
All editions
Strong everyday tuning with a faster response.
Anthropic Claude Opus 4.6
Corporate only
Proven deep analysis for tough queries — a dependable heavy-duty option.
Anthropic Claude Opus 4.7
Corporate only
Extended reasoning for complex, multi-table workloads.
Anthropic Claude Opus 4.8
Corporate only
Anthropic's newest Opus — the deepest reasoning available in AI SQL Tuner Studio.
How it works
Three steps. No agents to install. No log shipping.
Connect securely
Point at your database with a least-privileged SQL login.
SQL Server, Azure SQL Database, Managed Instance, and Fabric SQL Database. Windows or SQL authentication.
Pick a goal
Choose your tuning goal and run it.
Six built-in goals — from a single slow query to a full server health check.
Includes execution-plan analysis, ready-to-run DDL scripts, and query rewrites.
Editions
Four editions: one free for SQL Server Developer Edition, three paid editions for production. Free Edition needs no credit card. The 14-day trial of any paid edition requires a credit card.
All paid editions support SQL Server, Azure SQL Database, Azure SQL Managed Instance, and Fabric SQL Database. Models are hosted on Microsoft Foundry; bring your own AI endpoint if you prefer.
Built by a 30-year SQL Server veteran.
AI SQL Tuner Studio is built by Kevin A. Feit, founder and CEO of AI SQL Tuner LLC. Kevin has worked with SQL Server since 1990 across database administration, application development, data engineering, and business intelligence for Fortune 500 companies, non-profits, and SMBs.
AI SQL Tuner Studio is a Windows desktop tool that uses AI to analyze SQL Server, Azure SQL Database, Azure SQL Managed Instance, and Fabric SQL Database. It finds slow queries, missing indexes, deadlocks, code-quality issues, and server-health problems, and returns prioritized fixes in minutes.
What does the Query Tuner feature do?
Query Tuner analyzes any individual SQL query you paste in. It retrieves the estimated execution plan, identifies every referenced table, collects targeted metadata, and produces a prioritized HTML report with execution-plan analysis, index recommendations with ready-to-run DDL, query-rewrite suggestions with before/after examples, and parameter-sniffing mitigation strategies.
Which AI models are supported, and where are they hosted?
OpenAI GPT-5.4 and Anthropic Claude Sonnet 4.6 are available on every edition. Anthropic Claude Opus 4.6, Opus 4.7 and Opus 4.8 are included exclusively with the Corporate edition. All models are hosted on Azure using Microsoft Foundry. You can also bring your own Azure OpenAI endpoint; see Configure Your Azure OpenAI Endpoint: 5 Easy Steps.
Which database platforms does it support?
Microsoft SQL Server (on-prem and IaaS), Azure SQL Database, Azure SQL Managed Instance, and Microsoft Fabric SQL Database.
What are the editions and pricing?
Four editions, three paid. Free: $0, SQL Server Developer Edition, no credit card. Standard: $125/yr, up to 2 connections, SQL Server Standard. Pro: $250/yr, up to 2 connections, SQL Server Enterprise. Corporate: $600/yr, unlimited connections, includes Claude Opus 4.6, 4.7 and 4.8. Paid editions include a 14-day trial; the trial requires a credit card.
What permissions does it require on my SQL Server?
AI SQL Tuner Studio runs on your Windows workstation and connects directly to your database. Targeted metadata and execution-plan content are sent to the chosen AI model, which is hosted on Azure (Microsoft Foundry); your traffic stays inside the Azure trust boundary. If you'd rather use your own deployment, configure a bring-your-own endpoint.
Ready to optimize your SQL Server performance?
Run your first analysis in minutes. Download the Free Edition — no credit card required — or start a 14-day trial of any paid edition.
Used to determine whether a user is included in an A / B or Multivariate test.
18 months
_ga
ID used to identify users
2 years
_gali
Used by Google Analytics to determine which links on a page are being clicked
30 seconds
_ga_
ID used to identify users
2 years
_gid
ID used to identify users for 24 hours after last activity
24 hours
_gat
Used to monitor number of Google Analytics server requests when using Google Tag Manager
1 minute
_gac_
Contains information related to marketing campaigns of the user. These are shared with Google AdWords / Google Ads when the Google Ads and Google Analytics accounts are linked together.
90 days
__utma
ID used to identify users and sessions
2 years after last activity
__utmt
Used to monitor number of Google Analytics server requests
10 minutes
__utmb
Used to distinguish new sessions and visits. This cookie is set when the GA.js javascript library is loaded and there is no existing __utmb cookie. The cookie is updated every time data is sent to the Google Analytics server.
30 minutes after last activity
__utmc
Used only with old Urchin versions of Google Analytics and not with GA.js. Was used to distinguish between new sessions and visits at the end of a session.
End of session (browser)
__utmz
Contains information about the traffic source or campaign that directed user to the website. The cookie is set when the GA.js javascript is loaded and updated when data is sent to the Google Anaytics server
6 months after last activity
__utmv
Contains custom information set by the web developer via the _setCustomVar method in Google Analytics. This cookie is updated every time new data is sent to the Google Analytics server.
