nickdeis.github.io

validate_sql

Runs the DDL against a scratch Postgres (nothing is kept) and reports whether it is valid. On failure it throws with the Postgres message and line number. The editor holds the COMPLETE Postgres DDL script for the diagram, and it is always run against an empty database: an ALTER only works if the CREATE it modifies is in the same script. Extensions available: pg_trgm, btree_gin, btree_gist, vector. COMMENT ON statements appear in the diagram.

Page: /webmcp-pglite-erd-diagram/

Input schema

{
  "type": "object",
  "properties": {
    "sql": {
      "type": "string",
      "description": "The complete DDL script."
    }
  },
  "required": [
    "sql"
  ],
  "additionalProperties": false
}