Handy Dev Tools
Simple online tools for everyday tasks.

No favorites

    Base64 Encoder/Decoder
    Markdown to HTML
    HTML to Markdown
    URL Encoder/Decoder
    Unicode Escape Converter
    Unicode Encode/Decode
    SQL Formatter
    SQL Splitter
    JSON Formatter
    XML Formatter
    YAML Formatter
    GraphQL Formatter
    JSON to YAML Conversion
    YAML to JSON Conversion
    JSON to TOML Conversion
    TOML to JSON Conversion
    HTML Entity Encode/Decode
    TOML to YAML Conversion
    YAML to TOML Conversion
    CSV to SQL INSERT Conversion
    Markdown Table Generator
    JSON to XML Conversion
    XML to JSON Conversion
    UUID Generator
    ULID Generator
    Password Generator
    Hash Generator
    Lorem Ipsum Generator
    Lorem Picsum Image URL Generator
    Test Data Generator Tool
    QR Code Generator
    S3 Path Parser & Converter
    IP Address Calculator
    Subnet Split
    Subnet Consolidation
    CloudFront Signed URL Generator
    RDS Connection String Generator
    Coordinate Format Converter
    Geo Format Converter
    JWT Decoder & Parser
    Basic Auth
    Password Strength Analyzer
    Credit Card Validator
    RSA Key Pair Generator
    Case Conversion
    Romaji Conversion
    Roman Numeral Conversion
    Phonetic Code Conversion
    Character Counter
    Text Diff
    HTML Tag Remover
    Regex Tester
    Color Conversion
    Dice Roll
    Crontab generator
    Crontab parser
    Emoji Picker
    Unix Timestamp Converter
    HTTP Status Code Search
    Port Number Search
    MIME Type Lookup
    Base64 File Converter
    Image Base64 Encode/Decode
    User-Agent Parser
    URL Parser
    OGP Checker
    Commit Message Generator
    Chmod Calculator
    Terminal GIF Generator
    .env Parser & Validator
Ctrl+K

SQL Splitter

SQL splitter tool. Enter a string containing multiple SQL queries in the text input field and split them into individual SQL queries.

SQL Data

How to use

About this tool

Splits multiple SQL statements by semicolons into separate statements.

How to use

Paste multi-statement SQL; view split results for easier copy or execution per statement.

Use cases

• Splitting migrations/seed data • Extracting queries from logs • Breaking down batches

FAQ

Q: How does the splitter detect statement boundaries?
A: Statements are split on semicolons (;). The tool is aware of quoted strings and comments, so semicolons inside string literals (e.g. 'hello; world') or comments (-- ; or /* ; */) are not treated as boundaries.
Q: Can I use this to split migration files?
A: Yes. Paste the entire migration file and each CREATE TABLE, ALTER TABLE, INSERT, or other statement will be separated so you can inspect or execute them individually.
Q: What should I do with stored procedures or triggers that contain semicolons?
A: Stored procedures and triggers use semicolons internally. If your SQL uses DELIMITER to change the statement terminator (e.g. DELIMITER //), split manually at the DELIMITER boundary first, then use this tool for each block.
Q: Are empty statements (just a semicolon) included in the output?
A: No. Empty statements resulting from consecutive semicolons or trailing semicolons are automatically filtered out.
Q: Does this tool send my SQL to a server?
A: No. All processing is performed entirely in the browser. Your SQL is never sent to any server.