How to use SQL Schema to Data Dictionary
- Paste CREATE TABLE declarations using the supported plain types, defaults and key constraints. Do not paste a full database dump.
- Run the parser. If a construct is refused, check the documented subset rather than deleting an important constraint just to obtain output.
- Review declared types, nullability, defaults and grouped primary, unique and foreign keys.
- Download the dictionary as CSV, JSON, Markdown, HTML or XLSX. Separate table import templates contain only column headings, with no records.
Example: SQL Schema to Data Dictionary
Document the four declared customer columns and create an empty import template.
Options
- CREATE TABLE declarations
- Up to 100,000 UTF-8 bytes, 20 tables and 200 columns total. A strict declared subset, not a complete SQL validator.
Supported inputs and limits
- Up to 100,000 UTF-8 bytes, 20 tables and 200 columns in total.
- Supported CREATE TABLE syntax includes listed plain types, bounded type parameters, NULL/NOT NULL, literal or supported current-date/time defaults, and primary, unique and foreign keys.
- CHECK, generated columns, collations, auto-increment options and unsupported dialect extensions are refused.
- No database is accessed or SQL executed.
- Exports describe the supplied declarations; database-specific behavior still needs review.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Declared constraints are not a live schema check
The dictionary reports the supported SQL you supply. Nullability is shown as declared, and composite keys remain groups rather than separate unique columns. It does not infer descriptions or prove that a running database has the same schema. Keep unsupported constraints in the original SQL and review them with the relevant database tooling; removing them changes what the dictionary describes.
Questions about SQL Schema to Data Dictionary
Can it read any SQL dump?
No. Paste supported table declarations only. Other statements and unsupported clauses are refused.
Does the template include database data?
No. It contains column headers without records, for preparing an import.
Are types converted to a common database type?
No. The dictionary retains the declared type text so it does not silently reinterpret your schema.