AI SQL Generator

Describe your data query in plain English and Claude AI generates the correct SQL query. Supports SELECT, INSERT, UPDATE, DELETE, JOINs, subqueries, and aggregations.

API Setup Required

AI tools need a backend API route to work. This prevents CORS errors from calling Anthropic directly from the browser.

Quick Setup (3 steps)

1

Create API route

app/api/ai/route.ts
2

Add your API key

.env.local → ANTHROPIC_API_KEY=sk-ant-...
3

Enable in component

AIToolBase.tsx → AI_ENABLED = true
app/api/ai/route.tsCopy & paste
import Anthropic from "@anthropic-ai/sdk";
import { NextRequest, NextResponse } from "next/server";

const client = new Anthropic({
  apiKey: process.env.ANTHROPIC_API_KEY,
});

export async function POST(req: NextRequest) {
  const { system, prompt } = await req.json();
  const msg = await client.messages.create({
    model: "claude-sonnet-4-20250514",
    max_tokens: 1024,
    system,
    messages: [{ role: "user", content: prompt }],
  });
  const text = msg.content[0].type === "text"
    ? msg.content[0].text : "";
  return NextResponse.json({ text });
}
npm install @anthropic-ai/sdk

Frequently Asked Questions

Which SQL dialects are supported?
MySQL, PostgreSQL, SQLite, SQL Server, and standard ANSI SQL.
Can it generate complex queries with JOINs?
Yes. Describe your tables and relationships and it generates the full query.