Arrow keys choose a result; Enter opens it. Tab reaches each link.
JSON Formatter
Tools for focused sql & database work.
17 tools. Use Control or Command K to search from any page.
Format SQL with readable indentation for an explicitly selected SQL dialect.
Reduce SQL layout whitespace while preserving string literals and token boundaries.
Check supported SQL syntax and view its validity, syntax error and error location locally.
Convert a JSON array of objects into dialect-aware SQL INSERT statements.
Convert supported literal SQL INSERT statements into a JSON array of objects.
Convert a CSV header and data rows into dialect-aware SQL INSERT statements.
Convert supported literal SQL INSERT statements to CSV text with a header row.
Convert supported literal SQL INSERT statements into a readable Markdown table.
Build a SQL INSERT statement from explicit columns and typed row values.
Build a SQL UPDATE statement with typed assignments and explicit WHERE conditions.
Build a SQL DELETE statement with optional explicit WHERE conditions and an all-rows warning.
Build a SQL SELECT statement from columns, typed conditions, ordering and an optional limit.
Build a standalone SQL WHERE clause from typed conditions joined with AND or OR.
Build a PostgreSQL, MySQL or SQL Server connection string locally from explicit connection fields.
Inspect supported PostgreSQL, MySQL or SQL Server connection strings while keeping the password masked.
Generate a local entity relationship diagram from supported CREATE TABLE statements.
Escape a typed value as a SQL literal for an explicitly chosen dialect.