What’s new in Developer tools Close Version 0.7.0 latest New tool: the SQL formatter. Paste a query or a whole script and it is laid out clause by clause, with subqueries, CASE and procedure bodies indented. MySQL, T-SQL (SQL Server), PostgreSQL and standard SQL are recognised by themselves, or you choose one; strings and comments stay exactly as you wrote them. Fold any block with the arrow on its left, or fold everything at once. Comment a block out with "--" and back in with one click, or add your own comment above any line. Choose -- lines or /* */ blocks under Options. Search the result as text, as a whole word or with a regular expression, and jump from match to match; folded blocks open by themselves. Choose upper or lower case keywords, the indent, where commas and AND / OR go, and blank lines between statements. Copy the result or download it as a .sql file. Own pages: /sql/mysql, /sql/tsql, /sql/postgresql and /sql/standard. Version 0.6.1 The toolbar and the row of tools now stay at the top while you scroll, so every tool is one click away from anywhere on the page. Version 0.6.0 New tool: the image decoder. Paste Base64, a data URI, hex or Base32, or a whole HTML, CSS or JSON snippet: the pictures inside are found, shown on a checkerboard and named by their real type, with their size and dimensions. A wrong claimed type is pointed out, and a file that is not a picture (a PDF, a ZIP) is named and can be downloaded. Download the picture, copy it as a data URI, or convert it to PNG, JPEG or WebP with the quality you choose. "Image to Base64": choose a picture and get its Base64, data URI, HTML <img> and CSS url(). Own pages: /image/base64-to-image and /image/image-to-base64. Version 0.5.0 New tool: the hash generator. MD5, SHA-1, SHA-256, SHA-384, SHA-512 and CRC32 of text or of a file (up to 100 MB, read in your browser), several at once, as hex, HEX, Base64 or Base64URL. Add an HMAC key or a salt, or derive a key from a password with PBKDF2. Paste an expected hash to see whether it matches. Keys and salts are masked and never leave the page. Every algorithm has its own page, for example /hash/sha256 or /hash/hmac. A row under the toolbar now links to every tool, so you can switch in one click. The usage statistics page for admins opens again. Version 0.4.0 Check a JWT's signature: paste the shared secret (as text, Base64 or hex) for HS256, HS384 and HS512, or the public key as PEM or JWK for RS, PS, ES and EdDSA tokens. You see at once whether the token was signed with that key and left unchanged. The secret or key stays in the page: it is masked, never saved and never sent. Version 0.3.0 Every format of the encoder and every JSON feature now has its own page (for example /encode-decode/base64, /encode-decode/jwt, /json/validator), so you can go straight to it. Something did not work? Each tool has a "Tell us" form. You can choose to include a sample of your input; it is off by default, you see and can edit exactly what is sent, and it is kept for 90 days for the DevQuake team only. We now count which tools and buttons are used and whether they worked, to improve them. What you type, paste or open is still never sent. Version 0.2.0 New tool: the encoder and decoder. Paste something encoded and it recognises the format and decodes it, saying how sure it is: Base64, Base64URL, Base32, hex, URL encoding, HTML entities, Unicode escapes, Punycode domain names, data URIs, Basic authorization headers and JWTs. When it cannot tell, it says so and lets you choose the format, with the reasons the nearest ones did not fit. Results that are encoded again can be decoded again, step by step. Encode text into any of these formats, with options such as the text encoding, Base64 padding and line length, or how hex bytes are separated. A JWT shows its header, its content and its times in your time zone, and warns when it has expired or has no signature. A URL is taken apart, with a table of its parameters you can edit. Decoded pictures and files show a preview or their type, and can be downloaded. Version 0.1.0 The developer tools are here, starting with the JSON formatter and validator: format, minify and check JSON, see the exact line and column of a mistake, and explore it as a tree whose paths you can copy. Everything runs in your browser: nothing you type, paste or open is sent anywhere or stored. Your browser remembers only your options, and when you are signed in you can keep them in your DevQuake account.