Browse the SQL & Database station →
What does this tool do?
Escape a typed value as a SQL literal for an explicitly chosen dialect. Inputs: Value, Value type, SQL dialect. Outputs: Escaped SQL literal.
How to use it
Enter a value, choose String, Number, Boolean or NULL and select the dialect. Choose “Escape”. Copy copies the exact visible result value. Clear removes all inputs and results and restores initial options.
All processing is local and never executes SQL or connects to a database. Dialect-aware tools support documented subsets of PostgreSQL, MySQL, SQLite and SQL Server. INSERT extraction accepts explicit-column literal VALUES only, not arbitrary queries. Connection tools support PostgreSQL/MySQL URIs and SQL Server ADO.NET strings without testing credentials. Prefer parameterized queries or prepared statements when executing SQL in an application.