OptiSQL

OptiSQL is an AI-powered VS Code extension designed to help you optimize your SQL queries effortlessly.
Leverage modern AI techniques to rewrite your SQL for better performance while maintaining the same results.

Features

• Optimize selected SQL queries directly within VS Code.
• Supports multiple SQL dialects: SQL, MSSQL, Oracle SQL.
• Shows a preview of optimized SQL before replacing.
• Quick access through a context menu or CodeLens link.
• Configurable API endpoint for your custom SQL optimization service.

Installation

1. Search for OptiSQL in the VS Code Marketplace.
2. Click Install.
3. Reload VS Code if necessary.

Usage

1. Open a SQL file or write SQL in your editor.
2. Select the SQL query you want to optimize.
3. Click the Optimize SQL Query ✏️ link above the query or right-click and choose Optimize SQL.
4. Review the optimized query preview.
5. Choose to Replace the selected query or Show Diff to compare.

Configuration

You can configure the extension’s API endpoint and token in your VS Code settings: