Plugin Center

Data Converter

v0.2.1

icefoxs · MIT · updated Nov 1, 2026

About

Convert anything in one DBX workbench panel: 13 formats (JSON / YAML / XML / Properties / TOML / INI / .env / CSV / TSV / Query / Headers / Cookie / HTML) in any combination, JSONPath / jq queries with JSON Schema validation, eight escape tools (URL / Base64 / HTML / JSON / Unicode / Hex / SQL / Regex), batch text to SQL (IN / NOT IN / INSERT — ideographic commas, full-width commas and pipes all split, whitespace cleaned up afterwards), select anything in any editor and right-click to encode, clean up, build SQL or copy it as a QR image — results go straight to the clipboard, .xlsx / .csv / .tsv to JSON, Image ⇄ Base64, and a Byte Converter (B/KB/MB/GB/TB/PB on both the 1000 and 1024 scales, exact ⇄ human readable, batch totals, plus hex dump / byte array / binary string). A Time Converter turns timestamps and dates into each other (local, T-separated, UTC, ISO 8601 and relative) one value per line, with foldable results and copies that carry results only. A CSV Editor page puts a CodeMirror source pane next to an editable grid: 100k rows without freezing, two-way cursor sync, in-cell editing plus a CodeMirror popup for long values, editable headers, row/column insert-delete-sort with undo, find & replace one at a time, the matching cell highlighted in the source, and a Markdown preview rendered as a real table; A Code Gen page turns a JSON sample or a CREATE TABLE into TypeScript / Go / Java / Python models, and a Chart page renders an ECharts option (or bare numbers) as a real chart, 700 x 400 by default with custom width and height, exported as PNG or SVG, a Data Stats page turns delimited text into count / sum / mean / max / min / distinct / standard deviation, optionally grouped by another column, with source line numbers in the preview and two-way caret syncing, click a cell to copy it, hide the columns you don't need, and big tables lazy-load in batches, A SQL Analysis page queries a pasted table in place through its own plain-JS offline engine (SELECT / WHERE / GROUP BY + HAVING / ORDER BY / DISTINCT / LIMIT, six aggregates and twelve scalar functions); Chinese column names complete as you type, clicking a preview header inserts the column, right-clicking a selection runs it, several statements run one at a time in their own tabs with a failing one never stopping the rest, and nothing ever runs on its own — data comes in as .csv / .tsv / .txt / .xlsx and statements as .sql. and a QR code page turns any text into a batch of codes (size, error correction, margin and colours adjustable, an icon in the middle, PNG or SVG export) or decodes pictures back into text. The navigation bar is yours to arrange: drag the fourteen entries into your own order, pin the ones you use most (they are the last to fall into More when the window narrows), keep the bar sticky, or move the whole thing into a left-hand column that folds away with one click; the setup is remembered along with the layout. Press Ctrl/Cmd + K to search the panel by Chinese, English, synonyms, full pinyin or initials — formats, conversion directions and the tabs inside each page included. Pure frontend, no backend, works offline.

data-convertjsonsqlcsvbase64chartcodegenqrcodebytetimestampstats

Permissions

3 permissions

host.clipboard:readhost.storagehost.workbench

Permission codes are granted at install time and shown verbatim from the manifest.

Install in DBX

Click Install in DBX and confirm in the app. Prefer manual steps? Open the DBX Plugin Center, choose Install from URL, and paste the link for your platform — packages are signature-checked before install.

Install in DBX
PlatformSizeSHA-256Download
universal1.2 MB615385a6b7caa33a…Download

Versions

  • v0.2.1Nov 1, 2026Latest

    **新增「CSV 编辑」页**:左边 CodeMirror 源码、右边可编辑表格,两块互相定位——点表格某行源码就跳到那条记录,源码里一挪光标表格跟着选中。十万行不卡(分块解析 + 只渲染视口内的行),单元格双击行内改、点右上角那枚铅笔开放大弹窗改(CodeMirror),表头也能改;行 / 列增删、按列升 / 降序、撤销重做都在工具栏上;支持搜索定位与「一个一个替换」;选中哪一格,源码里那颗格子就精确高亮、行号槽同时打一道竖条;Markdown 页签直接把结果渲染成表格。复制 / 下载改成右下角提示,不再靠工具栏末尾那行小字。 **每个编辑器都有选区右键菜单**:在任一页的编辑器里选中一段、右键,就地转义(Base64 / URL / JSON / 换行,另有 HTML / Unicode / Hex / SQL / 正则)、整理(去空白、按行去重、排序、反转、JSON 美化 / 压缩、加行号、拼接成一行、大小写、包引号)、生成 SQL(`IN` / `NOT IN` / `INSERT`)或转成二维码图片;结果直接进剪贴板,**不改动你原本的内容**。剪贴板里的图片也能直接贴成 Base64 / Data URI / `<img>` 标签。JSON 美化走词法重排,18 位 ID 不会被 `Number` 改掉末位;菜单支持上下键、子菜单与 Esc,在菜单里滚动不会把它关掉。「SQL 分析」页维持原本的菜单,行为不变。 写不进图片剪贴板的环境(DBX 宿主就是)里,二维码那一项会自动改叫「保存为 PNG 图片」并真的存文件,不会假装复制;能写位图的浏览器 / 预览里就是「复制为二维码图片」。 **「SQL 转换」吃得下中文列表**:顿号「、」、全角逗号「,」、全角分号「;」、竖线(`|` / `|`)都当分隔符,引号里的不拆;拆完每个值再清一遍空白——零宽字符、Excel 带来的不间断空格、全角空格、连续空白一并规整,去重才合得掉,值中间的普通空格保留(`New York` 不会变成 `NewYork`)。18~19 位长 ID 全程按字符串走,不丢精度。 修掉二维码页卡片上「复制图片」按了完全没反应的问题:它调了一个不存在的函数,错误落在 async 里没人接,既不复制也不存盘、连提示都没有;现在与右键菜单共用同一条链路,真的复制或存文件。

  • v0.2.0Oct 30, 2026

    **新增「SQL 分析」页**:贴一张表(或导入 .csv / .tsv / .txt / .json / .xlsx)就能直接用 SQL 查它。引擎是随包发的纯 JS 离线实现,零依赖:SELECT(表达式、DISTINCT、AS、CASE WHEN)、WHERE(AND / OR / NOT / IN / LIKE / BETWEEN / IS NULL)、GROUP BY + HAVING、ORDER BY(多列)、LIMIT / OFFSET,6 个聚合与 12 个标量函数;没用 duckdb-wasm 是因为宿主沙箱的 CSP 不允许 wasm、connect-src 也是 none,而它的 wasm 一个就 35~41 MB。5 万行实测:分组聚合 13 ms、全表排序 25 ms。 **写 SQL 不费手,也不替你决定**:补全只补这一页真能跑的列名 / 表名 / 函数 / 关键字,中文列名打一个字就弹,点数据预览的表头直接把列插到光标处;Ctrl/⌘ + Enter、右键「执行所选 / 执行当前语句」、行号边那排 ▶ 都能跑。改数据、换分隔符、点示例、导入文件一律只摆到位,永远不自动执行。 **多条语句逐条跑**:; 与全角 ;都当分隔符,每条一个页签,某条出错只把它的页签标红并写清「第 N 条:…」,后面的照跑;结果面板顶上写明这张结果对应哪一句;-- 与 // 都是注释,只有注释的段落不算待跑语句。 **写过的 SQL 关掉再回来还在**:停手 800 ms 记一份,切页 / 点运行前再补写;24 KB 以内原样存,更大先 gzip 再 base64,压完仍超过 128 KB 就不存;恢复时框里已有内容不覆盖。 **JSON 直接当数据**:整段是 JSON 数组就自动摊成表——对象数组按首次出现的键做列名、缺键留空,二维数组取首行当表头,标量数组是单列;只取一级,嵌套值整体当一个单元格。不是数组就直接报错,不去猜该取哪个键。 **关掉再打开,回到上次用的那个功能**:导航点哪一项、或在「从 / 转为」里配了哪一对格式,都记下来,下次直接落回那里;存档形状不认识、字段缺失、JSON 坏了都当没存过,导航项改名或删掉时安静留在默认页。 **界面**:SQL 分析页工具栏合成一行(怎么读数据|快捷语句|导入 / 清空 / 运行),「示例」收成数据标题行上的下拉;SQL 区默认高度从 9.5 rem 提到 13 rem 且可拖动(双击回默认、方向键微调、跨会话记住);结果 1000 行封顶、100 行一批懒加载,「复制结果」出整表 TSV;数据预览有源码 / 表格两个视图,点单元格复制原值。 **修复**:宿主里切语言只生效一半(语言码与主字典分开赋值,导致导航英文、按钮中文)——现在统一走 setLanguage(),<html lang> 也跟着切;「列类型」下拉点了没反应(open 类加错元素、面板被滚动区裁掉);暗色主题下 SQL 编辑区仍是白底(--surface 从未定义)、跑完一直顶着满格进度条、空徽标画成灰胶囊、失败页签空态文案误导;宿主里拖不动分隔条与表格视图不生效(WebKit 的 PointerEvent 差异、.editor-container 的 display: flex 压掉 [hidden]);宿主标签页名字现在跟着当前功能走。 **SQL 引擎**:修掉 4 个会算错结果的 bug——MIN / MAX 对文本列返回 null、NULL = NULL 被判成 true、比较运算返回 JS boolean、LIMIT 1+1 静默失效;另修 GROUP BY 不认别名、ORDER BY 表达式不能用别名、GROUP_CONCAT 丢分隔符、未知函数静默返回 null;DISTINCT 整行去重并先于 LIMIT,HAVING 支持别名 / 聚合 / 混用。27 个关键字与 18 个函数进回归测试(SQL 用例 151 → 228)。 **工程化**:CI 之前从第一步就挂——package-lock.json 里 36 个 tarball 指向国内镜像,runner 连不上导致 npm install 超时;锁文件回到 registry.npmjs.org,并加 .npmrc 的 replace-registry-host=always。现在 CI 按契约跑 npm ci → npm test(22 个套件 1270 条)→ 页面冒烟 → 清单 / 内联脚本检查。

    Artifacts
  • v0.1.9Oct 28, 2026

    「数据统计」页再补三件事:预览与统计结果里**点单元格即复制**(光标是复制手势、格子闪一下、toast 报出内容);预览右上角「全部列」下拉能勾掉不想看的列,统计与复制仍按整表算;大表**按 100 行一批懒加载**,滚到接近底部自动补下一批,表尾也有「加载更多」。 新增「数据统计」页:贴一段分隔符文本就出计数 / 求和 / 均值 / 最值 / 去重 / 标准差,勾表头选列、一列没勾时自动挑数字列,还能按某一列分组;预览表最左一列是原文行号,点行跳到编辑器同一行,光标移动也会点亮对应行。复制分单列 / 所选列(按表复制,贴回表格软件是真正的一列列)/ 统计结果三种。 功能搜索搬进了顶栏:点放大镜(macOS 上 ⌘K、Windows / Linux 上 Ctrl+K)就把导航那一行让给搜索框,不再有浮层压在页面或「从 / 转为」工具栏上——输入时导航自动收起,退出立刻还原。中文、英文、近义词、全拼、首字母都能命中:sj / shijian / 时间戳 / unix 都指向时间转换,bt / 对比 / diff 都指向 JSON 对比,jiami / encode 都指向转义工具。 格式也能搜:toml、从 toml、转为 toml 直接跳到对应那一侧;页内的二级功能同样进了索引,转图片、INSERT、Schema 校验、Go / Java / Python、解码 都能直达并选中对应 tab。结果分档排序为「页面 → 转换方向 → 页内 tab → 格式」,搜 json 不会被格式项淹没;↑↓ 移动、回车进入、Esc 收起,中文输入法上屏时的回车与数字键一律不抢。左侧导航现在一键收起 / 展开,状态和顺序、置顶、吸顶一起记住;纯图标按钮悬停会给出当前语言的说明。 修掉三处:拆分文件时把一段约定注释写成了真正的 script 标签,宿主用正则扫描时去读那个不存在的文件,整页返回 400(现在注释是纯文字,并有测试全量扫描守着);侧栏分割线旁那条浅浅的色带其实是导航列表的滚动条轨道,现在整列只有一个滚动容器且滚动条隐藏,分割线是一条完整的 1px 线、内容留出 5px 间距;在桌面宿主里用中文输入法打字,按数字选词没反应——空值时搜索框会清空自身并收起,Blink 容忍这种写法,WebKit 直接撤掉候选窗,现在组词期间不重排、不清值、不收起。 另外,页面从一个两万行的文件拆成 18 个模块加一张样式表,下次加功能有明确的位置。

    Artifacts
  • v0.1.8Oct 27, 2026

    Your navigation bar now fits the way you work: a sliders button in the top bar opens Navigation settings, where the eleven entries can be dragged (or nudged with arrows) into any order and the ones you reach for most can be pinned — pinned entries stay in front and are the last to fall into the More menu when the window narrows. Sticky navigation bar keeps the bar at the top while content scrolls, and in the left-hand column pinned entries stay glued to the top as the column scrolls. Everything is remembered across reloads and restarts through the host plugin storage, stored under its own versioned key so rolling back to an older build is safe and upgrading again keeps your setup; new entries are appended to the end automatically, no migration needed. Also fixed: the More menu no longer scrambles pinned and unpinned entries together, and dragging a row now works inside the workbench, where the host webview takes over native drag and drop — reordering runs on pointer events instead. Generate QR codes in batches, or read them back out of pictures. One line becomes one code — a column of links, ids or any short text turns into a wall of codes; switch the split to whole block and the line breaks stay inside a single code. Size, error correction, margin, foreground and background colours are all settings, and an icon can sit in the middle (uploading one pushes the error correction to H, the only level at which a code with a hole in the middle still decodes). Cards fold down to their number plus a preview, jump the cursor back to the line they came from, copy their own text or image, and a single export opens a small panel where format, size and file name are settled on the spot — the choice is remembered for the next card; double-clicking a code opens it full screen in a lightbox that stays sharp at any zoom; the whole batch exports as a single tiled PNG. The second tab decodes dropped images, pasted screenshots or a batch of files into text, line breaks included. Both engines ship offline and load as blob: URLs, and text is encoded as UTF-8, so Chinese content decodes correctly. Your navigation can now live on the left. A layout button at the far right of the top bar moves the eleven navigation entries into a vertical column (13rem wide) and hands the content area the same space back; click again to return to the top, which stays the default. On the left the top bar keeps only the brand, the language switcher and this button; the format-convert picker moves to the top of the column and expands inside it, pushing the entries down instead of floating over them. The vertical column fits every entry, so "More" no longer appears. Your choice is remembered across reloads and app restarts through the host plugin storage (the workbench sandbox has an opaque origin, so localStorage is not available there); when the host cannot store it, the plugin falls back to browser localStorage and then to window.name, which is the only channel that survives inside the dbx-plugin dev sandbox (localStorage, sessionStorage and cookies all throw there). A small fix rides along: navigation entries and the gaps between them are tighter, so all eleven still fit a 1440-wide window now that the button and the eleventh entry are there. All twelve pages stay translated into 14 languages, and everything still runs locally: no network, no eval.

    Artifacts
  • v0.1.7Oct 26, 2026

    A new Time Converter page turns timestamps and dates into each other. Paste one value per line — 2020-01-01, 2020-01-01 00:00:00, 2020-01-01T00:00:00, 1577836800 or 1577836800000 — and every line is converted into the notations you enable. Five shortcut buttons — Now, Today start, Yesterday, Week start and Month start — append the matching moment as a new line in one click, truncated to the second. Seven toggles cover Unix seconds, Unix milliseconds, local time, local time with T, UTC, ISO 8601 and relative time; local and local-with-T are on by default, so the everyday 2020-01-01 00:00:00 <-> 2020-01-01T00:00:00 swap works out of the box. Results come as one card per line: the header folds it away, moving the caret to line N highlights card N, every value copies on click, and the Copy button writes results only — one output line per input line, fields joined by spaces, no index, no original value, no labels. Relative time stays for reading and never enters the copy. A batch caps at 2000 lines and a bad line is flagged on its own. All eleven pages are translated into 14 languages, and everything runs locally: no network, no eval.

    Artifacts
  • v0.1.6Oct 24, 2026

    Every page can now import a file — the page you are on handles it, and the size limit is shown on the drop overlay before you release. The Chart page also digs charts out of real backend exports: a task list whose payload is itself serialized JSON, business keys six layers deep with thousands of table rows in between. Charts that used to be missed are now listed in a Chart picker by title, and the status line says so when an input is too large to scan completely. Charts are always drawn on the light palette with a white background, so a dark theme no longer changes the image you export. 0.1.6 (update): a new Chart page renders an ECharts option — or just an array of numbers — as a real chart, 700 x 400 by default with an editable width and height, exported as PNG at 1x / 2x / 3x or as vector SVG; the ECharts 6.1.0 engine ships inside the package, loads only when you open the page and works inside the DBX sandbox. The Image ⇄ Base64 page gained file import, so everything it exports can be imported back. Every save now reports what actually happened (saved, downloaded, cancelled or failed) instead of always claiming success. All ten pages are translated into 14 languages, and everything runs locally: no network, no eval.

    Artifacts
  • v0.1.5Oct 23, 2026

    0.1.5 (update): a new Byte Converter page converts B / KB / MB / GB / TB / PB on the 1000 and 1024 scales side by side (1234567890 → 1.23 GB and 1.15 GiB), goes back from a human-readable value to an exact byte count, handles batches of sizes with a running total, and turns byte sequences (1f 8b 08, [0x1f, 0x8b], binary, xxd dumps) into hex dump / byte array / binary string. The Convert page now handles 13 formats in any source/target combination — TOML, INI, .env, CSV, TSV, query strings, HTTP headers, cookie strings and HTML tables join JSON / YAML / XML / Properties. A Query page runs JSONPath and jq-style expressions and validates against a JSON Schema draft-07 subset, an Escaping page converts both ways between URL / Base64 / HTML / JSON string / \uXXXX / hex / SQL / regex, and Code Gen turns JSON or CREATE TABLE into TypeScript / Go / Java / Python models. All nine pages are translated into 14 languages, and everything runs locally: no network, no eval, with hard limits on size, rows and columns.

    Artifacts
  • v0.1.3Oct 21, 2026

    Initial release with multi-format conversion, mock data generation, and i18n support.

    Artifacts