Run SQL on real PostgreSQL or SQLite
check_sqlValidate SQL statements against in-memory PostgreSQL 18 and SQLite 3.49 engines: load your schema, catch errors with line and hint, inspect rows, and compare dialects.
Instructions
Runs SQL on real PostgreSQL 18 or SQLite 3.49 in memory, after your schema (DDL, migrations, sample INSERTs). Each statement gets the engine's verdict: error with line, column and hint, constraint violations, or the rows it returns (up to max_rows). All inside a rolled-back transaction. dialect both compares the two.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | the statements to check | |
| schema | No | CREATE TABLE statements, migrations and sample rows, run first | |
| dialect | No | default postgres | |
| max_rows | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| results | Yes |