How to Use Text2SQL.ai

Getting started with Text2SQL.ai

After reading this guide, you'll be able to convert natural language questions into SQL queries quickly and efficiently, even if you have little to no SQL knowledge.

Step 1: Sign up and set up

1. Go to Text2SQL.ai.
2. Click on the "Sign Up" button at the top right corner.
3. Enter your email address and create a password. You may also sign up using Google or GitHub if preferred.
4. Confirm your email via the link sent to your inbox.
5. Log in to your new account.

Step 2: Your first query

1. Once logged in, you’ll be taken to the main dashboard.
2. Locate the text input box labelled "Ask a question in natural language."
3. Type in a simple question, like “What are the names of all employees?”
4. Click the "Generate SQL" button below the input box.
5. The SQL query will appear in the output area. You can copy it directly for use in your database.

Step 3: Get better results

1. For more complex queries, try using specific keywords and phrases. For example, “List all products sold after January 2020.”
2. Use the "Conversational Mode" feature to refine your questions. This allows you to ask follow-up questions based on the previous output.
3. Familiarise yourself with the supported database types (MySQL, PostgreSQL, Oracle) by selecting your database type from the dropdown menu before generating queries.

Pro tip

Use the "Save Query" feature after generating a SQL query. This allows you to keep a library of useful queries that you can revisit without having to re-enter your questions.

Common mistake to avoid

Avoid vague questions like “Tell me about the sales.” Instead, be specific with what you want to retrieve, such as “Show total sales for each product in 2021.” Vague questions may result in incorrect or incomplete SQL queries.