它是如何确定 SQL 数据类型的？

该工具会检查您的 JSON 文档中的值。字符串映射到 `VARCHAR`，整数映射到 `INT` 或 `BIGINT`，浮点数映射到 `DECIMAL` 或 `FLOAT`。

嵌套对象和数组会发生什么？

嵌套对象通常会被扁平化或建议作为带有外键的单独表。对于 PostgreSQL 等现代 SQL 方言，您也可以选择将它们视为 `JSONB` 列。

它支持复杂的 BSON 类型吗？

是的，常见的 BSON 类型如 `ObjectId`、`ISODate` 和 `NumberDecimal` 会被识别并转换为它们的等效关系类型，如 `UUID`、`TIMESTAMP` 和 `NUMERIC`。

我的数据会发送到服务器进行处理吗？

不会。所有映射和 Schema 生成都在您的浏览器会话中本地完成。您的文档结构和数据绝不会离开您的设备。

格式化与代码

NoSQL → SQL 迁移助手

MongoDB document shape → relational schema sketch.

Runs in your browser

MongoDB-style document · source

lines: 21chars: 312size: 312 B

Suggested SQL schema · result

CREATE TABLE posts (
  id BIGSERIAL PRIMARY KEY,
  document_id BIGINT REFERENCES document(id),
  title VARCHAR(255),
  views INTEGER
);

CREATE TABLE document (
  id BIGSERIAL PRIMARY KEY,
  name VARCHAR(255),
  email VARCHAR(255),
  age INTEGER,
  active BOOLEAN,
  address JSON,
  tags JSON
);

lines: 16chars: 295size: 295 B

live

编辑注

Understanding · Documents into rows — the migration nobody wants twice.

本深度章节目前仅有英文版本。上方的转换工具支持您的语言;长篇说明文章尚未翻译。

常见问题

Quick answers.

›How does it determine SQL data types?

The tool inspects the values in your JSON document. Strings are mapped to `VARCHAR`, integers to `INT` or `BIGINT`, and floating point numbers to `DECIMAL` or `FLOAT`.

›What happens to nested objects and arrays?

Nested objects are typically flattened or suggested as separate tables with foreign keys. For modern SQL dialects like PostgreSQL, you can also choose to treat them as `JSONB` columns.

›Does it support complex BSON types?

Yes, common BSON types like `ObjectId`, `ISODate`, and `NumberDecimal` are recognised and converted to their relational equivalents like `UUID`, `TIMESTAMP`, and `NUMERIC`.

›Is my data sent to a server for processing?

No. All mapping and schema generation happens locally within your browser session. Your document structure and data never leave your device.

大家也在搜索

More in this room.

查看所有格式化与代码