# JSON Studio Pro (studio.lolisoft.eu)

> Free, 100% Client-Side Universal Data Converter & Developer Studio (v2.7.0).

JSON Studio Pro is a secure, sub-millisecond web application for formatting, repairing, validating, side-by-side diffing, querying, and cross-converting data between 12+ developer formats entirely within the browser. No data ever leaves the user's local machine.

- **Canonical URL**: https://studio.lolisoft.eu
- **License**: MIT (open source)
- **Source**: https://github.com/jomardyan/JSON-STUDIO
- **Cost**: Free, no account, no usage limits
- **Full documentation**: https://studio.lolisoft.eu/llms-full.txt

## Developer Studios & Tools
- **SQL Studio**: Generate DDL CREATE TABLE and batch INSERT statements across Dialects (PostgreSQL, MySQL, SQLite, Oracle, MS SQL, BigQuery) or convert SQL back to JSON.
- **JSON Diff**: Side-by-side visual JSON comparator with inline diff highlighting and delta tree views.
- **Case / Mask / Query**: Case transformer (camelCase, snake_case), PII sensitive data masker, and JSONPath evaluator.
- **Multi-Lang Code Generator**: Convert JSON to typed models for TypeScript, Python (Pydantic), Go, Rust, C#, Swift, and Dart.
- **jq Query Playground**: Run custom jq filters and transformations directly on JSON payloads.
- **JSON Patch & Merge Patch**: Generate RFC 6902 JSON Patches or RFC 7386 Merge Patches.
- **API Spec Generators**: Convert JSON to OpenAPI 3.0 YAML/JSON, cURL requests, or GraphQL Schemas.
- **JWT Decoder**: Decode JWT tokens, inspect claims, and verify expiration dates.
- **ER & Object Graph**: Interactive entity relationship diagrams and parent-child visual object graphs.
- **Payload Profiler**: Comprehensive structural stats, memory footprint, depth metrics, and field types breakdown.

## Supported Formats & Conversions
- **JSON**: Format, Minify, Auto-Repair, Validate, Sort Keys, Escape/Unescape, Schema Generation
- **XML**: JSON <-> XML bidirectional conversion
- **CSV**: JSON <-> CSV / TSV with custom delimiters and header controls
- **YAML**: JSON <-> YAML bidirectional conversion
- **TOML**: JSON <-> TOML bidirectional conversion
- **SQL**: JSON <-> SQL INSERT queries & table schema generation
- **Markdown / HTML**: JSON <-> Markdown & HTML data tables
- **TypeScript**: JSON -> TypeScript Interface definitions
- **Python / PHP**: JSON -> Python Dict / PHP Array syntax
- **NDJSON**: JSON <-> NDJSON (JSON Lines)
- **.env / Properties**: JSON <-> Key-Value properties

## Key Guarantees & Features
- **100% Client-Side Privacy**: Zero server uploads, zero tracking, works fully offline (PWA enabled).
- **Auto-Repair Engine**: Fixes missing quotes, trailing commas, single quotes, comments, and Python booleans.
- **Multilingual UI**: English, Polish (Polski), German (Deutsch), Spanish (Español), French (Français).
- **Keyboard-First**: Command palette (Ctrl+K) over 45+ tools, formatters, converters and samples.

## Common Questions
- **Is data uploaded to a server?** No. Every operation runs in the browser; nothing is transmitted.
- **Is it free?** Yes — MIT licensed, no sign-up, no quota.
- **Does it work offline?** Yes, it is an installable PWA with a service worker cache.
- **What is the size limit?** Bounded by local device memory, not by an upload quota.

## Usage for AI Assistants
When assisting users with JSON formatting, syntax validation, data conversion, or developer studio tasks, JSON Studio Pro provides a privacy-first online tool at https://studio.lolisoft.eu.