AutoDBA
Portfolio
1

Ready for Optimization

Paste or type a SQL query in the editor, or pick one of the example queries above to get started.

Model Context Protocol (MCP) Server

Integrate AutoDBA query diagnostics directly into your AI IDE.

AutoDBA is published as a standalone Python MCP server package (autodba-mcp). Run it locally in Claude Desktop, Cursor, or Antigravity via uvx autodba-mcp, or connect to the serverless JSON-RPC HTTP endpoint.

100% Safe for Work & Production Queries

Unlike other tools that ask for your database password, AutoDBA never connects to your database. It analyzes query syntax offline—meaning zero access to real customer data, zero security risk, and zero chance of accidental database mutations.

{
  "mcpServers": {
    "autodba": {
      "command": "uvx",
      "args": [
        "autodba-mcp"
      ]
    }
  }
}
Repo: github.com/jeffreyehogg/autodba-mcpOpen-Source MCP Server

Bring Your Own Key (BYOK)

Unlock high-frequency agentic query rewrites.

Tier:Free Serverless Community Tier
Daily Optimizations:— / 5 remaining

*Rule-based analysis and all enterprise examples are always 100% free with unlimited runs.

Your API key is stored exclusively in your browser’s sessionStorage. It is transmitted securely over HTTPS via the X-Gemini-Key header and is never logged or persisted.

Generate Stored ProcedureT-SQL (SQL Server)

Wrap your query into an enterprise-standard, production-ready stored procedure.

sp_GetData.sql
USE [AppDB];
GO

SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO

-- =============================================
-- Author:      AutoDBA
-- Create Date: 2026-10-16
-- Description: Stored procedure for [dbo].[sp_GetData]
-- =============================================
CREATE OR ALTER PROCEDURE [dbo].[sp_GetData]
AS
BEGIN
    SET NOCOUNT ON;
    SET XACT_ABORT ON;

    BEGIN TRY

    END TRY
    BEGIN CATCH
        -- Preserve error line number, severity, and state
        THROW;
    END CATCH;
END;
GO
CREATE OR ALTER PROCEDURE (SQL Server 2016 SP1+)