Help Center

Everything you need to get the most out of SQL AI.

Getting Started with SQL AI

Platform Overview

SQL AI is an all-in-one platform that helps you generate, explain, fix, and optimize SQL queries using artificial intelligence. Simply describe what you need in plain English and our AI translates it into production-ready SQL for your database of choice.

Whether you're a beginner learning SQL or an experienced developer looking to save time, SQL AI adapts to your skill level and provides the right output every time.

Key Features

SQL Generator — Convert natural language descriptions into SQL queries.
Query Explainer — Paste any SQL and get a clear breakdown of what it does.
Query Fixer — Identify and fix syntax errors, security issues, and bugs.
Query Optimizer — Get performance tips, index suggestions, and rewrites.
Data Converters — Convert CSV, Excel, and JSON files into SQL INSERT statements.

Quick Start

Create a free account at /register.
Select a tool from the dashboard (e.g., SQL Generator).
Choose your target database (MySQL, PostgreSQL, SQLite, or SQL Server).
Type your request in plain English and click Generate.
Review, copy, save, or share your query.

SQL Basics

SELECT — Retrieve Data

The SELECT statement retrieves data from one or more tables.

-- Select specific columns
SELECT first_name, last_name, email
FROM users
WHERE active = 1
ORDER BY created_at DESC
LIMIT 10;

INSERT — Add Data

The INSERT statement adds new rows to a table.

-- Insert a single row
INSERT INTO users (first_name, last_name, email)
VALUES ('Jane', 'Doe', 'jane@example.com');

-- Insert multiple rows
INSERT INTO users (first_name, last_name, email)
VALUES
    ('John', 'Smith', 'john@example.com'),
    ('Alice', 'Johnson', 'alice@example.com');

UPDATE — Modify Data

The UPDATE statement modifies existing rows. Always use a WHERE clause to avoid updating all rows.

-- Update a specific user
UPDATE users
SET email = 'newemail@example.com',
    updated_at = NOW()
WHERE id = 42;

DELETE — Remove Data

The DELETE statement removes rows from a table. Use with caution.

-- Delete inactive users older than 1 year
DELETE FROM users
WHERE active = 0
  AND last_login < DATE_SUB(NOW(), INTERVAL 1 YEAR);

Advanced Topics

Joins

Joins combine rows from two or more tables based on a related column. The most common types are INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

-- INNER JOIN: only matching rows
SELECT o.id, u.name, o.total
FROM orders o
INNER JOIN users u ON o.user_id = u.id;

-- LEFT JOIN: all left rows + matching right
SELECT u.name, COUNT(o.id) AS order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
GROUP BY u.name;

Subqueries

A subquery is a query nested inside another query. They can appear in SELECT, FROM, and WHERE clauses.

-- Find users with above-average order totals
SELECT name, email
FROM users
WHERE id IN (
    SELECT user_id
    FROM orders
    GROUP BY user_id
    HAVING AVG(total) > (SELECT AVG(total) FROM orders)
);

Indexes

Indexes speed up data retrieval by creating a fast lookup structure. Use them on columns frequently used in WHERE, JOIN, and ORDER BY clauses.

-- Create a standard index
CREATE INDEX idx_users_email ON users (email);

-- Create a composite index
CREATE INDEX idx_orders_user_date
ON orders (user_id, created_at DESC);

Transactions

Transactions group multiple operations into a single atomic unit. Either all succeed or all are rolled back.

BEGIN TRANSACTION;

UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;

-- If both succeed
COMMIT;

-- If something goes wrong
-- ROLLBACK;

Best Practices

Use parameterized queries to prevent SQL injection attacks.
Avoid SELECT * — specify only the columns you need.
Normalize your schema to reduce data redundancy and improve integrity.
Use EXPLAIN to analyze query execution plans and optimize performance.
Add indexes strategically on columns used in WHERE, JOIN, and ORDER BY.