MySQL Parser for Java and .NET

MySQL that GSP parses

CREATE PROCEDURE sync_totals()
BEGIN
  DECLARE done INT DEFAULT 0;
  UPDATE totals t JOIN orders o ON o.cid = t.cid SET t.amt = o.amt;
END

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvmysql);
parser.sqltext = sql; // the MySQL above
if (parser.parse() == 0) {
    System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
    System.out.println(parser.getErrormessage());
}

Parse it in C#

using gudusoft.gsqlparser;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvmysql);
parser.sqltext = sql; // the MySQL above
if (parser.parse() == 0)
{
    Console.WriteLine(parser.sqlstatements.size() + " statement(s) parsed");
}
else
{
    Console.WriteLine(parser.Errormessage);
}

Same grammar, .NET-idiomatic API — properties instead of Java getters. See the C# quick start or the .NET SQL Parser SDK.

What GSP handles in MySQL

• Stored procedure blocks
• Cursors and loops
• LOAD DATA statements
• PREPARE/DEALLOCATE prepared statements
• SHOW and OPTIMIZE TABLE
• Procedural SQL: Stored procedures, functions, and triggers with DECLARE, cursors (OPEN/FETCH), and LOOP/REPEAT/WHILE control flow

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for MySQL.

Recent MySQL parser updates

• 2026-06-02 [MySQL] Degrade STRAIGHT_JOIN to INNER in semantic IR
• 2026-05-23 [PG, MSSQL, Snowflake, Oracle, MySQL] Admit UPDATE SET-RHS correlated scalar subqueries
• 2026-05-16 [MySQL] Self-reference DELETE admission

Full history in the release notes.