AI2SQL

AI2SQL is a Visual Studio Code extension that allows you to generate SQL queries from natural language descriptions using OpenAI's GPT model. This extension now requires user authentication to manage usage limits.

Features

• Convert natural language descriptions into SQL queries
• User authentication to manage access and usage
• Usage tracking to ensure compliance with monthly limits
• Easily generate complex SQL queries without memorizing syntax
• Improve productivity for developers and data analysts

Installation

1. Install the AI2SQL extension from the Visual Studio Code Marketplace
2. Ensure you have an active account on web.ai2sql.io

Usage

1. Authentication:

   • Open the Command Palette (Ctrl+Shift+P on Windows/Linux, Cmd+Shift+P on macOS)
   • Type "AI2SQL: Login" and select the command
   • Enter your email and password when prompted

2. Generating SQL:

   • Open the Command Palette
   • Type "AI2SQL: Generate SQL" and select the command
   • Enter your natural language description of the desired SQL query
   • The extension will generate the SQL query and open it in a new editor

Requirements

• Visual Studio Code v1.75.0 or higher
• An active account on web.ai2sql.io
• Internet connection for authentication and API access

Extension Settings

This extension does not add any VS Code settings.

Known Issues

• The extension requires re-authentication upon restarting VS Code
• Usage limits are tied to the authenticated session and reset upon re-authentication

Privacy and Data Usage

• Your login credentials are used solely for authentication with the AI2SQL service
• Natural language queries are sent to OpenAI's API for SQL generation
• Usage data (query count) is tracked to enforce monthly limits

Release Notes

0.0.2

• Added user authentication feature
• Implemented usage tracking and limits

0.0.1

Initial release of AI2SQL

For more information

• AI2SQL Website
• VS Code's Markdown Support
• Markdown Syntax Reference

Enjoy using AI2SQL!