格式化与代码
SQL → NoSQL 模式转换器
Turn a CREATE TABLE into a JSON document shape.
编辑注
Understanding · Normalise or embed — the design decision that follows the queries.
本深度章节目前仅有英文版本。上方的转换工具支持您的语言;长篇说明文章尚未翻译。
常见问题
Quick answers.
›How are SQL data types mapped?
Common types like `VARCHAR` and `TEXT` map to strings, `INT` and `DECIMAL` to numbers, and `BOOLEAN` to true/false values. More complex types like `TIMESTAMP` are generally formatted as ISO-8601 strings.
›Does this tool support all SQL dialects?
It supports standard ANSI SQL `CREATE TABLE` statements. While specific dialect features like PostgreSQL enums or MySQL spatial types might be simplified, the core structure remains accurate for most document databases.
›Can it handle table relationships?
SQL foreign keys are converted into flat fields by default. Since NoSQL often prefers embedding over linking, you can use the output as a base to manually nest related objects into a single document.
›Is my schema private?
Yes. The parsing logic is executed locally using JavaScript. Your database structure is never transmitted to our servers or logged in any database.
大家也在搜索
相关工具