Skip to content
BEAD

SQL INSERT Generator

Convert CSV / TSV / JSON into INSERT INTO statements — multi-row VALUES or one statement per row.

DeveloperConverters
Generated SQL (3 rows)
</>Use this tool programmaticallycurl · JavaScript · MCP

Same tool, callable from any HTTP client or from Claude (via MCP). Anonymous: 100 req/day per IP. Sign up for 1,000 req/day.

curl
curl https://api.b-e-a-d.com/tools/sql-insert-generator/run \
  -H "Content-Type: application/json" \
  -d '{
  "input": "your input here",
  "tableName": "a",
  "style": "multi",
  "emptyAsNull": true,
  "includeColumns": true
}'
JavaScript (fetch)
const res = await fetch("https://api.b-e-a-d.com/tools/sql-insert-generator/run", {
  method: "POST",
  headers: { "Content-Type": "application/json" },
  body: JSON.stringify({
  "input": "your input here",
  "tableName": "a",
  "style": "multi",
  "emptyAsNull": true,
  "includeColumns": true
}),
});
const data = await res.json();
console.log(data.result);
MCP (Claude Desktop / Claude Code)
# In Claude Desktop / Claude Code, add to your MCP config:
{
  "mcpServers": {
    "bead": {
      "command": "npx",
      "args": ["-y", "mcp-remote", "https://mcp.b-e-a-d.com"]
    }
  }
}

# Then ask Claude to call:
mcp__bead__bead_sql_insert_generator

Full reference: developer docs · OpenAPI spec

Output styles

  • One per row — easiest to diff, slowest to load
  • Multi-row VALUES — one INSERT, many tuples (MySQL / PostgreSQL / SQLite)
  • Per-row, with column list — most explicit; survives column re-ordering

Type handling

Numbers are emitted bare. Booleans become TRUE/FALSE. Empty cells become NULL when the column allows it; otherwise an empty string. Everything else is single-quoted with ' escaped per ANSI.

You might also like

Used in these workflows