Back to News
toolsdevelopersqlcsv

New Advanced Tools: Diagram Editor, CSV Viewer, .env Parser and SQL Type Generator

Four new power tools for developers — diagram as code, interactive CSV editing, .env validation and automatic TypeScript type generation from SQL schemas.

Saturday, June 20, 20262 min read4 views

Advanced Developer Tools

Mermaid Diagram Editor

The Mermaid Diagram Editor renders flowcharts, sequence diagrams, class diagrams, ERDs, Gantt charts, pie charts, state machines and mind maps from text syntax in real time.

Type your Mermaid code on the left and see the diagram update live on the right. Eight templates cover the most common diagram types. Export as SVG (vector, scales perfectly) or PNG (raster, for presentations and documents).

This directly competes with paid tools like Mermaid Live, Lucidchart and draw.io for simple diagrams.

CSV Viewer and Editor

The CSV Viewer loads any CSV file into a live interactive table. Sort by any column, filter rows with a search box, and edit cells inline by clicking them. Add and delete rows and columns without leaving the browser.

Auto-detects the delimiter (comma, semicolon, tab, pipe). Export back to CSV, JSON or SQL INSERT statements with a custom table name.

.env File Parser

The .env Parser takes any .env file and displays variables in a clean table with key, value, type detection and secret masking. Detects duplicate keys, missing values, invalid key names and other common mistakes.

Export to JSON, YAML, shell export syntax, Docker -e flags or TOML. Secret values are masked by default — toggle visibility with one click.

SQL to TypeScript Types

The SQL to TypeScript tool converts CREATE TABLE SQL statements to five output formats automatically:

  • TypeScript interfaces — clean export interface User { ... }
  • Zod schemas — full z.object() with .nullable().optional() where applicable
  • Prisma models — ready to paste into schema.prisma
  • Drizzle ORMpgTable() definitions with inferred types
  • TypeORM entities — decorated @Entity() class syntax

Supports PostgreSQL, MySQL and SQLite. Handles SERIAL/AUTO_INCREMENT, UUID, TIMESTAMP, JSONB, BOOLEAN and all standard types.