How to Use AI2SQL

Getting started with AI2SQL

In this guide, you’ll learn how to quickly convert natural language into SQL queries using AI2SQL. By the end, you’ll be able to generate SQL statements effortlessly, even if you have little to no coding experience.

Step 1: Sign up and set up

1. Go to ai2sql.io.
2. Click on the "Get Started" button on the homepage.
3. Sign up using your email address or log in if you already have an account.
4. Once logged in, you’ll be directed to the main interface where you can start generating SQL queries.

Step 2: Your first SQL query

1. In the main interface, you’ll see a text box labelled "Ask AI2SQL".
2. Type a simple question or request, such as “Show me all customers from London”.
3. Click the "Generate SQL" button below the text box.
4. The SQL query will appear in the output area. You can copy it directly or click "Run Query" if you have a connected database.

Step 3: Get better results

• Be specific in your requests. Instead of saying “Get sales data”, try “Get total sales for March 2023”.
• Use the "Examples" section on the right side of the interface to see common queries, which can guide your phrasing.
• If you’re using integrations (like Slack or ChatGPT), simply type your request in the chat and follow the prompts to generate and run your SQL.

Pro tip

Use the "Save Query" feature after generating a SQL statement. This allows you to easily access frequently used queries later without having to retype them.

Common mistake to avoid

Avoid vague language in your requests. Phrases like "Get data" will yield less accurate results. Always specify what data you want and any relevant conditions.