AI2SQL VSCode Extension

AI2SQL is a powerful VSCode extension that helps you generate and optimize SQL queries using AI. Simply write your requirements in natural language, and AI2SQL will convert them into efficient SQL queries.

Features

• 🤖 Natural Language to SQL: Convert your requirements written in natural language into SQL queries
• ⚡ SQL Optimization: Optimize your existing SQL queries for better performance
• 💡 Context Aware: Understands your database schema and table relationships
• ✨ Real-time Conversion: Instantly convert text to SQL as you type

Usage

1. Generate SQL from Natural Language:

   • Select the text describing your query requirements
   • Press Cmd+Shift+P (Mac) / Ctrl+Shift+P (Windows/Linux)
   • Type "AI2SQL: Generate SQL" and press Enter
   • The selected text will be replaced with the generated SQL query

2. Optimize Existing SQL:

   • Select the SQL query you want to optimize
   • Press Cmd+Shift+P (Mac) / Ctrl+Shift+P (Windows/Linux)
   • Type "AI2SQL: Optimize SQL" and press Enter
   • The selected SQL will be replaced with an optimized version

Requirements

• VSCode 1.85.0 or higher
• Active internet connection for AI functionality

Extension Settings

This extension contributes the following settings:

• ai2sql.model: Select which AI model to use for generation and optimization
• ai2sql.apiKey: Your API key for the AI service (required)

Known Issues

• Currently in development, basic functionality only

Release Notes

0.0.1

Initial release of AI2SQL with basic SQL generation and optimization capabilities.

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

This project is licensed under the MIT License - see the LICENSE file for details.