How to Use SQLAI.ai

Getting started with SQLAI.ai

With SQLAI.ai, you can generate and optimise SQL queries quickly using natural language. After this guide, you'll be able to create SQL queries without needing extensive coding knowledge.

Step 1: Sign up and set up

1. Go to SQLAI.ai.
2. Click on the "Sign Up" button in the top right corner.
3. Enter your email address and create a password, then click "Create Account".
4. You can start using the free tier immediately without any payment details.

Step 2: Your first query

1. Once logged in, you'll see the main dashboard. Look for the text input box labelled "Ask SQLAI".
2. Type your natural language question, such as "Show me all customers who made a purchase in the last month".
3. Click the "Generate SQL" button right below the input box.
4. The generated SQL query will appear in the output section. You can copy it to use in your database.

Step 3: Get better results

1. Be specific with your questions. Instead of asking vague questions like "Tell me about sales", specify the timeframe and details: "List sales from January 2023 to March 2023".
2. Use the "Optimise Query" button after generating a query to improve performance. This feature will refine your query for efficiency.

Pro tip

When typing your question, include relevant table names and fields if you know them. This helps SQLAI.ai generate more accurate queries.

Common mistake to avoid

Avoid overly complex questions. Keep your queries straightforward to prevent SQLAI.ai from misunderstanding your request, which can result in incorrect or inefficient SQL code.