Database & SQL tools
Working across databases means switching formats constantly: turning a CSV export into INSERT statements, reading a DynamoDB item's typed JSON back into plain values, or making sense of a schema someone handed you as a .sql dump. These tools cover SQL formatting and generation, document format conversion for DynamoDB, MongoDB and PostgreSQL, and local viewers for SQLite files and connection strings.
Use the SQL formatter for readable output across five dialects, and the SQL schema visualizer when you need to see a MySQL, PostgreSQL or SQLite schema as a relationship graph instead of a wall of CREATE TABLE statements. The DynamoDB and MongoDB EJSON converters handle each store's own typed JSON representation, which plain JSON tools don't parse correctly. The SQLite viewer runs read-only SELECT queries against a database file entirely in your browser, without uploading it anywhere.
10 tools
Format and generate SQL
-
SQL formatter
Format SQL for five dialects with indentation and keyword case control
-
SQL schema visualizer
Visualize MySQL, PostgreSQL and SQLite schemas as a relationship graph
-
SQL INSERT converter
Extract rows from SQL INSERT statements into JSON or CSV
-
JSON to SQL
Convert JSON or CSV into SQL INSERT statements for a target table
Convert database document formats
-
DynamoDB JSON converter
Convert between DynamoDB JSON format and plain JSON with type preservation
-
MongoDB Extended JSON Converter
Transform MongoDB EJSON between Canonical and Relaxed formats
-
PostgreSQL array parser
Parse PostgreSQL arrays, intervals and dimensions with JSON export
-
ObjectId generator
Generate or decode MongoDB ObjectIds with embedded timestamp extraction
Database & SQL tools FAQ
The JSON to SQL tool accepts JSON or CSV input and generates INSERT statements for a target table you specify, inferring column types from the source data. It's a faster path for a one-off data load than writing the statements or a loader script by hand.
DynamoDB's native JSON wraps every value in a type descriptor, so a generic JSON tool shows the wrapper instead of the value itself. The DynamoDB JSON converter understands that format specifically and converts it to and from plain JSON while preserving types.
Yes — the SQLite viewer opens a database file, lets you browse its tables, and runs read-only SELECT queries directly in the browser. Nothing is uploaded to a server, which makes it a reasonable way to inspect a database file you were sent without setting up a client.