Softwium

About Softwium

Softwium's SQL validator is a browser-based tool for checking MySQL syntax in SQL queries. It scans SELECT, INSERT, UPDATE, and DELETE statements for syntax errors such as unclosed parentheses, mistyped keywords, or missing terms, and highlights the specific line where an error occurs. It is built on the SQL parser library used by phpMyAdmin since version 4.5.

The tool is aimed at database administrators, developers, and analysts who work with structured datasets and want to catch syntax errors before executing a query, particularly for large or complex SQL statements where manual review is time-consuming. It focuses on MySQL syntax specifically, noting that syntax can vary in other database systems such as PostgreSQL or DB2.

A POST API endpoint (/sql-syntax-tester) is also available, accepting a SQL query as payload and returning a list of syntax errors with message, token, line, and column information, or an empty response if no errors are found. The page notes the API should be used sparingly.

Key features

• Validates SQL syntax and highlights the specific line with the error
• Checks SELECT, INSERT, UPDATE, and DELETE statements for syntax violations
• Detects common mistakes like unclosed parentheses, mistyped keywords, or omitted terms
• Focuses on MySQL syntax validation
• Built on the SQL parser library used in phpMyAdmin since version 4.5
• Offers an API endpoint (POST /sql-syntax-tester) that returns a list of syntax errors

Frequently asked questions