Tools Navigation

SQL to AST Visualizer

See how a SQL statement parses by converting it into a JSON AST. Great for analysis and tooling experiments.

SQL input

AST (JSON)

[
  {
    "with": null,
    "type": "select",
    "options": null,
    "distinct": null,
    "columns": [
      {
        "expr": {
          "type": "column_ref",
          "table": "u",
          "column": "id",
          "collate": null
        },
        "as": null
      },
      {
        "expr": {
          "type": "column_ref",
          "table": "u",
          "column": "email",
          "collate": null
        },
        "as": null
      }
    ],
    "into": {
      "position": null
    },
    "from": [
      {
        "db": null,
        "table": "users",
        "as": "u"
      }
    ],
    "where": {
      "type": "binary_expr",
      "operator": "=",
      "left": {
        "type": "column_ref",
        "table": "u",
        "column": "active",
        "collate": null
      },
      "right": {
        "type": "bool",
        "value": true
      }
    },
    "groupby": null,
    "having": null,
    "orderby": [
      {
        "expr": {
          "type": "column_ref",
          "table": "u",
          "column": "created_at",
          "collate": null
        },
        "type": "DESC"
      }
    ],
    "limit": null,
    "locking_read": null,
    "window": null,
    "collate": null
  }
]

This visualizer parses SQL into an abstract syntax tree (AST). Complex vendor-specific syntax may not parse.

How to use this tool

Paste SQL
View the AST output
Copy as JSON

How to Use

Paste a SQL query and view the parsed AST. Copy the AST JSON if you need it for debugging.

How It Works

A client-side SQL parser generates an abstract syntax tree (AST) from your input and prints it as JSON.

Key Features

AST output
Copy JSON
Client-side parsing

Secure & Private

Local parsing only. No network calls for your SQL content.

Frequently Asked Questions

Why doesn’t my SQL parse?

Some vendor-specific syntax isn’t supported by the parser. Try simplifying or switching to a more standard form.

Is the AST standardized?

AST shape depends on the parser library. It’s designed for programmatic analysis.

Related Tools

SQL Formatter

Format SQL queries for readability (Postgres/MySQL/SQLite/T-SQL).

Privacy Notice

All processing happens inside your browser. No files or data are uploaded to our servers, ensuring your privacy is strongly protected.