codemirror-sql
by marimo
A CodeMirror extension for SQL with real-time syntax validation and error diagnostics using node-sql-parser.
SQL Editor with Diagnostics
Try typing invalid SQL syntax to see real-time error highlighting and messages. Valid tables are: users, posts, orders, customers, categories
Example Queries
Click any example to load it into the editor:
Valid Queries
Invalid Queries (will show errors)
Features
Real-time Validation
SQL syntax is validated as you type with a configurable delay (750ms default).
Error Highlighting
Syntax errors are highlighted with red underlines and detailed error messages.
Multiple SQL Dialects
Supports MySQL, PostgreSQL, MariaDB, SQLite, Snowflake, and DuckDB syntax validation.
DuckDB Support
Special support for DuckDB-specific syntax like "from table select * limit 100".
TypeScript Support
Full TypeScript support with comprehensive type definitions.