Stmtk Tool -
With stmtk parse , you get an AST (Abstract Syntax Tree) dump. It shows you exactly where the parser breaks, what token it expected, and even visualizes the nested structure. It turns guesswork into a science. You just received a SQL script from a vendor. It looks fine, but you don’t trust it. Before you run psql or sqlplus , run:
We spend a lot of time talking about massive data pipelines, cloud warehouses, and complex ETL frameworks. But what about the humble SQL statement? The single SELECT , the 50-line UPDATE , or the terrifying MERGE that runs once a quarter? stmtk tool
It treats SQL as code , not just as a string to ship over a wire. For platform engineers, DBREs, and backend developers who hate guessing games, stmtk is a breath of fresh air. With stmtk parse , you get an AST
curl -sSL https://get.stmtk.dev | sh
echo "SELECT * FROM orders WHERE total > 100" | stmtk analyze --dialect generic stmtk won't replace your database monitoring stack. It won't tune your work_mem for you. But it will fill the gap between "I typed a query" and "The query ran." You just received a SQL script from a vendor
Copy the slow query from logs -> Paste into EXPLAIN -> Stare at sequential scan -> Guess which index to add -> Deploy -> Pray.