SQL Generation

Turn plain-English questions into correct SQL against a schema. The skill behind analytics chat, natural-language dashboards, and 'just ask the database' interfaces.

Duration

Input Tokens

1022

Output Tokens

220

Cost

$0.00

Context

Input

Create a new table where I can store how much we pay instructors each month.

Expected output

CREATE TABLE instructor_payouts ( instructor_id INT REFERENCES users(user_id), payout_month DATE, amount DECIMAL(10, 2), PRIMARY KEY (instructor_id, payout_month) );

Model output

CREATE TABLE instructor_payments (
    payment_id SERIAL PRIMARY KEY,
    instructor_id INT REFERENCES users(user_id),
    amount DECIMAL(10, 2) NOT NULL,
    payment_date DATE NOT NULL,
    month_year DATE NOT NULL,
    payment_method TEXT,
    notes TEXT,
    created_at TIMESTAMP DEFAULT NOW(),
    CONSTRAINT fk_instructor CHECK (instructor_id IN (SELECT user_id FROM users WHERE role = 'instructor'))
);

CREATE INDEX idx_instructor_payments_month ON instructor_payments(month_year);