SQL Tools
From generating INSERT statements to building SELECT queries visually, these SQL tools eliminate the manual work of writing boilerplate SQL. Every tool runs entirely client-side — your database credentials and query data never leave your browser.
- SQL MinifierRemove whitespace and comments from SQL queries to produce compact, single-line output.
- JSON → SQL INSERT GeneratorConvert a JSON object or array into SQL INSERT statements. Strings are quoted, numbers unquoted, nulls become NULL.
- CSV → SQL INSERT GeneratorConvert CSV data into SQL INSERT statements. Numbers are auto-detected; the header row becomes the column list.
- SQL Query BuilderBuild SELECT queries visually — choose columns, add WHERE conditions, ORDER BY, and LIMIT without writing SQL by hand.
- SQL IN Clause GeneratorPaste a list of values (one per line) and get a correctly formatted SQL IN clause. Numbers are automatically unquoted.
- SQL WHERE Clause GeneratorConvert key=value pairs into a SQL WHERE clause with AND-joined conditions. Handles strings, numbers, and booleans.
- SQL Table CreatorGenerate CREATE TABLE DDL from plain field definitions. Supports MySQL, PostgreSQL, MS SQL Server, and SQLite with auto-increment PK.
- SQL UPDATE Query GeneratorGenerate UPDATE statements from key=value pairs. Set the table name and WHERE condition to target the correct rows.
- SQL DELETE Query GeneratorGenerate DELETE or TRUNCATE statements. Choose between single row (by PK), custom WHERE condition, or full table truncation.
- SQL → JSON ConverterConvert MySQL CLI table output (with +--+ borders), tab-separated, or pipe-separated SQL results to a JSON array.
- SQL Escape String ToolEscape or unescape SQL string values — single quotes are doubled per the SQL standard. Includes escape and unescape modes.
- SQL Case ConverterConvert SQL keywords to UPPERCASE or lowercase while leaving column names, table names, and string values unchanged.
- MongoDB → SQL ConverterConvert MongoDB queries (find, insert, update, delete) to SQL. Supports $gt, $lt, $in, $regex, .sort(), .limit(), and projections.
- SQL JOIN BuilderBuild SQL JOIN queries visually — choose join type (INNER, LEFT, RIGHT, FULL), ON condition, columns, WHERE, ORDER BY, and LIMIT.
- SQL UPSERT GeneratorGenerate INSERT ON DUPLICATE KEY UPDATE (MySQL), ON CONFLICT DO UPDATE (PostgreSQL), INSERT OR REPLACE (SQLite), or MERGE (MSSQL).
- SQL ALTER TABLE GeneratorGenerate ALTER TABLE DDL for MySQL, PostgreSQL, MSSQL, and SQLite. Add, modify, drop, rename columns; manage indexes and constraints.
- SQL Pagination GeneratorGenerate paginated SQL for any database — LIMIT/OFFSET (MySQL/PostgreSQL), OFFSET FETCH NEXT (MSSQL), ROWNUM (Oracle). Includes count query.
- SQL Type MapperCross-database type reference table — compare MySQL, PostgreSQL, MS SQL Server, SQLite, and Oracle type equivalents for 20 common types.
- SQL Stored Procedure TemplateGenerate stored procedure and function scaffolding for MySQL, PostgreSQL, and MS SQL Server. Includes correct DELIMITER / $$ / BEGIN syntax.
- SQL GRANT / REVOKE GeneratorGenerate GRANT and REVOKE permission statements for specific tables, databases, or all schemas. Select individual privileges or ALL PRIVILEGES.
- SQL → PHP Array ConverterConvert MySQL CLI output (+--+ borders), tab-separated, or pipe-separated SQL results into a PHP associative array ready to paste into code.