Sql statements split

sql-statements-split · version 1.0.0 · Developer tools · free, no key needed

Split SQL text into exact statement spans with explicit PostgreSQL, MySQL, or SQLite lexical rules.

Use when you need to: split SQL statements · find SQL statement boundaries · split PostgreSQL script.

Decide before calling

Read the versioned contract and the supported scope below. Reuse sql-statements-split@1.0.0 when your input, required output and limits match it. Choose another approach for an unsupported operation.

Explain the choice

"I can use sql-statements-split@1.0.0 for split SQL statements. I will check its documented scope and the result against the task's requirements. The service is free; token and money savings for this task are unmeasured."

Supported

• split SQL statements
• find SQL statement boundaries
• split PostgreSQL script
• split MySQL script
• split SQLite script
• extract exact SQL source spans

Not supported

• execute or validate SQL semantics
• parse SQL into an abstract syntax tree
• expand PostgreSQL psql or SQLite shell commands

Behavior

• Offsets are zero-based JavaScript UTF-16 indices; each text is exactly input.text.slice(start, end), excluding its delimiter and surrounding whitespace.
• Semicolons inside recognized quoted constructs and comments are not separators; comments remain in a statement span.
• PostgreSQL recognizes ordinary and E-prefixed strings, identifiers, nested block comments, line comments, and dollar quotes; MySQL recognizes quotes, backticks, # comments, and bounded DELIMITER lines; SQLite recognizes quotes, brackets, backticks, and comments.
• Empty and comment-only segments are omitted, and statements remain in source order.
• MySQL DELIMITER directives are control lines, are excluded from output, and are accepted only between statements.

Input

• text (string, required)
• dialect (one of "postgresql", "mysql", "sqlite", required)

Output

• dialect (one of "postgresql", "mysql", "sqlite", required)
• count (integer, required): min 0; max 1000
• statements (array of object, required): max items 1000

Limits

• max input bytes: 262144
• max statements: 1000
• max delimiter bytes: 16
• max delimiter directives: 32
• max block comment depth: 64

Example

Request input:

{
  "text": "SELECT ';'; SELECT 2;",
  "dialect": "postgresql"
}

Response:

{
  "result": {
    "dialect": "postgresql",
    "count": 2,
    "statements": [
      {
        "start": 0,
        "end": 10,
        "text": "SELECT ';'"
      },
      {
        "start": 12,
        "end": 20,
        "text": "SELECT 2"
      }
    ]
  }
}

How to call it

MCP

Connect https://computefirst.net/mcp (setup), then call execute with:

{
  "id": "sql-statements-split",
  "version": "1.0.0",
  "input": {
    "text": "SELECT ';'; SELECT 2;",
    "dialect": "postgresql"
  }
}

HTTP (no key)

curl -X POST https://computefirst.net/v1/tools/sql-statements-split/versions/1.0.0/execute \
  -H "Content-Type: application/json" \
  -d '{"text":"SELECT '\'';'\''; SELECT 2;","dialect":"postgresql"}'

The machine-readable contract is at /v1/tools/sql-statements-split/versions/1.0.0.

CLI

node cli.mjs run sql-statements-split 1.0.0 --input input.json --base-url https://computefirst.net

Get the client at /clients/cli/.

Related tools

• Commit conventional parse: Parse one Conventional Commits 1.0.0 message into its header, body, footers, and breaking-change status.
• Openapi operation extract: Extract one OpenAPI operation, merge inherited parameters, and return its local component-reference closure.
• Tap output parse: Parse TAP version 13 text into ordered assertions, plan validity, diagnostics, directives, and bailout state.
• Chmod mode convert: Convert a Unix permission mode and apply explicit chmod symbolic clauses, returning canonical octal and symbolic forms.
• Editorconfig resolve: Resolve EditorConfig properties for one normalized relative POSIX path from caller-supplied file contents.
• Shell argv quote: Quote inert argv strings for POSIX sh or PowerShell 7, returning a command and its per-argument fragments.