Free AI SQL in VS Code: Natural Language to SQL

Yes, with limits. You can turn plain English into SQL inside VS Code by adding the AI2SQL MCP server to GitHub Copilot’s agent mode: click Add to VS Code on ai2sql.io/mcp, start the server from the MCP view, and sign in with your AI2SQL account. Copilot can then ask AI2SQL to write SQL for MySQL, PostgreSQL, SQL Server and other dialects, right next to your code.

Is it free?

Free: adding the server costs nothing, and the AI2SQL Free plan includes a small number of SQL requests a day.
Paid plans (Start $9, Pro $19, Team $39 per month, see pricing) raise the limits. Connecting your own database, so AI2SQL reads your real schema and runs read-only queries, is part of Pro and Team. Every paid plan starts with a 7-day trial, and a credit card is required to start it.
The Marketplace extension: an older AI2SQL extension (version 0.0.4, last updated September 2024) is also listed on the VS Code Marketplace and is free to install. It adds two commands, AI2SQL: Login and AI2SQL: Generate SQL, and signs in with a web.ai2sql.io account. The sections below describe that extension.

Features of Our Visual Studio Code Extension

Natural Language to SQL

Convert plain English descriptions into complex SQL queries with ease.

User Authentication

Secure access and usage management through user authentication.

Usage Tracking

Monitor your query generation to stay within monthly limits.

Improved Productivity

Generate complex queries without memorizing SQL syntax, saving time for developers and analysts.

How to Install AI2SQL Extension

Open Visual Studio Code
Go to the Extensions view (Ctrl+Shift+X)
Search for AI2SQL
Click Install on the AI2SQL extension
Ensure you have an active account on web.ai2sql.io

How to Use AI2SQL in Visual Studio Code

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

Frequently Asked Questions

How to add AI2SQL extension manually in Visual Studio Code?

To add AI2SQL manually: Download the .vsix file from our website, open VS Code, go to Extensions view, click … at the top, choose Install from VSIX, and select the downloaded file.

How to install AI2SQL extension in Visual Studio Code offline?

For offline installation: Download the .vsix file when online, transfer it to the offline machine, then follow the manual installation process mentioned above.

How to activate AI2SQL extension in Visual Studio Code?

After installation, AI2SQL activates automatically. If not, try reloading VS Code. Use the Command Palette and type AI2SQL to see available commands and activate features.

Can I use AI2SQL with other programming languages like Python or C++?

Yes! While AI2SQL generates SQL, it can be used alongside any programming language in VS Code. It’s particularly useful for projects involving database interactions, regardless of the main language used.

Is There a Free AI SQL Editor for VS Code?